SQLite3/Ruby Interface with embedded SQLite3 library¶ ↑

• github.com/sparklemotion/sqlite3-ruby

• groups.google.com/group/sqlite3-ruby

• rubygems.org/gems/sqlite3

• www.rubydoc.info/gems/sqlite3/frames

DESCRIPTION¶ ↑

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

This module embeds its own SQLite3 library built from the SQLite amalgamation, so it doesn’t have any external dependencies

SYNOPSIS¶ ↑

require "sqlite3"

# Open a database
db = SQLite3::Database.new "test.db"

# Create a table
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

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

# Create another table with multiple columns

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

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

db.execute( "select * from students" ) do |row|
  p row
end

Compilation and Installation¶ ↑

Do the following:

gem build sqlite3-static.gemspec
gem install sqlite3-static-*.gem

SUPPORT!!!¶ ↑

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:

* http://groups.google.com/group/sqlite3-ruby

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:

* https://github.com/sparklemotion/sqlite3-ruby/issues

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

Source Code¶ ↑

The source repository is accessible via git:

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