In order to use sqlite3 for Ruby in windows. You have to do the following:

1. Install Sqlite Engine.

Go to http://www.sqlite.org/sqlitedll-3_6_22.zip. This is the DLL for the sqlite3 library. Unzip to C:\ruby\bin

2. Install Ruby/Sqlite3 Module/API

Open cmd. Type command “gem install sqlite3-ruby”

That’s it. You are done!
Read the rest of this entry »