Re:Ask HN: Show us your low-tech/simple stack side projects
by dmak on Tuesday January 11, 2022 @01:49PM
(#29895884)
I have never even considered using SQLite as a production database. This is cool!
[ Parent
| on HN ]
Re:Ask HN: Show us your low-tech/simple stack side projects
by Glench on Tuesday January 11, 2022 @02:11PM
(#29896228)
Yeah, it's awesome. Saved me setup time, db server money, and maintenance and haven't run into any issues with it. And if I want to test something locally with production data I just download the db file to my machine :)
I was partially convinced after reading this tweet: https://twitter.com/levelsio/status/1381709793769979906
And further convinced when I read about LiteStream and how you can get continuous backups with it: https://litestream.io/getting-started/ Seemed like continuous backup was one of the major missing pieces from SQLite.
And further further convinced when I read about someone using LiteStream: https://mtlynch.io/litestream/