The goal of this PR is to store announced chain content received from content-watcher in a persistence layer instead of just an in-memory cache, so that on subsequent restarts the SAT backend doesn't have to wait to ask content-watcher to search the chain for all the content it wants.
Also, using SQLite as the persistence layer makes it easier to store/query replies associated with primary posts.
TODO:
[x] retrieve replies & reactions associated with posts correctly
Purpose
The goal of this PR is to store announced chain content received from content-watcher in a persistence layer instead of just an in-memory cache, so that on subsequent restarts the SAT backend doesn't have to wait to ask content-watcher to search the chain for all the content it wants.
Also, using SQLite as the persistence layer makes it easier to store/query replies associated with primary posts.
TODO: