(2024-10-13) Willison Zero Latency Sqlite Storage In Every Durable Object

Simon Willison: Zero-latency SQLite storage in every Durable Object. Zero-latency SQLite storage in every Durable Object (via) Kenton Varda introduces the next iteration of Cloudflare's Durable Object platform, which recently upgraded from a key/value store to a full relational system based on SQLite.

a really interesting way to architect a large scale application.

Kenton presents the example of a flight booking system, where each flight can map to a dedicated Durable Object with its own SQLite database - thousands of fresh databases per airline per day.

Each DO has a unique name, and Cloudflare's network then handles routing requests to that object wherever it might live on their global network