| ▲ | resonious 5 days 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. | ||
| ▲ | yomismoaqui 5 days ago | parent | next [-] | |
You 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-restart... | ||
| ▲ | vidarh 5 days ago | parent | prev [-] | |
You 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. | ||