Ian's solution at blog.exe.dev/we-taught-sq... is clever. Associate cache entries with the WHERE clause they were produced by and invalidate when updates hit the same WHERE clause. Made possible by some code-generation and a single-writer database.
blog.exe.devWe Taught sqlc to Invalidate Our Caches - exe.dev blogHow exe's proxies stay fast and correct without anyone hand-writing invalidation logic.
0 reposts2 likes