jsonb on postgres is great, but the query language for nested/array/objects as well as jsonb indexes (when queries unexpectedly can't use them) are a bit tricky

Building FOSS via @frames, /open-frames to help decentralized social win. a16z CSX23. farcasterchannels.com farcaster.id

agreed on both counts

glad postgres supports nested structures — for a crazy moment people used nosql databases instead just to nest a few things

It’s worth diving deeper into optimization techniques to avoid those unexpected issues.

I’m not gonna lie, this sounds like wizardry to me! 🫣😂