sqlite3-ruby travis-ci

Ruby bindings for the SQLite3 embedded database

= SQLite3/Ruby Interface


This module allows Ruby programs to interface with the SQLite3 database engine (http://www.sqlite.org). 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 = SQLite3::Database.new “test.db”

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

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

# Execute inserts with parameter markers db.execute(“INSERT INTO students (name, email, grade, blog) VALUES (?, ?, ?, ?)”, [@name, @email, @grade, @blog])

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

== Compilation and Installation

Install SQLite3, enabling the option SQLITE_ENABLE_COLUMN_METADATA (see www.sqlite.org/compile.html 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}[http://groups.google.com/group/sqlite3-ruby] 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}[http://github.com/luislavena/sqlite3-ruby/issues] which can be found here:

== Usage

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}[http://groups.google.com/group/sqlite3-ruby]

== Source Code

The source repository is accessible via git:

git clone git://github.com/luislavena/sqlite3-ruby.git

Related Repositories



Ruby bindings for the SQLite3 embedded database ...



A simple Ruby web spider that uses Anemone to crawl every page of a site looking for email addresses. Stores the results with SQLite3 using Data Mapper. ...



Ruby SQLite3 bindings with load_extension() patch ...



Apple Service Server was written with Ruby/Sinatra and Sequel(Sqlite3), it provides push notification with web admin interface ...



Ruby script to convert a chrome sqlite3 password database to Keepass' XML importation format ...

Top Contributors

tenderlove luislavena jamis nurse jdberry richmeyers kashif FooBarWidget snaury kcurtin flavorjones terceiro augusto trptcolin evgeny-myasishchev gerrit yoshimoto jc00ke mathieu romuloceccon codeodor sj26 sjlombardo


-   v1.3.6 zip tar
-   v1.3.5 zip tar
-   v1.3.4 zip tar
-   v1.3.3 zip tar
-   v1_3_2 zip tar
-   v1_3_1 zip tar
-   v1_3_0 zip tar
-   v1_3_0_beta_2 zip tar
-   v1_3_0_beta_1 zip tar
-   v1_2_5 zip tar
-   v1_2_4_1 zip tar
-   v1_2_4 zip tar
-   v1_2_3 zip tar
-   v1_2_2 zip tar
-   v1_2_0 zip tar
-   v1_1_0 zip tar
-   v1_0_1 zip tar
-   v1_0_0 zip tar
-   dummy1.3.3 zip tar