3 ms·
Question for people using SQLite in prod: how do you cope if your app is running on a platform like Heroku or Cloud Run, rather than a proper server or VM? Have
by memset 4y ago
Question for people using SQLite in prod: how do you cope if your app is running on a platform like Heroku or Cloud Run, rather than a proper server or VM? Have you found a solution for the fact that those environments, and disk, is ephemeral?
- christophilus 4y agoYou could use Render or a similar service that offers persistent storage. I imagine Heroku has a similar feature. [0] https://render-web.onrender.com/docs/disks https://render-web.onrender.com/docs/disks
- hobo_mark 4y agoFly as well: https://fly.io/docs/reference/volumes/ https://fly.io/docs/reference/volumes/
- Glench 4y agoYeah this is an annoying problem. I just run an actual server rather than an "app" platform. I haven't found it that complicated and I pay less monthly which is nice.
- gwbas1c 4y agoPostgress About 2 years ago I wrote my own blog engine so I could get up-to-speed with NodeJS: https://andrewrondeau.herokuapp.com/ https://andrewrondeau.herokuapp.com/ I would have loved to do SQLite with some kind of "magic" backup, as SQLite is more than enough to handle a personal blog. (It certainly would make development easier!) However, at the time Heroku only offered Postgress.
- Cthulhu_ 4y agoI'd always opt to use their hosted database in those constraints. IMO SQLite only works well if you own the storage, so bare metal (or VMs) only.