SQLite / Ruby on Windows?

[david]

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 compl=
etely
uncapable of compiling Ruby extensions on my Windows box.

David Vallner

 

[Austin Ziegler]

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 compl= etely
uncapable of compiling Ruby extensions on my Windows box.

Try installing it with RubyGems.

-austin

 

[basi]

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

 

[x1]

try, gem install sqlite3-ruby

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

 

[James Britt]

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?

Here's what works for me:

d:\development>gem install sqlite3

d:\development>"c:\ruby\bin\ruby.exe" "c:\ruby\bin\gem" install sqlite3
Attempting local installation of 'sqlite3'
Local gem file not found: sqlite3*.gem
Attempting remote installation of 'sqlite3'
Select which gem to install for your platform (i386-mswin32)
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)
11. Cancel installation


James
--

http://www.ruby-doc.org - The Ruby Documentation Site
http://www.rubyxml.com - News, Articles, and Listings for Ruby & XML
http://www.rubystuff.com - The Ruby Store for Ruby Stuff
http://www.jamesbritt.com - Playing with Better Toys

 

[basi]

That works.
thanks!
basi

 

[basi]

Install completed, however, when requiring, I get this:

irb(main):001:0> require 'sqlite3'
=> false
irb(main):002:0> require 'sqlite3-ruby'
LoadError: No such file to load -- sqlite3-ruby
from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:in
`require__'
from c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:21:in
`require'
from (irb):2
from
c:/ruby/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0-mswin32/lib/sqlite3/database.rb:237
irb(main):003:0>

 

[Austin Ziegler]

Install completed, however, when requiring, I get this:

irb(main):001:0> require 'sqlite3'
=3D> false

This part is probably because of a bug in RubyGems that I *think* is
being looked at.

Check to see if the Sqlite3 constant (I *think* that's the one) has been ad=
ded.

irb(main):002:0> require 'sqlite3-ruby'
LoadError: No such file to load -- sqlite3-ruby

This is the name of the gem, not the item to require.

-austin

 

[david]

*blush* Silly me didn't notice the mswin binary distro of the extension.

There are three phases:
=20
#1 - Collect underpants
#2 - ??
#3 - Profit!

I -am- intrugued now ;P

=20
just kidding ...
Awww...


=20
Unzip and install the resulting files into your C:\Windows\System32
directory

I sincerely hope you're not serious, there's enough banter in that direct=
ory
already. I'll have to womble about the ruby installation dir to find out =
where
does windows look for DLLs, or just hack PATH to include a suitable locat=
ion
before running the script.

Cheers anyway, that should make the DBMS 301 assignment insanely easier, =
what
with being able to deploy without installing anything.

 

[Jeff Wood]

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

system32 is the normal place that the system will go looking for DLLs ...
that's how windows works.

if you want to try and go around that, have fun. what I suggested *will*
work.

And if I wasn't serious ... then why would I post it?

j.

*blush* Silly me didn't notice the mswin binary distro of the extension.



I -am- intrugued now ;P


I sincerely hope you're not serious, there's enough banter in that
directory
already. I'll have to womble about the ruby installation dir to find out
where
does windows look for DLLs, or just hack PATH to include a suitable
location
before running the script.

Cheers anyway, that should make the DBMS 301 assignment insanely easier,
what
with being able to deploy without installing anything.

--
"http://ruby-lang.org -- do you ruby?"

Jeff Wood

------=_Part_17339_30442356.1128537352856--

 

[david]

system32 is the normal place that the system will go looking for DLLs .= ..
that's how windows works.
=20

Not since Win2K it isn't, apparently. I confirmed my hunch I read about t=
hat in
some documentation. The NT branch of Windows also looks for DLLs in direc=
tories
in the PATH environment variable. And possibly in the location of the
executable as well, I haven't tried that.

if you want to try and go around that, have fun. what I suggested *will= *
work.
=20

Not on machines I don't have admin privileges on.=20

So, I guess this is another bit of useless trivia floating around ruby-ta=
lk,
anyone deploying applications with DLL dependencies in war conditions mig=
ht
actually use this.

Aaanyways, thanks again, SQLite works like a charm, and I'm getting ready=
to
wear my Ruby slippers to school for the first time. Wish me luck Fighting=
The
System.

David Vallner

PS: The bit about not benig serious was tongue-in-cheek...