Index the Allo protocol on-chain events blazingly fast

• The only storage backend for the whole indexer is a single PostgreSQL db. We use it to store both typical values, JSON & use it as a key-value store
• Token prices are indexed from on-chain AMMs, no need for an external service
• This also obviates the need for block time estimates.
• Passport is ingested in batch mode
• The only dependency is an RPC and a DB connection
• We use Supabase as the default host for the DB, making the data easily publicly queryable
• All of the data in the database is public, allowing for a public connection credential for general access
• Blocks, IPFS data and prices are immutable, and we can cache them inside of Postgres
• We can restore postgres dumps of the immutable data do spin up a new instance instantly
• We index chains in parallel
• We fetch block ranges and IPFS files in parallel
• We index per-round, making the initial startup time almost instant
• HTTP API is fully decoupled from the indexer workers, allowing changes without redeploys
• Basic QF calculations (without overrides or estimates) can be done in-database as a materialized view and automatically updated and cached
• We use Kani for verification of the correctness of the QF and QV algorithms