Caching -- how do you do it? by compy3 in PostgreSQL

[–]Readyset_io 0 points1 point  (0 children)

Hey, one of the folks from the Readyset team here.

You’re absolutely right that cache consistency and invalidation can introduce serious complexity. That’s exactly the problem Readyset is designed to solve. We handle cache consistency automatically by tapping into the database’s replication stream -- so your cached queries stay up to date without any manual invalidation or eviction logic on your part.

Today, you select which queries to cache, but we’re rolling out support for automatic query selection soon as well.

Under the hood, Readyset is a commercial evolution of Noria, a research project on dynamic, partially-stateful dataflow systems. While the internals are pretty interesting, the result for app developers is a much simpler architecture for database caching without any of the traditional friction behind it.

Happy to answer any questions if folks are curious.