elsirion / fedimint-observer Goto Github PK

It's a little tricky to remember which federation_id corresponds to which federation

The query UI should be read-only.

Might be easier to query it (e.g. get federation name) if it was in JSON form. Postgres has good support for querying JSON.

If an error like this is encountered, it will stop syncing:

2024-04-18T19:42:18.641647Z ERROR task{name="Observer for <federation-id>"}: fedimint_observer::federation::observer: Observer errored: error returned from database: (code: 5) database is locked

We nearly never care about the txid, whereas the session index and item index in a session is a perfectly fine primary key for transactions too, is shorter and we even care about sesssion indices often (so it's practical if we don't have to join over transactions to find the session of a tx input/output).

just b fails on latest master (https://github.com/elsirion/fedimint-observer/tree/09f93e68534dcdc84fa69380a15ca5c994787b3d).

error[E0433]: failed to resolve: could not find `Builder` in `task`
   --> /home/nix/.cargo/registry/src/index.crates.io-6f17d22bba15001f/fedimint-core-0.3.0-rc.3/src/task.rs:462:26
    |
462 |             tokio::task::Builder::new()
    |                          ^^^^^^^ could not find `Builder` in `task`

This failed locally when using nix develop from the root of this repo and also from a recent commit from fedimint/fedimint (https://github.com/fedimint/fedimint/tree/636282449edda8f5651e240a01326e28bb99ceae).

The current schema supports tracking a federation's fedimint transactions, however we're not currently storing on-chain identifiers (on-chain txid, vout, etc). This is necessary to construct the current UTXOs held by the federation.

I have a rough approach that parses the SessionOutcomes for wallet module transactions already observed federations.

@elsirion Do you have a preference for introducing migrations vs modifying schema/v0.sql and re-syncing a new database? The project seems early enough that we can modify without introducing a migration framework.