Litestack: All your data infrastructure, in one Ruby gem(github.com)
github.com
Litestack: All your data infrastructure, in one Ruby gem
https://github.com/oldmoe/litestack
22 comments
Relevant: Just Use Postgres for Everything [1]
[1]: https://www.amazingcto.com/postgres-for-everything/
[1]: https://www.amazingcto.com/postgres-for-everything/
Using Postgres is becoming easier with the new Rails Solid [Queue, Cable, Cache] stuff.
And DuckDB's Postgres Extension / Postgres's DuckDB extension!
https://duckdb.org/docs/extensions/postgres.html / https://github.com/duckdb/pg_duckdb
https://duckdb.org/docs/extensions/postgres.html / https://github.com/duckdb/pg_duckdb
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.)
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
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
I’ve used this for a side project. Coupled with Litestream for backups it’s awesome.
I would 100% recommend.
I would 100% recommend.
Main-Main Replication: LiteFS
Streaming Backups: LiteStream
Just missing logs and, well, for me, graph database.
Streaming Backups: LiteStream
Just missing logs and, well, for me, graph database.
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.
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.
I wish there was a Python project like this
Looks fantastic!
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.)
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.
> 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.
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.
Gorgeous, bookmarked it!
Lol sorry but if you are going to claim to be a faster cache than redis you need to bring receipts
Very interesting
Considering that Rails 8 gives you Progressive Web Apps out of the box, this is a very competitive setup for a small team.
https://github.com/oldmoe/litestack/blob/master/BENCHMARKS.m...