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?

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

Yeah, of course. What was this migrated from?

Redis. Used to manually index what we needed there, and wanted to move to having more flexibility in our queries

Redis is so fast I let things get a little ridiculously complex before migrating to a DB but now that we've got some DB perf under our belt I'll be more likely to use Postgres sooner going forward and keep redis as a cache.

ah, I think this is my general approach as well?

Try to jam things into memory first -> start using redis when we need consistency across app instances -> start using db when we need more flexibility and permanence