← Graph

SQLite

tool 26 connections

Embedded public-domain SQL database engine. Source files are concatenated into a single amalgamation compiled into the sqlite3 Ruby gem, so no external server, Docker dependency, or network latency is required. WAL mode (Rails 7.1 default) allows many concurrent readers alongside one writer. Extensions via the sqlpkg gem and related repos add features like IP functions, math, regex, full-text search and even OpenAI integrations. Because it runs inside the Ruby process, SQL can call Ruby code directly — custom scalar and aggregate functions can be defined in Ruby and used from SQL. Known trade-offs: ILIKE not supported (only ASCII-insensitive LIKE; full Unicode case folding needs the sqlean text extension or COLLATE NOCASE); opaque foreign-key errors; single-writer concurrency; single-node by default; NULL ordering differs from Postgres. Backups trivially handled with Litestream or the built-in 'sqlite3 backup' CLI. Embeddable and fast enough that a modest server handles hundreds of daily users with room to spare.

category
service
talk Fantastic Databases and Where to Find Them
about
SQLite tool
Covers SQLite as a surprisingly capable small database.
talk Ever shorter feedback loop
about
SQLite tool
Mentioned as also supporting in-RAM storage for fast tests.
talk Kamal is not harder than your PaaS
about
SQLite tool
Demo app uses SQLite as the database.
talk How (and why) to run SQLite in production
about
SQLite tool
Core subject of the talk.
question Isn't embedding the database in your app process a security regression?
about
SQLite tool
Question concerns SQLite's embedded-database security model.
talk Performance Panel wroclove.rb 2024
about
SQLite tool
Stephen's gem-in-progress stores ActiveSupport Notifications in SQLite for local analytics.
talk From PostgreSQL to SQLite in Rails
about
SQLite tool
Primary subject: migrating a Rails app to SQLite.
takeaway Adopt SQLite to cut Rails infrastructure cost and DevOps overhead
about
SQLite tool
Concrete recommendation about choosing SQLite.
project Plume
about
SQLite tool
Plume parses SQLite's dialect of SQL.
talk On the tasteful journey to Yippee
about
SQLite tool
The talk's first immovable design decision is that Yippee uses SQLite exclusively.
person Stephen Margheim
recommends
SQLite tool
Suggested SQLite as a reasonable place to stash app-local analytics/notifications for small projects.
person Wojtek Wrona
recommends
SQLite tool
Wrona recommends SQLite as a viable production database for small-team Rails apps.
concept Immediate Transactions
related_to
SQLite tool
Immediate Transactions is a SQLite transaction mode.
concept SQLite Busy Handler
related_to
SQLite tool
busy_handler is a SQLite C API callback for write-lock contention.
concept Personal Data Server
uses
SQLite tool
Reference PDS implementation stores each account in its own SQLite database.
project Nerds and Threads
uses
SQLite tool
Demo backed by a SQLite database with products, orders, order_items, and customers tables.
tool enhanced-sqlite3-adapter
uses
SQLite tool
The gem configures and extends SQLite via the sqlite3 Ruby driver.
tool Litestream
uses
SQLite tool
Litestream streams the SQLite WAL to S3-compatible storage.
tool LiteFS
uses
SQLite tool
LiteFS builds multi-node replication on SQLite.
company Turso
uses
SQLite tool
Turso is a managed cloud SQLite service.
tool sqlite3-ruby
uses
SQLite tool
sqlite3-ruby is the Ruby driver binding to SQLite.
person Wojtek Wrona
uses
SQLite tool
Production database after migrating from Postgres.
tool neighbor
uses
SQLite tool
Also supports SQLite as a backing store for vector search.
project Yippee
uses
SQLite tool
Yippee is SQLite-only — primary data, cache, job queue, pub/sub, and full-text search each in separate SQLite databases.
project Sourced
uses
SQLite tool
Ismael's current default event store after switching from Postgres to simplify dependencies.
person Mike Dalessio
works_on
SQLite tool
Collaborated with Margheim on SQLite Bundler compile-flags support.
role: collaborator (2023)

Provenance

Created in
Ever shorter feedback loop — Krzysztof Hasiński at wroclo... 2026-04-17 18:12
Last updated in
From PostgreSQL to SQLite in Rails — Wojtek Wrona at wroc... 2026-04-18 06:46
Total updates
2 extractions
Read by
22 extractions