# SQLIte3 DL driver deprecated, how to use native?

**URL:** <https://www.ruby-forum.com/t/sqlite3-dl-driver-deprecated-how-to-use-native/113268>\
**Category:** Ruby\
**Created:** [August 29, 2007, 12:52pm UTC](https://www.ruby-forum.com/t/sqlite3-dl-driver-deprecated-how-to-use-native/113268 "2007-08-29T12:52:01Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eddie\_Catflap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/f475e1/32.png) [@Eddie\_Catflap](https://www.ruby-forum.com/u/Eddie_Catflap)\
**Post date:** [August 29, 2007, 12:52pm UTC](https://www.ruby-forum.com/t/sqlite3-dl-driver-deprecated-how-to-use-native/113268/1 "2007-08-29T12:52:01Z")

</div>

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](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

---

<div class="post-metadata">

**Author:** ![Eddie\_Catflap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/f475e1/32.png) [@Eddie\_Catflap](https://www.ruby-forum.com/u/Eddie_Catflap)\
**Post date:** [August 29, 2007, 3:44pm UTC](https://www.ruby-forum.com/t/sqlite3-dl-driver-deprecated-how-to-use-native/113268/2 "2007-08-29T15:44:43Z")

</div>

Hi,

On Wed, Aug 29, 2007 at 07:50:33PM +0900, Eddie Catflap wrote:

> The warning message is:  
> 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?

[…]

> 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’.

It would appear that rubygems cannot find your ruby.h for your ruby  
installation, which it needs to build the native driver. I have not  
installed ruby on Solaris myself, but is there a ruby.h in the directory  
printed out with this:

```
ruby -rrbconfig -e 'puts ::Config::CONFIG["includedir"]'

```

enjoy,

-jeremy

---

<div class="post-metadata">

**Author:** ![Eddie\_Catflap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/f475e1/32.png) [@Eddie\_Catflap](https://www.ruby-forum.com/u/Eddie_Catflap)\
**Post date:** [August 29, 2007, 4:15pm UTC](https://www.ruby-forum.com/t/sqlite3-dl-driver-deprecated-how-to-use-native/113268/3 "2007-08-29T16:15:51Z")

</div>

Hi Jeremy

Thanks for the quick reply!

On 8/29/07, Jeremy H. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Hi,
> 
> It would appear that rubygems cannot find your ruby.h for your ruby  
> installation, which it needs to build the native driver. I have not  
> installed ruby on Solaris myself, but is there a ruby.h in the directory  
> printed out with this:
> 
> ```
> ruby -rrbconfig -e 'puts ::Config::CONFIG["includedir"]'
> 
> ```

You are onto something there - there isn’t:

-bash-3.00$ ruby -rrbconfig -e ‘puts ::Config::CONFIG[“includedir”]’  
/usr/local/include  
-bash-3.00$ ls /usr/local/include  
c++ libcharset.h ncurses readline zconf.h  
iconv.h localcharset.h python2.5 sqlite3.h zlib.h

However I have found it under /usr/local/lib/ruby/1.8/sparc-solaris2.10  
/ruby.h

I’m guessing the ruby package installed on this system (from  
Sunfreeware.comby the looks of things) sticks the header files in a  
strange place. Adding  
this dir to PATH or LD\_LIBRARY\_PATH wasn’t enough to resolve the  
problem.  
I’ll do a bit more digging around, thanks for pointing me in the right  
direction - I’ll update this once I get the answer.

---

<div class="post-metadata">

**Author:** ![Eddie\_Catflap](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/f475e1/32.png) [@Eddie\_Catflap](https://www.ruby-forum.com/u/Eddie_Catflap)\
**Post date:** [September 3, 2007, 6:19pm UTC](https://www.ruby-forum.com/t/sqlite3-dl-driver-deprecated-how-to-use-native/113268/4 "2007-09-03T18:19:09Z")

</div>

Here’s how I resolved this and managed to get the native driver to  
compile,  
for anyone who’s interested.

I went down the route of removing all gems, rubygems and ruby itself,  
then  
reinstalled ruby from source (not the prebuilt package from  
sunfreeware).  
Then reinstalled rubygems and all the gems I had before.

The sqlite3-ruby gem however would not even compile the ruby driver once  
I’d  
done that! Completed failed - So I downloaded the source and went down  
the  
ruby setup.rb config route:

bash-3.00# ruby setup.rb config  
—\> lib  
—\> lib/sqlite3  
—\> lib/sqlite3/driver  
—\> lib/sqlite3/driver/dl  
\<— lib/sqlite3/driver/dl  
—\> lib/sqlite3/driver/native  
\<— lib/sqlite3/driver/native  
\<— lib/sqlite3/driver  
\<— lib/sqlite3  
\<— lib  
—\> ext  
—\> ext/sqlite3\_api  
/usr/local/bin/ruby  
/var/tmp/sqlite3-ruby-1.2.1/ext/sqlite3\_api/extconf.rb  
checking for sqlite3.h… yes  
checking for sqlite3\_open() in -lsqlite3… no  
—\> ext/sqlite3\_api/win32  
\<— ext/sqlite3\_api/win32  
\<— ext/sqlite3\_api  
\<— ext

The next step failed however:

bash-3.00# ruby setup.rb setup  
—\> lib  
—\> lib/sqlite3  
—\> lib/sqlite3/driver  
—\> lib/sqlite3/driver/dl  
\<— lib/sqlite3/driver/dl  
—\> lib/sqlite3/driver/native  
\<— lib/sqlite3/driver/native  
\<— lib/sqlite3/driver  
\<— lib/sqlite3  
\<— lib  
—\> ext  
—\> ext/sqlite3\_api  
make  
make: \*\*\* No rule to make target `ruby.h', needed by `sqlite3\_api\_wrap.o’.  
Stop.  
'system make ’ failed  
Try ‘ruby setup.rb --help’ for detailed usage.

After much wailing and gnashing of teeth I came across the following  
url:

[http://readlist.com/lists/sqlite.org/sqlite-users/0/4442.html](http://readlist.com/lists/sqlite.org/sqlite-users/0/4442.html)

Where a Mr Stephen Fitch described his (similar, but not exact) problem  
with  
the package on Solaris 10. His solution was to

export LD\_OPTIONS=“-lposix4”

before running ruby setup.rb config etc, so I tried it… and it worked!

bash-3.00# ruby setup.rb config  
—\> lib  
—\> lib/sqlite3  
—\> lib/sqlite3/driver  
—\> lib/sqlite3/driver/dl  
\<— lib/sqlite3/driver/dl  
—\> lib/sqlite3/driver/native  
\<— lib/sqlite3/driver/native  
\<— lib/sqlite3/driver  
\<— lib/sqlite3  
\<— lib  
—\> ext  
—\> ext/sqlite3\_api  
/usr/local/bin/ruby  
/var/tmp/sqlite3-ruby-1.2.1/ext/sqlite3\_api/extconf.rb  
checking for sqlite3.h… yes  
checking for sqlite3\_open() in -lsqlite3… yes  
creating Makefile  
—\> ext/sqlite3\_api/win32  
\<— ext/sqlite3\_api/win32  
\<— ext/sqlite3\_api  
\<— ext  
bash-3.00# ruby setup.rb setup  
—\> lib  
—\> lib/sqlite3  
—\> lib/sqlite3/driver  
—\> lib/sqlite3/driver/dl  
\<— lib/sqlite3/driver/dl  
—\> lib/sqlite3/driver/native  
\<— lib/sqlite3/driver/native  
\<— lib/sqlite3/driver  
\<— lib/sqlite3  
\<— lib  
—\> ext  
—\> ext/sqlite3\_api  
make  
gcc -I. -I. -I/usr/local/lib/ruby/1.8/sparc-solaris2.10  
-I/var/tmp/sqlite3-  
ruby-1.2.1/ext/sqlite3\_api -DHAVE\_SQLITE3\_H -I/usr/local/include -fPIC  
-g  
-O2 -c sqlite3\_api\_wrap.c  
gcc -shared -L’/usr/local/lib’ -Wl,-R’/usr/local/lib’  
-L’/usr/local/lib’  
-Wl,-R’/usr/local/lib’ -o sqlite3\_api.so sqlite3\_api\_wrap.o -lsqlite3  
-ldl  
-lcrypt -lm -lc  
—\> ext/sqlite3\_api/win32  
\<— ext/sqlite3\_api/win32  
\<— ext/sqlite3\_api  
\<— ext

After that it was just a case of ruby setup.rb install, test it out  
and… no  
more ‘deprecated’ warnings. So thanks to Mr Fitch, wherever you may be.