SQLite

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. It reads and writes directly to ordinary disk files.

When to Use

• Embedded Mobile & Desktop Client Applications: The standard embedded database engine for iOS, Android, macOS, Windows, and Linux apps.
• Edge Computing & Local Cache: Running fast relational databases inside Cloudflare D1, Turso, or local container storage.
• Zero-Configuration Local Development: Powering unit tests and local prototypes without spinning up external database servers.
• High-Read Single-Server Web Applications: Serving millions of read queries per day with SQLite Write-Ahead-Logging (WAL) mode enabled.

Quick Start

-- Enable WAL mode for concurrency
PRAGMA journal_mode=WAL;