I struggled for a while to get sqlite3 to work together well with Ruby
and Ruby on Rails under Cygwin. I eventually figured it out, here is the
procedure to save others some time :
This procedure concerns the following software versions:
ruby 1.8.5 (2006-08-25) [i386-cygwin]
sqlite version 3.3.8
sqlite3-ruby (1.1.0) (Ruby gem)
rails (1.1.6) (Ruby gem)
Install Cygwin and Rails as described on this page:
http://wiki.rubyonrails.org/rails/pages/RailsonWindowsCygwin
Then, download the sqlite3 sources from the SQLite download page
(SQLite Download Page). I compiled the 3.3.8 version from
the source tarball.
wget http://www.sqlite.org/sqlite-3_3_8.zip
Extract the tarball and read the README for compilation instructions.
You will need to install GCC and Make using the Cygwin installer.
After compilation you will have sqlite3.exe. You will also need to build
the .dll. In the sqlite source directory type
make sqlite3.dll
The copy the .dll and the .exe to somewhere on your path, eg:
cp sqlite3.exe sqlite3.dll ~/bin
Now install the sqlite3-ruby gem (choosing the latest mswin32 version)
gem install sqlite3-ruby
You have to make a change to this file
c:/cygwin/lib/ruby/gems/1.8/gems/
sqlite3-ruby-1.1.0-mswin32/lib/sqlite3/driver/dl/
So that it reads
when /win32/, /i386-cygwin/
“sqlite3.dll”
And you should be able to specify sqlite3 as the database in your
database.yml, for example :
development:
adapter: sqlite3
database: db/residence_development.db
Any updates, corrections etc. please let me know, and I’ll add them to
http://chrislowis.co.uk/rails.html
Chris
