# Sqlite3 on Ruby

**URL:** <https://www.ruby-forum.com/t/sqlite3-on-ruby/169911>\
**Category:** Ruby\
**Created:** [June 10, 2009, 6:46am UTC](https://www.ruby-forum.com/t/sqlite3-on-ruby/169911 "2009-06-10T06:46:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![include](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/47e85d/32.png) [@include](https://www.ruby-forum.com/u/include)\
**Post date:** [June 10, 2009, 6:46am UTC](https://www.ruby-forum.com/t/sqlite3-on-ruby/169911/1 "2009-06-10T06:46:39Z")

</div>

Hello I’m trying to install gem sqlite 3 and I’m getting this error:

root@kundera-laptop:/usr/local/lib/ruby/gems# gem install sqlite3-ruby  
–version 1.2.2  
Building native extensions. This could take a while…  
ERROR: Error installing sqlite3-ruby:  
ERROR: Failed to build gem native extension.

/usr/local/bin/ruby extconf.rb  
checking for fdatasync() in -lrt… yes  
checking for sqlite3.h… no  
\*\*\* extconf.rb failed \*\*\*  
Could not create Makefile due to some reason, probably lack of  
necessary libraries and/or headers. Check the mkmf.log file for more  
details. You may need configuration options.

Provided configuration options:  
–with-opt-dir  
–without-opt-dir  
–with-opt-include  
–without-opt-include=${opt-dir}/include  
–with-opt-lib  
–without-opt-lib=${opt-dir}/lib  
–with-make-prog  
–without-make-prog  
–srcdir=.  
–curdir  
–ruby=/usr/local/bin/ruby  
–with-sqlite3-dir  
–without-sqlite3-dir  
–with-sqlite3-include  
–without-sqlite3-include=${sqlite3-dir}/include  
–with-sqlite3-lib  
–without-sqlite3-lib=${sqlite3-dir}/lib  
–with-rtlib  
–without-rtlib

Gem files will remain installed in  
/usr/local/lib/ruby/gems/1.9.1/gems/sqlite3-ruby-1.2.2 for inspection.  
Results logged to  
/usr/local/lib/ruby/gems/1.9.1/gems/sqlite3-ruby-1.2.2/ext/sqlite3\_api/gem\_make.out

The make out file was not helpful at all so if anyone knows what is the  
problem , what do I need to install I will highly appreciate it.  
Regards

---

<div class="post-metadata">

**Author:** ![include](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/47e85d/32.png) [@include](https://www.ruby-forum.com/u/include)\
**Post date:** [June 10, 2009, 7:05am UTC](https://www.ruby-forum.com/t/sqlite3-on-ruby/169911/2 "2009-06-10T07:05:35Z")

</div>

Which O/S are you using?

For Windows XP, sqlite3-ruby 1.2.3 apparently was the last version which  
had  
a precompiled gem file available (hence the attempt by gem to compile a  
fresh one for version 1.2.4 or newer installations). The work-around is  
to  
install an older version which seems to work although it has its  
foibles. So  
to install the older version just type:

C:\> gem install sqlite3-ruby -v=1.2.3

Satish T.

On Wed, Jun 10, 2009 at 10:17 AM, Francisco Colina  
\<removed\_email\_address@domain.invalid

---

<div class="post-metadata">

**Author:** ![include](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/47e85d/32.png) [@include](https://www.ruby-forum.com/u/include)\
**Post date:** [June 10, 2009, 8:36am UTC](https://www.ruby-forum.com/t/sqlite3-on-ruby/169911/3 "2009-06-10T08:36:16Z")

</div>

Francisco Colina wrote:

> Hello I’m trying to install gem sqlite 3 and I’m getting this error:
> 
> root@kundera-laptop:/usr/local/lib/ruby/gems# gem install sqlite3-ruby  
> –version 1.2.2  
> Building native extensions. This could take a while…

You need to install the sqlite development headers also. You could find  
some information if you search the net for something like “ubuntu  
install sqlite3” - you’ll need to set up sqlite with the development  
headers and then when you run the sqlite3 gem install, it will be able  
to build native extensions.

Cheers,  
Mohit.  
6/10/2009 | 2:35 PM.

---

<div class="post-metadata">

**Author:** ![include](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/47e85d/32.png) [@include](https://www.ruby-forum.com/u/include)\
**Post date:** [June 12, 2009, 12:08pm UTC](https://www.ruby-forum.com/t/sqlite3-on-ruby/169911/4 "2009-06-12T12:08:03Z")

</div>

Hi:

I had a similar error. The error went away when I installed  
libsqlite3-dev on Linux (Ubuntu).via Synaptic.

Hope this helps.

Good day.

---

<div class="post-metadata">

**Author:** ![include](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/47e85d/32.png) [@include](https://www.ruby-forum.com/u/include)\
**Post date:** [June 10, 2009, 11:26pm UTC](https://www.ruby-forum.com/t/sqlite3-on-ruby/169911/5 "2009-06-10T23:26:19Z")

</div>

Mohit & Satish

Thank you guys for the reply , I successfully install sqlite3 in my  
computer.

Regards