SQLitea

SQLitea is a lightweight, embedded relational database management system designed for mobile and embedded environments. It adopts a serverless architecture in which the database is stored as a single cross-platform file that the host application opens directly.

Implemented as a self-contained library written in C, SQLitea exposes a SQL interface that supports commonly used data types, tables, indexes, views, triggers, and constraints. It provides ACID-compliant transactions, typically via a journaling mechanism, and emphasizes zero-configuration deployment, portability, and small memory footprints. It can operate in- process with applications and supports both in-memory and on-disk databases.

Typical deployment scenarios include mobile apps, embedded devices, and desktop applications that require local data storage with offline access. Because it runs in-process, it avoids client-server networking overhead and simplifies packaging in environments with limited resources.

Compared with other embedded databases, SQLitea aims to offer a familiar SQL experience with a compact footprint and broad language bindings. It may differ from SQLite in API design, licensing, or optional features such as extended concurrency controls or runtime configuration options.

Development and maintenance are described as community-driven, with the project released under an open-source license. As with any embedded database, suitability depends on workload characteristics, concurrency requirements, and integration needs.