From: Mike Moore <blowmage@...>
Date: 2011-06-12T05:55:29+09:00
Subject: Re: sequel question: Where's SQLite?

--00504502d48eda9a5004a575e7e1
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On Sat, Jun 11, 2011 at 2:30 PM, Chad Perrin <code@apotheon.net> wrote:

> So . . . I need to get the Sequel gem working with SQLite on a Debian
> system, with Ruby 1.8.  I have the sqlite3 package installed from APT,
> and I have Sequel installed from gems.  What I also have is an error when
> I try to "require 'sequel'" and "DB =3D Sequel.sqlite":
>
>    /usr/lib/ruby/vendor_ruby/1.8/rubygems/custom_require.rb:36:in
>    `gem_original_require': LoadError: no such file to load -- sqlite3
>    (Sequel::AdapterNotFound)
>
> What am I missing?
>

Install the "sqlite3-ruby" gem.

     =E2=98=A3 rvm 1.9.2@sequel --create
     =E2=98=A3 gem install sequel
    Fetching: sequel-3.24.1.gem (100%)
    Successfully installed sequel-3.24.1
    1 gem installed
    Installing ri documentation for sequel-3.24.1...
    Installing RDoc documentation for sequel-3.24.1...
     =E2=98=A3 irb
    001 > require "rubygems"
     =3D> false
    002 > require "sequel"
     =3D> true
    003 > DB =3D Sequel.sqlite
    Sequel::AdapterNotFound: LoadError: no such file to load -- sqlite3
    <snip>
    004 > exit
     =E2=98=A3 gem install sqlite3-ruby
    Fetching: sqlite3-1.3.3.gem (100%)
    Building native extensions.  This could take a while...
    Fetching: sqlite3-ruby-1.3.3.gem (100%)

    #######################################################

    Hello! The sqlite3-ruby gem has changed it's name to just sqlite3.
 Rather than
    installing `sqlite3-ruby`, you should install `sqlite3`.  Please update
your
    dependencies accordingly.

    Thanks from the Ruby sqlite3 team!

    <3 <3 <3 <3

    #######################################################

    Successfully installed sqlite3-1.3.3
    Successfully installed sqlite3-ruby-1.3.3
    2 gems installed
    Installing ri documentation for sqlite3-1.3.3...
    Installing ri documentation for sqlite3-ruby-1.3.3...
    Installing RDoc documentation for sqlite3-1.3.3...
    Installing RDoc documentation for sqlite3-ruby-1.3.3...
     =E2=98=A3 irb
    001 > require "sequel"
     =3D> true
    002 > DB =3D Sequel.sqlite
     =3D> #<Sequel::SQLite::Database: "sqlite:/">
    003 > puts "Success!"
    Success!
     =3D> nil
    004 > exit

--00504502d48eda9a5004a575e7e1--