4 ms·
For a serious web project it's hard to imagine picking SQLite, unless you're using a proper "serverified" SQLite service like Turso or Cloudflare D1. I'd think
by resonious 1y ago
For a serious web project it's hard to imagine picking SQLite, unless you're using a proper "serverified" SQLite service like Turso or Cloudflare D1. I'd think zero-downtime deployments alone would be a dealbreaker for many. Then there's high-availability and horizontal scaling.
I love that SQLite lets me run the app locally with no "setup". And so I actually kinda like Turso and D1 for bridging the gap. I can have the best of both worlds: no setup, AND primetime-ready deployment.
- vidarh 1y agoYou can do zero downtime deployments with SQLite just fine if your app can gracefully handle the database file being locked. Just spin up your new version talking to the same database, be mindful about how you handle migrations, and shut down the old version.
- yomismoaqui 1y agoYou can do zero downtime using Systemd socket activation. I tried this with a Go server using SQLite and it was perfect. https://bunrouter.uptrace.dev/guide/go-zero-downtime-restarts.html https://bunrouter.uptrace.dev/guide/go-zero-downtime-restart...