# SQLite

SQL storage embedded in the application process.

## Comparison target

Relational · Embedded · Engine

Application owns the database file, lifecycle and backup procedure; no separate database server.

Components: No separate catalog component

Revision: 2026-09-14.1 · Review: unreviewed

Commissioned by a Nimbalyst maintainer. Documentation synthesis; no independent review or product execution.

## Applicability

Unpinned upstream documentation accessed 2026-09-14; pin engine, extension and service versions before use.. Application owns the database file, lifecycle and backup procedure; no separate database server..

## Claims

- **yes · documented**: Stores tables and queries them with SQL. [About SQLite](https://www.sqlite.org/about.html) Scope: Documented for this target; no runtime tests recorded.
- **yes · documented**: Runs as an in-process library. [About SQLite](https://www.sqlite.org/about.html) Scope: Documented for this target; no runtime tests recorded.
- **yes · documented**: Provides ACID transactions within a database file. [About SQLite](https://www.sqlite.org/about.html) Scope: Documented for this target; no runtime tests recorded.

## Open questions

- Which pinned versions, topology and service tier fit the intended workload?
- What are measured correctness, latency, recovery and total operating cost under that workload?

## Verification plan

1. Pin the target configuration and define workload fixtures, access and budget.
2. With authorization, test concurrent writes and recovery against explicit correctness expectations.
3. For vector workloads, measure filtered recall against an exact-search baseline and record index settings.

Last checked: 2026-09-14. Recheck by: 2026-10-14.

Content rights: Unlicensed prototype; redistribution decision pending.