sqlite-http

An HTTP interface for SQLite. Plays very nicely with Litestream for backup / replication.

Install

cargo install sqlite-http

Examples

Basic

sqlite-http --host 127.0.0.1:8080 --db-path ./example.db

Only receieve sqlite-http's logs

RUST_LOG=off,sqlite_http=trace sqlite-http --host 127.0.0.1:8080 --db-path ./example.db

Replicate with litestream (existing config assumes a running local MinIO instance)

litestream replicate -config ./etc/litestream.yml

Restore with litestream (existing config assumes a running local MinIO instance)

litestream restore -config ./etc/litestream.yml -replica "S3 Backup" ./example.db

Collecting Metadata

Using the --collect-metadata flag creates a __metadata_query table that may be useful in debugging and performance monitoring. Its schema is as follows.