Skip to content
Ruby bindings for the SQLite3 embedded database
Ruby C
Find file
Pull request Compare This branch is 9 commits behind sparklemotion:master.
Latest commit e833524 @tenderlove Merge pull request #161 from franckverrot/bugfix/aggregate
Align #create_aggregate with #create_aggregate_handler
Failed to load latest commit information.
ext/sqlite3 Merge pull request #168 from masaedw/master
faq Add missing `I`
lib Merge pull request #161 from franckverrot/bugfix/aggregate
tasks Upgrade sqlite3 build version to latest
test Merge pull request #161 from franckverrot/bugfix/aggregate
.gitignore Backport gem cross-compilation changes
.travis.yml CI: Test against all latest versions
API_CHANGES.rdoc adding change to api notes
CHANGELOG.rdoc Prepare for release
ChangeLog.cvs ChangeLog is dynamically generated again.
Gemfile Upgrade gem dependencies to latest
LICENSE use a more recent email address
Manifest.txt Update Manifest for new files
README.rdoc Added table creation that is necessary to run example in synopsis
Rakefile Relocate gem definition to its own task.
appveyor.yml CI: Test against all latest versions
setup.rb Change Config to RbConfig and remove unused vars


SQLite3/Ruby Interface


This module allows Ruby programs to interface with the SQLite3 database engine ( You must have the SQLite engine installed in order to build this module.

Note that this module is only compatible with SQLite 3.6.16 or newer.


require "sqlite3"

# Open a database
db = "test.db"

# Create a table
rows = db.execute <<-SQL
  create table numbers (
    name varchar(30),
    val int

# Execute a few inserts
  "one" => 1,
  "two" => 2,
}.each do |pair|
  db.execute "insert into numbers values ( ?, ? )", pair

# Create another table with multiple columns

db.execute <<-SQL
  create table students (
    name varchar(50),
    email varchar(50),
    grade varchar(5),
    blog varchar(50)

# Execute inserts with parameter markers
db.execute("INSERT INTO students (name, email, grade, blog) 
            VALUES (?, ?, ?, ?)", ["Jane", "", "A", ""])

# Find a few rows
db.execute( "select * from numbers" ) do |row|
  p row

Compilation and Installation

Install SQLite3, enabling the option SQLITE_ENABLE_COLUMN_METADATA (see for details).

Then do the following:

ruby setup.rb config
ruby setup.rb setup
ruby setup.rb install

Alternatively, you can download and install the RubyGem package for SQLite3/Ruby (you must have RubyGems and SQLite3 installed, first):

gem install sqlite3

If you have sqlite3 installed in a non-standard location, you can specify the location of the include and lib files by doing:

gem install sqlite3 -- --with-sqlite3-include=/opt/local/include \


OMG! Something has gone wrong! Where do I get help?

The best place to get help is from the sqlite3-ruby mailing list which can be found here:


I've found a bug! Where do I file it?

Uh oh. After contacting the mailing list, you've found that you've actually discovered a bug. You can file the bug at the github issues page which can be found here:



For help figuring out the SQLite3/Ruby interface, check out the SYNOPSIS as well as the RDoc. It includes examples of usage. If you have any questions that you feel should be address in the FAQ, please send them to the mailing list

Source Code

The source repository is accessible via git:

git clone git://
Something went wrong with that request. Please try again.