At work, we have been running new Ruby on Rails 2.0.x projects on top of Mongrel and SQLite. Being the only developer at my company who had his start on a Windows box, I was tasked with getting a new Web Producer up and running on Rails. From a clean Windows install, setting up the machine took a matter of minutes. And, for documentation purposes, I'll write the steps out here:

  1. Download and Run the Ruby One-Click Installer
  2. Grab the SQLite3 command line program and DLL from the SQLite Download page. Unzip into C:\WINDOWS\system32\
  3. From the command line run:
    1. gem install mongrel --include-dependencies (choose the mswin32 option)
    2. gem install rails --include-dependencies
    3. gem install sqlite3-ruby (choose the mswin32 option)

That's it. You can now run rails test to create a test project using SQLite running on top of Mongrel.

As a bonus, these are also helpful to install for Rails development on Windows: