hiharryhere 2 days ago | prev | next |

I’ve used this for a side project. Coupled with Litestream for backups it’s awesome.

I would 100% recommend.

barefootford 2 days ago | prev | next |

This gem is a really nice all-in-one setup! \n (Also worth noting that Rails 8 now supports sqlite for your application database (no more warnings about using it in prod), job queue (active job/solid queue) and cache (solid cache) out of the box.)

axelthegerman 2 days ago | root | parent |

THIS!

Litestack seems great and probably partially paved the way for similar functionality directly in Rails 8 with the new solid* gems.

Those plus litestream are a treat

freen 2 days ago | prev | next |

Main-Main Replication: LiteFS

Streaming Backups: LiteStream

Just missing logs and, well, for me, graph database.

tillcarlos 2 days ago | prev | next |

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.

noelwelsh 2 days ago | prev | next |

SQLite is great, but the README is a bit disingenuous in not mentioning any of the downsides of using it (e.g. scalability concerns if you go beyond what a single box can handle.)

eterps 2 days ago | root | parent | next |

At what scale would this become a significant concern? While some tech startups aspire to achieve Google-level success, such massive scale is extremely rare in reality. I'm curious about the threshold where issues begin to materialize.

thunky 2 days ago | root | parent | prev |

> README is a bit disingenuous

My guess is that they assume the reader is already familiar with sqlite. And "lite" is in the name Litestack. And it says in the second sentence of the description: "It exploits the power and embeddedness of SQLite".

Personally I think that's good enough.

elif 2 days ago | prev | next |

Lol sorry but if you are going to claim to be a faster cache than redis you need to bring receipts

freen 2 days ago | root | parent | prev |

SQLite operates in the same process as the app. No network overhead, no socket overhead, etc.

The tradeoff is all your eggs in one basket, so to speak.