logoalt Hacker News

rfc2324today at 10:18 AM3 repliesview on HN

I'm a huge fan of Pocketbase. Backing up the sqlite though had me more stressed than I'd prefer, and I wanted a plug-and-play way to sqlite3_rsync a backup while Pocketbase was running: so I've been working on this: https://sqlrsync.com. MVP works. Billing isn't being checked yet (be gentle but it's Cloudflare Durable Objects underneath so it should be local, fast, and resilient.) Would love feedback from anyone open to trying it.


Replies

pdimitartoday at 3:11 PM

Sorry if my question is misguided: did you try SQLite3's native online backup API? I would not use raw file access knowing they have that.

show 1 reply
trailbasetoday at 11:10 AM

Love seeing the love for SQLite. Personally, I've had a great experience with litestream, which will continuously replicate any changes. Are you using https://sqlite.org/rsync.html?

show 1 reply
pzmarzlytoday at 11:12 AM

What are the differences between sqlrsync and litestream?

show 1 reply