From: Ammon Christiansen <ammon.christiansen@...>
Date: 2005-11-04T03:05:33+09:00
Subject: Fwd: sqlite - and ruby

------=_Part_26159_29507646.1131041129467
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I wanted to share my experiences getting sqlite3 and ruby working in a user
account on Linux (installed in local directory (using
--prefix=3D/my/home/directory/whateverbin)). You can see the conversation
between Jamis and me to get an example working.

I had to do one more thing besides what is below:
export LD_LIBRARY_PATH=3D$LD_LIBRARY_PATH:/path/to/libsqlite3.so

A symbolic link to the current directory isn't good enough.

Duane and Jamis have been very helpful getting me started with Ruby. Thanks
guys

Ammon

On 11/3/05, Jamis Buck <jamis@37signals.com> wrote:
>
> On Nov 3, 2005, at 10:01 AM, Ammon Christiansen wrote:
>
> > 1 require 'rubygems'
> > 2 require 'sqlite3'
> > 3 #require 'sqlite3-ruby'
> > Thanks for catching the SQLite3 thing. Am I doing anything else
> > wrong on line 6: I get the error
> >
> > ajc55@chocolate:~/Research/ParseXML$ ruby testsqlite.rb
> > /fse/ajc55/rubybin/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/
> > sqlite3/database.rb:106:in `initialize': undefined method `fetch'
> > for 420:Fixnum (NoMethodError)
> > from testsqlite.rb:6
> >
> >
> > 4 #require 'sqlite-ruby'
> > 5
> > 6 db =3D SQLite3::Database.new( 'sample.db', 0644 )
>
> Looks like the problem is the 0644 you're giving it.
> SQLite3::Database.new takes two parameters, the second one optional.
> The second one is supposed to be a Hash of options to use when
> opening the database. (There isn't a way to specify the file mode on
> the new file, unfortunately.)
>
> If you take out the 0644 parameter, it should work fine.
>
> - Jamis
>
> > 7
> > 8 db.execute <<SQL
> > 9
> > 10 CREATE TABLE sites (
> > 11 idx INTEGER PRIMARY KEY,
> > 12 url VARCHAR(255)
> > 13 );
> > 14
> > 15 SQL
> >
> > Thanks Jamis for helping me out!!
> > Ammon
> >
> >
> > On 11/3/05, Jamis Buck < jamis@37signals.com> wrote: On Nov 3, 2005,
> > at 9:47 AM, Ammon Christiansen wrote:
> >
> > > The require for sqlite3 returns false at the bottom. This is how I
> > > did my setup:
> > >
> > > I installed sqlite3 from source and installed the sqlite3-ruby gem
> > > using
> > >
> > > gem install sqlite3 -- --with-sqlite3-include=3D/fse/ajc55/sqlitebin/
> > > include --with-sqlite3-lib=3D$HOME/sqlitebin/lib
> > > Select which gem to install for your platform (i686-linux)
> > > 1. sqlite3-ruby 1.1.0 (ruby)
> > > 2. sqlite3-ruby 1.1.0 (mswin32)
> > > 3. sqlite3-ruby 1.0.1 (ruby)
> > > 4. sqlite3-ruby 1.0.1 (mswin32)
> > > 5. sqlite3-ruby 1.0.0 (mswin32)
> > > 6. sqlite3-ruby 1.0.0 (ruby)
> > > 7. sqlite3-ruby 0.9.0 (ruby)
> > > 8. sqlite3-ruby 0.9.0 (mswin32)
> > > 9. sqlite3-ruby 0.6.0 (ruby)
> > > 10. sqlite3-ruby 0.5.0 (ruby)
> > > (I chose 1)
> > > with the following warnings:
> > >
> > > Successfully installed sqlite3-ruby-1.1.0
> > > Installing RDoc documentation for sqlite3-ruby-1.1.0...
> > >
> > > lib/sqlite3/database.rb:637:65: Skipping require of dynamic string:
> > > "sqlite3/driver/#{ driver.to_s.downcase}/driver"
> > >
> > > lib/sqlite3/database.rb:642:59: Skipping require of dynamic string:
> > > "sqlite3/driver/#{d.downcase}/driver"
> > >
> > > I don't know what to make of the warnings and require 'sqlite3'
> > > returns false
> > > What does that mean?
> >
> > The warnings are just the rdoc generator saying it doesn't know how
> > to follow a dynamically generated string in order to parse the
> > referenced file. You can safely ignore those. (I really wish rdoc
> > didn't spew those messages out, but the current maintainer of rdoc
> > doesn't seem interested in doing anything with it.)
> >
> > Regarding "require 'sqlite3'" returning false, all it means is that
> > it has already been required elsewhere. When using rubygems (or irb),
> > I've noticed that require often returns false even if the file hasn't
> > been required elsewhere. Regardless, it's not an error condition. If
> > the file could not be required, an exception would have been raised.
> >
> > Are you having a problem running the program? Do you get an error?
> > (One thing I noticed in the program--you are referring to
> > SQLite::Database, but using the sqlite3 library. You ought to be
> > doing SQLite3::Database, in that case.)
> >
> > - Jamis
> >
> > >
> > > Here's the program
> > > 1 require 'rubygems'
> > > 2 require 'sqlite3'
> > > 3 #require 'sqlite3-ruby'
> > > 4 #require 'sqlite-ruby'
> > > 5
> > > 6 db =3D SQLite::Database.new( 'sample.db', 0644 )
> > > 7
> > > 8 db.execute <<SQL
> > > 9
> > > 10 CREATE TABLE sites (
> > > 11 idx INTEGER PRIMARY KEY,
> > > 12 url VARCHAR(255)
> > > 13 );
> > > 14
> > > 15 SQL
> > >
> >
> >
>
>

------=_Part_26159_29507646.1131041129467--