Use sqlite3 as a caching adapter

The SQLite Cache gem allows you cache slow queries in ruby code. It provides a simple API to make it easy to add caching to your ruby code.

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

b

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

SQLiterate is a SQL parser.

Full-text, vector, and hybrid search for ActiveRecord, without leaving SQLite. sqlite_search gives a model full-text search (FTS5 with BM25 ranking), vector search (sqlite-vec through the neighbor gem, with your app supplying embeddings), and hybrid search that fuses the two with Reciprocal Rank Fusion and an optional reranking step, all behind one declarative DSL. No search cluster to run, no separate copy of your data, no database triggers, and a schema that restores cleanly from schema.rb.

have u ever wanted to shout SELECTed words??? now u can. UPDATE ur noob sql scripting FROM lowercase to uppercase

Fork from ankane! Explore your data with SQL. Easily create charts and dashboards, and share them with your team.

A simple gem to track metric events in your own postgres or Amazon Redshift database.

Schema Migration utilities for MySQL.

Simple standalone migrations you can use with plain SQL

SQL Optimizer helps you optimize you queries and see full description

A Racc-based Ruby parser for SQL statements; forked from https://github.com/cryodex/sql-parser

A mini-language for building and executing SQL statements against a postgresql database. This is a very old library, pre-dating active record and lacking many of its refinments. New projects will probably not want to use it.

A c++ table class wrapper generator for sqlpp11 (c++11). See more about sqlpp11

Gem to run SQL like queries on array of hashes or similar objects

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

Debug SQL statements in ActiveRecord by displaying warnings on bad queries.

Simple SQL search conditions parser (where clause)