← Graph

enhanced-sqlite3-adapter

tool 7 connections

Ruby gem written and maintained by Stephen Margheim that automatically patches a Rails application's SQLite configuration to be production-ready. Applied by `bundle add`: sets up initializers that switch Active Record to immediate-mode transactions, install a GVL-releasing Ruby busy_handler, apply a fair 1 ms retry interval, and wire up optional isolated reader/writer connection pools (opt-in, marked experimental as of March 2024). Also backports SQLite-adapter features from rails main that hadn't yet shipped in a point release: deferred foreign keys (for circular references), virtual columns, custom returning values on insert, declaring SQLite pragmas in database.yml, and loading SQLite extensions (e.g. a vector-similarity extension) via database.yml.

license
open-source
category
library
language
Ruby
about
enhanced-sqlite3-adapter tool
The talk walks through what the gem does and why.
about
enhanced-sqlite3-adapter tool
The takeaway recommends this specific gem.
recommends
enhanced-sqlite3-adapter tool
Recommends `bundle add enhanced-sqlite3-adapter` as the easy path to production-ready SQLite on Rails.
tool enhanced-sqlite3-adapter
uses
SQLite tool
The gem configures and extends SQLite via the sqlite3 Ruby driver.
tool enhanced-sqlite3-adapter
uses
Patches initializers on top of the sqlite3 gem's driver.
tool enhanced-sqlite3-adapter
uses
Active Record concept
Patches Active Record's SQLite adapter and backports adapter features from Rails main.
works_on
enhanced-sqlite3-adapter tool
Margheim created and maintains the gem.
role: author/maintainer

Provenance

Read by
5 extractions