Anyways, installing SQLite is as easy as that. Go to SQLite downloads page and grab the
sqlitedll-3-xx.ziparchives and extract them eg. to
C:\sqlite3. Add this folder to your system PATH environment variable so you (and your apps) can access the libraries and executables.
I suppose you have gem installed (and you installed Rails via this nice package management system), so let's the magic happen. In your console type:
Here you go. Why the versioning you'd ask. Unfortunately the gem 1.2.3 needs some compiling and header files you might not have on XP box. For standard gem commands see the RubyGems Manual. I recommend you to clean up your gems some time with
Update: This solution is considered to be temporary. For getting more recent and decent version of the library, please open up the rubyforge project page and download the latest gem package marked
x86-mingw32respective to your Ruby build. Then do eg.:
Update2: Roger from All Gems kindly put two solutions to the problem at hand. Both of them using Mingw, which is great. So here is Roger's post on building sqlite3-ruby binding binaries on Windows. The other post is from Luis Lavena, developer of the Ruby Installer which I definitely recommend to use on Windows.