redis-rb VS SQLite3

You're right the general client doesn't have the stack support yet. https://github.com/redis/redis-rb.

Sidekiq integration - requires the Redis gem 3.3.5 or higher. For this integration, the AppSignal gem 2.9.5 or higher is recommended.

It mentions hiredis. A quick look at the redis-rb source code yields that this is coming from Hiredis connection: https://github.com/redis/redis-rb/blob/6542934f01b9c390ee450bd372209a04bc3a239b/lib/redis/connection/hiredis.rb#L18

You're likely already using this library to connect, but check out these docs: https://github.com/redis/redis-rb#cluster-support

I use redis-rb to connect to my Redis cluster (multi shard/node architecture) from my Rails app. In the documentation, I can see that it is enough to provide the cluster endpoint while initialising the client and the client will discover the node endpoints along with their respective keys slot using the cluster-nodes command:

The redis-rb gem is not thread-friendly by default. If you use redis-rb without a connection pool you will end up with race conditions on Redis accesses.

Extralite is a gem for working with SQLite databases. It is blazing fast (up to 11x the performance of the sqlite3 gem), and provides a rich API for accessing database data in a variety of formats.

DB: sparklemotion/sqlite3-ruby: Ruby bindings for the SQLite3 embedded database

# This configure_connection is run when each new connection is created. # see https://github.com/rails/rails/blob/main/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb#L1112 def configure_connection super puts "Configuring DB connection with app-specific PRAGMA statements" conn = self.raw_connection # see https://github.com/sparklemotion/sqlite3-ruby/blob/master/lib/sqlite3/pragmas.rb conn.synchronous = 1 # normal # this is a permanent pragma but in case DB is brand new, no harm is invoking it conn.journal_mode = 'wal' # this is unnecssary b/c rails' sqlite3adapter turns it on by default conn.foreign_keys = true # this is not yet supported with convenience method #conn.analysis_limit = 400 # PRAGMA temp_store = 'memory' # hold temporary indices and tables in memory # conn.temp_store = 2 end

That looks like you're missing the ruby module, not the OS package. If you're using bundler to manage your dependencies, add gem 'sqlite3', '~> 1.3', '>= 1.3.11' to your Gemfile. For reference, I got that line from this page: https://rubygems.org/gems/sqlite3/versions/1.3.11