mix VS cheapo_website

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

```

What followed was a wealth of articles full of knowledge, understanding of his niche, and potential for connecting to potential leads and partners. Instead of calling it a day, he decided to share the tool with us, the people (which basically means his 100 minute hack turned into a 20 hour project if you include all the side quests and write-ups related to it).

https://slothfinder.apishop.io/

He has also open-sourced it on GitHub. Here are some reasons for you to look at the code:

- You want to see how to deploy a Rails project on the cheapest [render.com](http://render.com) non-free plan running on SQLite (making it cheaper than usual). After I already embarked on render.com, I found that [someone else documented how they experimented with something similar and ran Python on SQLite on fly.io for basically free](https://github.com/irskep/cheapo_website), so this might be another solution if you are interested in hosting your hobby projects.

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.