[[SQLite]] is a lightweight SQL-compliant database. The download is about 244kb (command-line client + DLL).
SQLite implements most of the SQL92 and needs no configuration.
h3. Install SQLite
*Windows*
To use SQLite for windows you need two files:
# SQLite DLL
# SQLite command-line client for creating tables
These can be downloaded as "precompiled binaries":http://www.sqlite.org/download.html at "SQLite's homepage":http://www.sqlite.org/
Add @sqlite.exe@ and @sqlite.dll@ to your path.
C:\ruby\bin
*Unix and Mac*
Most package managers put an *sqlite* or *sqlite3* binary in your path.
If you built from source, try _'/usr/local/bin/sqlite(3)'_.
h3. Get sqlite ruby gem
Use gem to install sqlite for Ruby.
*Windows*
C:\work\rb\test>gem install sqlite
C:\work\rb\test>"c:\ruby\bin\ruby.exe" "c:\ruby\bin\gem" install sqlite
Attempting local installation of 'sqlite'
Local gem file not found: sqlite*.gem
Attempting remote installation of 'sqlite'
Select which gem to install for your platform (i386-mswin32)
1. sqlite-ruby 2.2.3 (ruby)
2. sqlite-ruby 2.2.3 (mswin32)
3. sqlite-ruby 2.2.2 (ruby)
...
>
C:\work\rb\test>sqlite db\test.db
SQLite version 2.8.16
Enter ".help" for instructions
sqlite> create table articles
...> (id integer primary key,
...> title varchar(255),
...> text varchar(1024)
...> );
sqlite> .quit
C:\work\rb\test>dir db
Volume in drive C has no label.
Directory of C:\work\rb\test\db
14.04.2005 14:14 4 096 test.db
1 File(s) 4 096 bytes
C:\work\rb\test>
$ mkdir ~/databases
$ cat /path/to/schema.sql | sqlite3 ~/databases/rails-app.db
SQLite version 3.1.2
Enter ".help" for instructions
sqlite> .schema
# Prints the schema
sqlite> .quit
development:
adapter: sqlite
dbfile: db/test.db
test:
adapter: sqlite
dbfile: db/test.db
production:
adapter: sqlite
dbfile: db/test.db