A faster way to copy SQLite databases between computers

Re:A faster way to copy SQLite databases between computers by yard2010 on Thursday May 01, 2025 @11:13AM (#43858763)

Litestream is really cool! I'm planning to use it to backup and restore my SQLite in the container level, just like what that ex-google guy who started a startup of a small KVM and had a flood in his warehouse while on vacation did. If I'm not mistaken. I would link here the perfect guide he wrote but there's 0 chance I'll find it. If you understand the reference please post the link.

[ Parent | on HN ]

Re:A faster way to copy SQLite databases between computers by mtlynch on Thursday May 01, 2025 @11:18AM (#43858844)

Haha, that sounds like me. Here's the writeup you're talking about:

https://mtlynch.io/litestream/

And here's the flooding story:

https://mtlynch.io/solo-developer-year-6/#the-most-terrifyin...

Sidenote: I still use Litestream in every project where I use SQLite.

[ Parent | on HN ]