U:RDoc::TopLevel[	iI"README.rdoc:ETcRDoc::Parser::Simpleo:RDoc::Markup::Document:@parts[6S: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".http://github.com/luislavena/sqlite3-ruby;To;;0;[o;;[I".http://rubyforge.org/projects/sqlite-ruby;To;;0;[o;;[I"%http://sqlite-ruby.rubyforge.org;To;;0;[o;;[I"0http://groups.google.com/group/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"=Note that this module is NOT compatible with SQLite 2.x.;T@
S;	;
i;I"
SYNOPSIS;T@
o:RDoc::Markup::Verbatim;[I"require "sqlite3"
;TI"
;TI"# Open a database
;TI"*db = SQLite3::Database.new "test.db"
;TI"
;TI"# Create a database
;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
;T:@format0S;	;
i;I"!Compilation and Installation;T@
o;;[I"IInstall SQLite3, enabling 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-ruby
;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"Mgem install sqlite3-ruby -- --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"L{github issues page}[http://github.com/luislavena/sqlite3-ruby/issues] ;TI"which can be found here:;T@
o;;[I"8* http://github.com/luislavena/sqlite3-ruby/issues
;T;0S;	;
i;I"
Usage;T@
o;;[	I"EFor help figuring out the SQLite3/Ruby interface, check out the ;TI"UFAQ[http://sqlite-ruby.rubyforge.org/sqlite3/faq.html]. It includes examples of ;TI"Musage. If you have any questions that you feel should be address in the ;TI"1FAQ, please send them to jamis@37signals.com;T@
S;	;
i;I"Source Code;T@
o;;[I"1The source repository is accessible via git:;T@
o;;[I"<git clone git://github.com/luislavena/sqlite3-ruby.git
;T;0S;	;
i;I"Contact Information;T@
o;;[	I"SThe project page is http://rubyforge.org/projects/sqlite-ruby. There, you can ;TI"Mfind links to mailing lists and forums that you can use to discuss this ;TI"Olibrary. Additionally, there are trackers for submitting bugs and feature ;TI"%requests. Feel free to use them!;T:
@file@:0@omit_headings_from_table_of_contents_below0