[tillcarlos]

Yeah I used the full litestack (and litestream for backups) for my SaaS. Oldmoe is also auper helpful on twitter.

Once Rails 8 came out I switched it all over to the solid* gems which pretty much did the same thing.

Sqlite is awesome in the beginning, especially as there are no extra services to start (I only have a web process and a jobs process), all is sqlite.

Sometimes there are db locking issues (using blazer gem, so I guess that uses a different adapter), and I had to optimize some queries. But that’s about it. The SaaS processes thousands of job daily (mission control gem is awesome) and stable so far.

At one point our DB grew to 16GB because I stored all Api requests. Even then it was still fast (except queries on that api requests table).

Running four sqlites definitely saved me some time which I could use for customer focused things. Highly recommend for MVPs, probably more.