Ruby SQLite under cygwin

Hello to the forum,

I have been trying to get sqlite3-ruby going under cygwin (XP 32-bit). I
have had ruby-cygwin installed for a while (ruby 1.8.7 (2012-02-08
patchlevel 358) [i386-cygwin]), and it seems to work fine from bash and
.rb scripts. There is no libsqlite3-ruby package in the cygwin package
manager, so looking at this post,

I tried to instal it with gem,
gem install sqlite3-ruby

but I get an error,
-bash: gem: command not found

There seem to be a number of posts on this, but nothing definitive. Is
there a prescribed method to get this working?

Thanks for the advice,


I was able to get SQLite Ruby installed and working under cygwin using
the following method.

  1. Install the following cygwin packages,
    Ruby > ruby (1.8.7-p358-2)
    Database > sqlite3
    Database > libsqlite3_0
    Database > libsqlite3-devel

  2. download the ruby gems src from,
    save the tar file anywhere in the cygwin tree (I used /home)

  3. unzip and unpack the tar,
    gzip -d rubygems-1.8.24.tgz
    tar xvf rubygems-1.8.24.tar

  4. cd to /rubygems-1.8.24 and run,
    ruby setup.rb install

  5. update gems, (this didn’t do anything for me)
    gem update --system

  6. install sqlite3-ruby with gems,
    gem install sqlite3-ruby

This appeared to work, but I need to do some additional testing.