SQLite is a great little embeddable database engine but the installation of the Ruby library is not obvious or straightforward on Windows XP or Vista. To install SQLite for Ruby 1.8, perform the following steps:
- download sqlitedll-3_6_18.zip,
- copy the two files that are part of the archive to your Ruby bin directory;
- run “gem install –version 1.2.3 sqlite3-ruby” from the command prompt.
Enjoy!