Transitioning SQLite from a local development tool to a production-grade database requires a deep understanding of its internal mechanics. This article explores how to tune WAL mode, manage busy handlers, and leverage custom Virtual File System (VFS) layers to achieve ultra-low latency.

Durable queues, streams, pub/sub, and scheduler on SQLite. One file, zero servers.

Convert CSV files into a SQLite database.

Isso integrates with Shaarli.

They don’t allow outside contributions.

All of the facts are interesting but the one above was especially of interest to me. 🦖 Fossil (a kinda fun VCS) is based on SQLite.