From: x1 <caldridge@...>
Date: 2005-10-01T12:53:04+09:00
Subject: Re: SQLite / Ruby on Windows?

try, gem install sqlite3-ruby

On 9/30/05, basi <basi_lio@hotmail.com> wrote:
> 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
>
>
>