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?

Curating human insight | Follow @survey for polls | Visit weponder.io for more | By @ba and @cojo.eth

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

subgraphs from the graph protocol were supposed to be the solution here and somehow they ended up over optimizing for tokenomics and less of developer experience 

@ponder might be an interesting solution for this use case as well