Rivet, the open-source, self-hostable serverless platform, delves into the benefits of SQLite at scale, often overlooked in favor of small deployments. Highlighting the advantages of SQLite in high-scale systems over traditional partitioned databases like Postgres or MySQL, Rivet introduces Cloudflare Durable Objects and Turso as innovative solutions. These platforms offer dynamic scaling, infinite, cheap databases, global distribution, and built-in replication and durability. With its ability to enable local ACID transactions, efficient I/O, leverage existing extensions, handle SQL migrations, and lazy schema migrations, SQLite on the server proves to be a powerful alternative despite facing challenges such as lack of tooling, open-source solutions, and standard protocols.
https://rivet.gg/blog/2025-02-16-sqlite-on-the-server-is-misunderstood