A persistent simple Hash backed by sqlite3. Contains (almost) the same features/API as the Ruby 2.0.0 Hash object

The SQLite3 adapter in Rails 4 doesn't support JSON columns. This gem adds it via a railtie and a series of hacks.

Use sqlite3 as a caching adapter

UUID and ULID primary key support for Rails with SQLite3. Provides automatic type registration, validation, foreign key detection, and clean schema generation. Supports UUIDv4 (random), UUIDv7 (time-ordered), and ULID (compact, time-sortable) with zero external dependencies.

Provides a convenient way of writing functions in Ruby that can be called from within SQLite queries through the sqlite3 gem.

Use sqlite3 databases like a hash

The sqlite print table gem is used to print a formatted table from a sqlite database using a SQL query.

Enables SQLite database access from a DRb server.

CLI tool that queries SQLite databases across remote hosts via SSH, aggregating results in real-time. Designed for multi-tenant apps where each tenant has their own SQLite database.

ActiveRecord extension that provides large performance improvements when you need large sets of read-only data and do not need the magic of ActiveRecord.

Query assertions and SQL matchers for RSpec.

Simple standalone migrations you can use with plain SQL

Rails plugin. Allows you to write plain SQL migrations without Ruby code.

Collect 'ActiveRecord sql query' to monitoring system(s).

Description of SqlPager.

A Ruby on Rails gem that analyzes SQL queries and suggests optimizations like missing indexes, inefficient sorts, and risky joins.

Add SQL query stats to your Rails logs, reported stats include, query count, slowest query and slowest query duration

SQLRunner allows you to load your queries out of SQL files, without using ORMs.

Sequence number generation in Rails

runs sqltests for CBS Testing environment