SQLite on Rails: The how and why of optimal performance

1. litestack

   1 24 1,452 8.0 Ruby

   

   Anyone who is looking at using SQLIte + Rails should check out the work done by Oldmoe (X/Github) on his Litestack project.

   Here's the intro paragraph: "Litestack is a Ruby gem that provides both Ruby and Ruby on Rails applications an all-in-one solution for web application data infrastructure. It exploits the power and embeddedness of SQLite to deliver a full-fledged SQL database, a fast cache , a robust job queue, a reliable message broker, a full text search engine and a metrics platform all in a single package."

   I'm currently using it on a project and can't say enough good things about it!

   https://github.com/oldmoe/litestack

2. SaaSHub

   www.saashub.com featured

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

   

3. pglite

   2 53 15,353 8.9 TypeScript

   Embeddable Postgres with real-time, reactive bindings.

   

   I'm wondering how would it perform if we can compile https://pglite.dev/ as a native library and use it as an in-process Postgres... I know Node folks already use it as a Wasm module, so it shouldn’t be too tricky?

4. SQLite3

   3 6 840 8.6 Ruby

   Ruby bindings for the SQLite3 embedded database

   

   You can read more discussion here: https://github.com/sparklemotion/sqlite3-ruby/pull/528 and here: https://github.com/digital-fabric/extralite/pull/46 to see how it was validated that simply releases the GVL for every `step` in the SQLite VM majorly hurts single-threaded performance. Finding a middle ground for both single threaded and multi-threaded performance is tricky. In Rails, we know it is multi-threaded because of the connection pool. But the lower level gem is used in many other libraries and tools where it is used in a single threaded environment

5. extralite

   4 5 274 5.9 C

   Ruby on SQLite

   

   You can read more discussion here: https://github.com/sparklemotion/sqlite3-ruby/pull/528 and here: https://github.com/digital-fabric/extralite/pull/46 to see how it was validated that simply releases the GVL for every `step` in the SQLite VM majorly hurts single-threaded performance. Finding a middle ground for both single threaded and multi-threaded performance is tricky. In Rails, we know it is multi-threaded because of the connection pool. But the lower level gem is used in many other libraries and tools where it is used in a single threaded environment

6. chdb

   5 32 2,691 9.9 Python

   chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse

   

   Take a look at chDB and clickhouse-local. Clickhouse can do a lot even without running it as a server.

   https://clickhouse.com/docs/en/chdb

   https://clickhouse.com/docs/en/operations/utilities/clickhou...

7. Ruby on Rails

   6 569 58,615 10.0 Ruby

   Ruby on Rails

   

Suggest a related project