From: Eddie Catflap <catflaporama@...>
Date: 2007-08-29T19:50:33+09:00
Subject: SQLIte3 DL driver deprecated, how to use native?

------=_Part_1482_26042071.1188384629741
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi.

I'm writing what's pretty much my first piece of code using Ruby. Very happy
with it so far and have managed to cobble together a bit of code to archive
a large amount of text (basically a message board archive) into a sqlite
database. And it works! One thing is intriguing me though. I'm seeing an
error generated by the line:

db = SQLite3::Database.new( 'test.db' )

The warning message is:

The DL driver for sqlite3-ruby is deprecated and will be removed
in a future release. Please update your installation to use the
Native driver.

I've spent the best part of two days looking for how to get the system to
use the native driver. I'm running on Solaris 10 (sparc). Sqlite3 resides
under /usr/local/bin (and it's libraries under /usr/local/lib ). I've
installed SWIG and reinstalled the sqlite3-ruby gem. Nothing seems to make a
difference. Am I missing a trick here? It may be that this isn't the right
place to ask a question like this, although there seemed to be a fair amount
of SQLite3 related queries in the archive. If this is the wrong place, feel
free to tell me to sod off, I won't be offended ;-)

Here's how I install the sqlite3-ruby gem, and the output - any clues here?
It would seem the native driver is being compiled, should I be doing
something other than using SQLite3::Database.new to choose it?

bash-3.00# gem install sqlite3-ruby
Need to update 16 gems from http://gems.rubyforge.org
................
complete
Select which gem to install for your platform (sparc-solaris2.10)

 1. sqlite3-ruby 1.2.1 (mswin32)
 2. sqlite3-ruby 1.2.1 (ruby)
 3. sqlite3-ruby 1.2.0 (mswin32)
 4. sqlite3-ruby 1.2.0 (ruby)
 5. sqlite3-ruby 1.1.0 (mswin32)
 6. sqlite3-ruby 1.1.0 (ruby)
 7. sqlite3-ruby 1.0.1 (ruby)
 8. sqlite3-ruby 1.0.1 (mswin32)
 9. sqlite3-ruby 1.0.0 (mswin32)
 10. sqlite3-ruby 1.0.0 (ruby)
 11. sqlite3-ruby 0.9.0 (ruby)
 12. sqlite3-ruby 0.9.0 (mswin32)
 13. sqlite3-ruby 0.6.0 (ruby)
 14. sqlite3-ruby 0.5.0 (ruby)
 15. Cancel installation
> 2
Building native extensions.  This could take a while...
make: *** No rule to make target `ruby.h', needed by `sqlite3_api_wrap.o'.
Stop.
make: *** No rule to make target `ruby.h', needed by `sqlite3_api_wrap.o'.
Stop.
ruby extconf.rb install sqlite3-ruby
checking for sqlite3.h... yes
checking for sqlite3_open() in -lsqlite3... no

make

make install

make clean
Successfully installed sqlite3-ruby-1.2.1
Installing ri documentation for sqlite3-ruby-1.2.1...

lib/sqlite3/database.rb:638:65: Skipping require of dynamic string:
"sqlite3/driver/#{driver.to_s.downcase}/driver"

lib/sqlite3/database.rb:643:59: Skipping require of dynamic string:
"sqlite3/driver/#{d.downcase}/driver"
Installing RDoc documentation for sqlite3-ruby-1.2.1...

lib/sqlite3/database.rb:638:65: Skipping require of dynamic string:
"sqlite3/driver/#{driver.to_s.downcase}/driver"

lib/sqlite3/database.rb:643:59: Skipping require of dynamic string:
"sqlite3/driver/#{d.downcase}/driver"


Regards

------=_Part_1482_26042071.1188384629741--