Sirannon documentation
Sirannon is an open source data layer that turns SQLite into a networked service with connection pooling, change data capture, migrations, backups, replication, and a client SDK.
Getting started
1 guide
Core features
6 guides
Queries and transactions7 min readRun parameterised SQL, batch statements, wrap work in transactions, and tune the connection pool behind every database.Bulk load5 min readImport a large dataset in one transaction under relaxed durability, then restore the configured writer durability, so a big load pays one durability barrier instead of one per row.Change data capture4 min readSubscribe to row-level insert, update, and delete events as they commit, with filters and ordered sequence numbers.Migrations4 min readVersion your schema with SQL files or programmatic migrations, apply them transactionally, and roll back to any version.Backups2 min readTake consistent one-shot snapshots with VACUUM INTO, or schedule rotating backups on a cron expression.Hooks, metrics, and lifecycle5 min readIntercept operations with before and after hooks, feed timings into your metrics system, and let the lifecycle manager own multi-tenant database handles.
Networked access
2 guides
Distributed
1 guide
Operations
1 guide