U:RDoc::TopLevel[ iI"README.rdoc:ETcRDoc::Parser::Simpleo:RDoc::Markup::Document: @parts[5S:RDoc::Markup::Heading: leveli: textI"SQLite3/Ruby Interface;To:RDoc::Markup::BlankLineo:RDoc::Markup::List: @type: BULLET: @items[ o:RDoc::Markup::ListItem: @label0;[o:RDoc::Markup::Paragraph;[I"2https://github.com/sparklemotion/sqlite3-ruby;To;;0;[o;;[I"0http://groups.google.com/group/sqlite3-ruby;To;;0;[o;;[I"%http://rubygems.org/gems/sqlite3;To;;0;[o;;[I"0http://www.rubydoc.info/gems/sqlite3/frames;T@ o;;[I"—{Build Status}[https://travis-ci.org/sparklemotion/sqlite3-ruby];T@ S; ; i; I"DESCRIPTION;T@ o;;[I"DThis module allows Ruby programs to interface with the SQLite3 ;TI"Adatabase engine (http://www.sqlite.org). You must have the ;TI";SQLite engine installed in order to build this module.;T@ o;;[I"JNote that this module is only compatible with SQLite 3.6.16 or newer.;T@ S; ; i; I" SYNOPSIS;T@ o:RDoc::Markup::Verbatim;[1I"require "sqlite3" ;TI" ;TI"# Open a database ;TI"*db = SQLite3::Database.new "test.db" ;TI" ;TI"# Create a table ;TI"rows = db.execute <<-SQL ;TI" create table numbers ( ;TI" name varchar(30), ;TI" val int ;TI" ); ;TI" SQL ;TI" ;TI"# Execute a few inserts ;TI"{ ;TI" "one" => 1, ;TI" "two" => 2, ;TI"}.each do |pair| ;TI"> db.execute "insert into numbers values ( ?, ? )", pair ;TI" end ;TI" ;TI"# Find a few rows ;TI"4db.execute( "select * from numbers" ) do |row| ;TI" p row ;TI" end ;TI" ;TI"2# Create another table with multiple columns ;TI" ;TI"db.execute <<-SQL ;TI" create table students ( ;TI" name varchar(50), ;TI" email varchar(50), ;TI" grade varchar(5), ;TI" blog varchar(50) ;TI" ); ;TI" SQL ;TI" ;TI".# Execute inserts with parameter markers ;TI"Bdb.execute("INSERT INTO students (name, email, grade, blog) ;TI"c VALUES (?, ?, ?, ?)", ["Jane", "me@janedoe.com", "A", "http://blog.janedoe.com"]) ;TI" ;TI"5db.execute( "select * from students" ) do |row| ;TI" p row ;TI" end ;T: @format0S; ; i; I"!Compilation and Installation;T@ o;;[I"MInstall SQLite3, enabling the option SQLITE_ENABLE_COLUMN_METADATA (see ;TI".www.sqlite.org/compile.html for details).;T@ o;;[I"Then do the following:;T@ o;;[I"ruby setup.rb config ;TI"ruby setup.rb setup ;TI"ruby setup.rb install ;T;0o;;[I"IAlternatively, you can download and install the RubyGem package for ;TI"HSQLite3/Ruby (you must have RubyGems and SQLite3 installed, first):;T@ o;;[I"gem install sqlite3 ;T;0o;;[I"}If you have sqlite3 installed in a non-standard location, you can specify the location of the include and lib files by doing:;T@ o;;[I"Hgem install sqlite3 -- --with-sqlite3-include=/opt/local/include \ ;TI"* --with-sqlite3-lib=/opt/local/lib ;T;0S; ; i; I"SUPPORT!!!;T@ S; ; i; I":OMG! Something has gone wrong! Where do I get help?;T@ o;;[I",The best place to get help is from the ;TI"T{sqlite3-ruby mailing list}[http://groups.google.com/group/sqlite3-ruby] which ;TI"can be found here:;T@ o;;[I"3* http://groups.google.com/group/sqlite3-ruby ;T;0S; ; i; I"+I've found a bug! Where do I file it?;T@ o;;[ I"RUh oh. After contacting the mailing list, you've found that you've actually ;TI"4discovered a bug. You can file the bug at the ;TI"P{github issues page}[https://github.com/sparklemotion/sqlite3-ruby/issues] ;TI"which can be found here:;T@ o;;[I"<* https://github.com/sparklemotion/sqlite3-ruby/issues ;T;0S; ; i; I" Usage;T@ o;;[ I"EFor help figuring out the SQLite3/Ruby interface, check out the ;TI";SYNOPSIS as well as the RDoc. It includes examples of ;TI"Ousage. If you have any questions that you feel should be addressed in the ;TI"]FAQ, please send them to {the mailing list}[http://groups.google.com/group/sqlite3-ruby];T@ S; ; i; I"Source Code;T@ o;;[I"1The source repository is accessible via git:;T@ o;;[I">git clone git://github.com/sparklemotion/sqlite3-ruby.git;T;0: @file@:0@omit_headings_from_table_of_contents_below0