Backend

An engineer on my team has been working on a migration of some indexed blockchain data to postgres and took our queries from an initial average latency of almost 2 seconds to under 100ms. The process to get there was fascinating, imo. Would anyone else be interested in a writeup of the optimization techniques he used?

For the Ethereum to Postgres usecase, I've heard that people really like @indexsupply's Shovel project, which is extremely fast:

Indexing Ethereum https://indexsupply.com

Head of Engineering at Courtyard.io, bringing physical collectibles onchain. nf.td/joe /courtyard /backend

For the Ethereum to Postgres usecase, I've heard that people really like @indexsupply's Shovel project, which is extremely fast:

https://indexsupply.com/shovel/