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

• Mobile Apps: The standard for iOS/Android local storage.
• Edge/IoT: Low memory footprint.
• App File Format: Instead of a custom config.xml, just use a SQLite db file.
• Small/Medium Web Apps: With WAL mode, it handles surprising concurrency (PocketBase, Castopod).

Quick Start

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