Databases are just big spreadsheets. That's the mental model this article explores for understanding how indexes work.
By framing databases as spreadsheets, the article provides an accessible way to reason about index selection and ensure performant queries. It's a helpful read for developers looking to solidify their understanding of how indexes really work under the hood.
Well, I've only used convex for some hobby projects, and I must say; It allows me to build real-time applications without having to configure websockets, and it allows me to build applications pretty fast.
Convex provides transactionally consistent subscriptions on arbitrary data joins/fetches out-of-the-box, simplifying complex data management challenges. Their recent blog post at https://stack.convex.dev/how-convex-works explains how this works under the hood.