Spade Oracle integration

[vasco-santos]

We need to get the following information from Spade state

• poll state of an aggregate (did a previous offered aggregate landed into a SP? did it fail?)
• get details from the deals that exist for each aggregate previously submitted

Schema can be seen https://raw.githubusercontent.com/ribasushi/fil-naive-marketwatch/master/misc/pg_schema_diagram.svg

Open questions:

• is it a PostgresDB? can we have credentials for a replica RO?
• Is there any roadmap to expose this as an API rather than requiring all clients to connect to DB and do queries themselves?
• Are there docs about queries we should make?
  • for instance, there is pieceCid in the schema above, but how can we query for an aggregate commD and see its state?

[anjor]

• It is a postgres instance.
• Currently there isn't anything on the roadmap to expose this as an API -- at least nothing on the data programs side. There might be other wider efforts in this area.
• The pieceCid in the schema will be the aggregate pieceCid.

[vasco-santos]

@anjor one followup question. In case of failures, as discussed yesterday we should create a report API and align with you on how it would like in terms of data schema. So, curious on what happens in your DB if something fails. Is it simply not in the table?

Thinking about above, what is the database state over time? Spade will poll us, and will at some point have an aggregate to match to SPs. While this is happening, and until SPs have a contract with web3.storage and get things stored, is it available on your DB? Or is it only there once it gets successfully stored?