From: basi <basi_lio@...>
Date: 2005-10-01T12:46:45+09:00
Subject: Re: SQLite / Ruby on Windows?

Hello,
Been wanting to try Ruby and Sqlite3...

But step #3 does not work. Gem install says:

Local gem file not found: sqlite3*.gem.

Then, in the attempt to do a remote install, again the complaint is
that sqlite3 could not be found in the repository?

Might I have missed a step here?

Thanks,
Basi

Jeff Wood wrote:
> There are three phases:
>
> #1 - Collect underpants
> #2 - ??
> #3 - Profit!
>
> just kidding ...
>
> Here are the steps to get it working.
>
> #1 Download http://www.sqlite.org/sqlite-3_2_7.zip
> #2 Download http://www.sqlite.org/sqlitedll-3_2_7.zip
>
> Unzip and install the resulting files into your C:\Windows\System32
> directory
>
> #3 Use "gem" to install the sqlite3 package:
>
> "gem install sqlite3"
>
> ... when prompted by the installer, type 2 and press enter. This will install
> sqlite3-ruby 1.1.0 (mswin32)
>
> It will run for a bit and should end successfully
>
> You can now use SQLite3
>
> From irb use the following test script:
>
>
> --SCRIPT--
> require 'sqlite3'
>
> db = SQLite3::Database.new( "test.db" )
> db.execute( "create table test ( foo int, bar text, baz int );" )
> db.execute( "insert into test ( foo, bar, baz ) values ( 1, 'test', 3 );" )
> db.execute( "select * from test" ) { |row| puts row.join( ',' ) }
> db.execute2( "select * from test" ) { |row| puts row.join( ',' ) }
> --SCRIPT--
>
>
> j.
>
> On 9/30/05, Austin Ziegler <halostatue@gmail.com> wrote:
> >
> > On 9/30/05, david@vallner.net <david@vallner.net> wrote:
> > > Does anyone have an install-by-copy version of the SQLite Ruby binding
> > at hand?
> > > I'm in sore need of an embeddable SQL database and I admit to being
> > completely
> > > uncapable of compiling Ruby extensions on my Windows box.
> >
> > Try installing it with RubyGems.
> >
> > -austin
> > --
> > Austin Ziegler * halostatue@gmail.com
> > * Alternate: austin@halostatue.ca
> >
> >
> 
> 
> --
> "http://ruby-lang.org -- do you ruby?"
> 
> Jeff Wood