This post originated from an RSS feed registered with Ruby Buzz by Obie Fernandez. Original Post: Installing SQLite 3 on Windows Feed Title: Obie On Rails (Has It Been 9 Years Already?) Feed URL: http://jroller.com/obie/feed/entries/rss Feed Description: Obie Fernandez talks about life as a technologist, mostly as ramblings about software development and consulting. Nowadays it's pretty much all about Ruby and Ruby on Rails. Latest Ruby Buzz Posts Latest Ruby Buzz Posts by Obie Fernandez Latest Posts From Obie On Rails (Has It Been 9 Years Already?)

Googling "sqlite3 windows" gives you wrong instructions, so here is my attempt to provide some updated and correct instructions. FYI this is how you install SQLite3 to be usable with Ruby on Rails on Windows XP (as of December 2005)...

1. Install SQLite3 for Windows by downloading the following 2 zip files and unzipping them into /WINDOWS/system32
   http://www.sqlite.org/sqlite-3_2_7.zip
   http://www.sqlite.org/sqlitedll-3_2_7.zip
   If those don't work try the official download site here
2. gem install sqlite3-ruby
3. Select option 1 to get the latest win32 driver