sqlite3_rsync
Shares rank 14 of 19 backup tools by recommenders
Copies a live SQLite database to another location safely, including while writes continue, which people use for backups and replication.
Copies a live SQLite database to another location safely, including while writes continue, which people use for backups and replication.
6 people gave an opinion
- recommend it
- 6
- criticize it
- 0
- approval share
- 100%
Recommended in 4 of 13 months
- November 2025: not recommended
- December 2025: recommended
- January 2026: not recommended
- February 2026: not recommended
- March 2026: not recommended
- April 2026: recommended
- May 2026: recommended
- June 2026: not recommended
- July 2026: not recommended
- August 2026: not recommended
- September 2026: recommended
- October 2026: not recommended
- November 2026: not recommended (month in progress)
Why it doesn’t carry the badge
- 6 people recommend itNeeds 10 or more, not met.
- Nobody criticizes itNeeds 2 to 1 or better, met.
- Recommended in 4 of 13 monthsNeeds 4 or more, met.
The same three rules apply to every product, and the badge can’t be bought. How the badge works
What people say about it
The reasons people give, with the number of comments that give each one. Open a reason to read what they said.
Why people recommend it
Each mark is one comment
Used for live database backups
“a dumber, less granular solution using sqlite3_rsync and nightly backups”
Comment from 29 May 2026 in “SQLite is all you need for durable workflows” “exist to safely create backups of live databases.”
Comment from 7 Apr 2026 in “SQLite in Production: Lessons from Running a Store on a Single File” Copies databases while writes continue
“A snapshot of the origin is used so writes can continue happening while the sqlite3_rsync is running.”
Comment from 7 Apr 2026 in “SQLite in Production: Lessons from Running a Store on a Single File” “What's cool is the newest version of rsync lets you replicate while in journal mode”
Comment from 3 Dec 2025 in “100k TPS over a billion rows: the unreasonable effectiveness of SQLite” Does what it is meant to
“This is probably going to do the trick nicely.”
Comment from 18 Sep 2026 in “Backups Aren't Simple” “It does just what you would expected to do.”
Comment from 17 Sep 2026 in “Backups Aren't Simple”
Other backup tools people recommend
The four most recommended other backup tools, with the same counts for each, so you can compare like for like. The tick on each bar marks the 2 to 1 line the badge needs.
| Product | Recommend | Criticize | Approval | Months | Owned | Badge |
|---|---|---|---|---|---|---|
| restic | 83 | 5 | 94% | 12 | — | Approved |
| pgBackRest | 32 | 6 | 84% | 6 | 1 yr4 owners | Approved |
| Borg Backup | 30 | 8 | 79% | 12 | — | Approved |
| iCloud Photos Downloader | 18 | 4 | 82% | 2 | — | — |
| sqlite3_rsyncThis page | 6 | 0 | 100% | 4 | — | — |
What people said
6 of the 7 comments that mention it, newest first. Each links to the original comment.
“This is probably going to do the trick nicely.”
“It does just what you would expected to do.”
“a dumber, less granular solution using sqlite3_rsync and nightly backups”
“exist to safely create backups of live databases.”
“A snapshot of the origin is used so writes can continue happening while the sqlite3_rsync is running.”
“What's cool is the newest version of rsync lets you replicate while in journal mode”
Counts come from 1,795,640 Hacker News comments, November 2025 to November 2026. How we count. Report a mistake.