SQLite the only database you will ever need in most cases

• litestream

  169 10,794 6.0 Go

  Streaming replication for SQLite.

  Also worth mentioning Fly.io's work on LiteStream [1] and LiteFS [2] giving SQLite important S3 DR/reliability & multi-node replication and scalability opens SQLite up to even more use-cases.

  We're making use of this ourselves in https://blazordiffusion.com which runs entirely on SQLite, using Litestream to replicate it to Cloudflare's R2 object storage which is running on a single Hetzner US Cloud VM at €13 /mo.

  As we believe SQLite + Litestream is a very cost effective solution that can support a large number of App's data requirements we've added first-class support to add SQLite + Litestream support in our Project templates [3] which uses GitHub Actions to run Docker compose App deployments along with setting up Litestream replication to AWS S3, Azure Blob Storage and SFTP in a sidecar container that also includes support running DB Migrations on Server with Rollback on failure. If anyone's looking to do something similar, the GitHub Actions that enable this are being maintained at [4].

  [1] https://litestream.io

  [2] https://fly.io/blog/introducing-litefs/

  [3] https://docs.servicestack.net/ormlite/litestream

  [4] https://github.com/ServiceStack/mix/tree/master/actions

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• cheapo_website

  3 43 0.0 Python

  An experiment in production SQLite on render.com and fly.io

  Thank you for the thoughtful response.

  I was looking at https://github.com/irskep/cheapo_website from commenter irskep above, and they make a nice point that render.com has automatic daily backups, solving 4)

  However, in another comment they mention "You can't(?) run migrations from another process" and that "people don't talk about the completely ordinary need to run migrations on a database".

  I guess this is also the piece that I'm missing. How do I run migrations? Do I deploy a new version with the migration and temporarily take down the server? I'm glad to do that.

  I guess I'm also walking through this because---as I said---I'd love just to switch to SQLite but I'm still not sure how many simple non-esoteric gotchas will pop up.

• rqlite

  121 15,619 9.9 Go

  The lightweight, user-friendly, distributed relational database built on SQLite.

  

  This project comes to mind https://github.com/rqlite/rqlite but I've never used it, and I'm not sure if it would count as "pure sqlite" like the op advocated anymore.

• dqlite

  33 3,846 9.5 C

  Embeddable, replicated and fault-tolerant SQL engine.

  

• mix

  1 1 7.3 C#

  Maintain web mix gists (by ServiceStack)

  

  Also worth mentioning Fly.io's work on LiteStream [1] and LiteFS [2] giving SQLite important S3 DR/reliability & multi-node replication and scalability opens SQLite up to even more use-cases.

  We're making use of this ourselves in https://blazordiffusion.com which runs entirely on SQLite, using Litestream to replicate it to Cloudflare's R2 object storage which is running on a single Hetzner US Cloud VM at €13 /mo.

  As we believe SQLite + Litestream is a very cost effective solution that can support a large number of App's data requirements we've added first-class support to add SQLite + Litestream support in our Project templates [3] which uses GitHub Actions to run Docker compose App deployments along with setting up Litestream replication to AWS S3, Azure Blob Storage and SFTP in a sidecar container that also includes support running DB Migrations on Server with Rollback on failure. If anyone's looking to do something similar, the GitHub Actions that enable this are being maintained at [4].

  [1] https://litestream.io

  [2] https://fly.io/blog/introducing-litefs/

  [3] https://docs.servicestack.net/ormlite/litestream

  [4] https://github.com/ServiceStack/mix/tree/master/actions

• litefs-js

  7 160 3.4 TypeScript

  JavaScript utilities for working with LiteFS on Fly.io

  

  Also worth mentioning Fly.io's work on LiteStream [1] and LiteFS [2] giving SQLite important S3 DR/reliability & multi-node replication and scalability opens SQLite up to even more use-cases.

  We're making use of this ourselves in https://blazordiffusion.com which runs entirely on SQLite, using Litestream to replicate it to Cloudflare's R2 object storage which is running on a single Hetzner US Cloud VM at €13 /mo.

  As we believe SQLite + Litestream is a very cost effective solution that can support a large number of App's data requirements we've added first-class support to add SQLite + Litestream support in our Project templates [3] which uses GitHub Actions to run Docker compose App deployments along with setting up Litestream replication to AWS S3, Azure Blob Storage and SFTP in a sidecar container that also includes support running DB Migrations on Server with Rollback on failure. If anyone's looking to do something similar, the GitHub Actions that enable this are being maintained at [4].

  [1] https://litestream.io

  [2] https://fly.io/blog/introducing-litefs/

  [3] https://docs.servicestack.net/ormlite/litestream

  [4] https://github.com/ServiceStack/mix/tree/master/actions

• postgresql-embedded

  3 479 0.0 Java

  Discontinued Embedded PostgreSQL Server

  

• sqlitebrowser

  283 21,057 9.0 C++

  Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:

  

  Check out: https://sqlitebrowser.org/

  You may also need the SQLite command-line tools from the SQLite website;

Suggest a related project