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

b

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.

b

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

Track and analyze sql queries of your rails application

SQL Optimizer helps you optimize you queries and see full description

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

Do you use ActiveRecord::Connection.execute for speed sometimes? Does it bother you that the results are not mapped to your schema and type-cast as ActiveRecord would? Well that's what SQLRecord does.

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.

Sequence number generation in Rails

A shortcut to the COPY command from PostgreSQL. Give it SQL and get an Enumerator for the CSV that comes out of it.