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

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.

Use sqlite3 as a caching adapter

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.

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)