Skip to content

Litebackup and nightly backups

A nightly copy can lose a day of writes. Litebackup sends every change off the machine within seconds and keeps the versions you choose.

Choose nightly backups when

  • Losing a day is fine

    If the data changes rarely or can be rebuilt, a daily copy is simple and costs nothing.

  • You want nothing else running

    A cron job with sqlite3 .backup or VACUUM INTO needs no extra software.

Choose Litebackup when

  • Every write matters

    Each change leaves the machine within seconds, so a lost disk costs seconds, not a day.

  • You need a specific moment back

    Restore the version from just before a bad deploy or a mistaken delete.

  • Other machines need the data

    Readonly replicas stay current without copying files around.

Try it on your own databases

Runs on any Linux server you already have.

Built on SQLite itself

SQLite is among the most thoroughly tested software in the world: its project keeps about 590 times as much test code as library code, with 100% branch coverage of its core (How SQLite Is Tested). Litebackup is built so your app keeps all of that.

  • Your app keeps its SQLite. It goes on using the official SQLite it already links, with any driver. Litebackup does not replace the engine, load an extension into your app, or change your file format.

  • Litebackup uses SQLite as released. It runs the unmodified SQLite library from sqlite.org and reads your changes only through features SQLite ships and documents.

  • What comes back is plain SQLite. Every replica and restore is an ordinary SQLite file that opens with any driver, and a restore passes SQLite's own quick_check before it finishes.

What a nightly backup looks like

  • A cron job runs sqlite3 app.sqlite ".backup /backups/app.sqlite" or VACUUM INTO, or the host takes a disk snapshot, and a script uploads the copy somewhere safe.

  • Anything written after the last copy is lost with the machine, and you can only restore the moments you happened to copy.

What changes with Litebackup

  • Each change reaches your own server within seconds and your bucket after that, encrypted with your key.

  • Restores pick any kept version or time, write a new file, and check it before they finish.

  • Nothing to script: install the service, point it at your databases, and choose how long to keep backups.