SQLite on Rails: The how and why of optimal performance

• litestack

  19 1,113 8.5 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

• SaaSHub

  www.saashub.com featured

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

  

• pglite

  22 8,371 9.4 TypeScript

  Lightweight WASM 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?

• SQLite3

  6 763 9.2 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

• extralite

  5 253 9.1 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

• chdb

  22 2,032 9.6 C++

  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...

• Ruby on Rails

  504 55,777 10.0 Ruby

  Ruby on Rails

  

Suggest a related project