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?

data @ paradigm

https://github.com/sslivkoff

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

I am super curious about it and how it compares to the tech that @notnotstorm is using with Cryo

Im the guy that posted all those factory memes once

Ok interesting, I don't think it could be more performant than what I've written since it uses the same RPC calls. What we were optimizing was our queries of that data after we've indexed it in Postgres. I don't think there's a way, if using RPC, to improve much on the initial query latency.

That does look super convenient though and I'm interested in the bit of their README that mentions a future improvement to query a node directly. eth_getLogs is so incredibly maddening to use

happy to answer any questions here or in the cryo tg group