Technology
OpenRun adds built-in Litestream support for SQLite database replication
The self-hosted GitOps platform now manages automatic SQLite replication and disaster recovery across Docker, Podman, and Kubernetes environments.
The short version
- OpenRun has integrated Litestream support into its open-source platform, allowing SQLite databases to continuously replicate to S3-compatible object storage.
- The system automates database restoration on empty or recreated volumes without requiring changes to application code or container images.
- Disaster recovery and continuous replication are managed asynchronously outside the main application container across single-node and Kubernetes deployments.
Key facts
- OpenRun integrated native Litestream support into its open-source GitOps platform to automate SQLite continuous replication to AWS S3 or S3-compatible storage.[Hacker News]
- Database restoration occurs automatically before application containers start whenever OpenRun detects an empty or recreated volume.[Hacker News]
- On Docker and Podman environments, Litestream runs in a companion container sharing a data volume, while on Kubernetes, OpenRun adds an init restore container and a sidecar container.[Hacker News]
- OpenRun embeds Litestream as a Go library to replicate server metadata and audit databases without launching an extra process.[Hacker News]
- Replication occurs asynchronously with a default sync interval of about one second.[Hacker News]
What remains uncertain
- An abrupt system crash can cause data loss for writes made within the default one-second sync window before reaching object storage.[Hacker News]