I‘ve mentioned previously that Joy of Rails uses SQLite along with Rails support for multiple databases. Here's a snapshot of what the Joy of Rails config/database.yml file looks like in development. I’ve separated the database for each of the Rails "backends" running on SQLite, including ActiveRecord (primary), Rails cache, Solid Queue job queue, and Action Cable. Each simply maps to a different file on disk.
config/database.yml
default: &default
adapter: sqlite3
pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 3 } %>
timeout: 5000
development:
primary:
<<: *default
database: storage/development/data.sqlite3
cache:
<<: *default
database: storage/development/cache.sqlite3
migrations_paths: db/migrate_cache
queue:
<<: *default
database: storage/development/queue.sqlite3
migrations_paths: db/migrate_queue
cable:
<<: *default
database: storage/development/cable.sqlite3
migrations_paths: db/migrate_cable