Install SQLite3 for Ruby in Windows

1.  I downloaded sqlite3 dll zip from
http://www.sqlite.org/sqlitedll-3_6_12.zip and unzipped into C:\ruby\bin
and then ran
2.  gem install sqlite3-ruby -v 1.2.3

Rails Sucks

I've just started to learn Ruby on Rails (RoR). Got stuck when downloading rails behind a firewall. I wonder why Rails has poor documentation regarding the download steps.

Finally I manged to download rails by setting the following ENV_VARIABLE in Windows environment.

HTTP_PROXY=http://user:pwd@host:port

Even more disgusting is the fact, that I needed to change my password couple of times, since my credentials had special characters like @, %, !. Obviously, Rails hated this.