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?

I'd be interested 🙌 


sharing in return our experience at Ledger serving web3 data at web2 scale :))

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

I'd be interested 🙌 


sharing in return our experience at Ledger serving web3 data at web2 scale :))

https://www.ledger.com/blog/serving-web3-at-web2-scale

blockchain engineer @ https://openfort.xyz /
https://unchained-onchain.xyz / built @factchain / opinions entirely those of others / rekt 👎 ship 👍

the no horizontal scalabillity for postgresql point in your article is interesting. yes not natively but now very well in Kubernetes

Cloudnativepq is awesome
Zalando has a project to solve it
and crunchy data has their postgres operator which is nice