Installing Sqlite3 for Ruby (Mac OSX 10.5.8)

Question

I am following this guide ATM - http://guides.rubyonrails.org/getting_started.html#getting-up-and-running-quickly-with-scaffolding

When trying to create a database, I got:

Morgans-Computer:blog Morgan$ rake db:create Could not find gem 'sqlite3 (>= 0)' in any of the gem sources listed in your Gemfile. Run bundle install to install missing gems.

When I try to run 'bundle install', I get more errors:

Installing sqlite3 (1.3.4) with native extensions /Users/Morgan/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/site_ruby/1.9.1/rubygems/installer.rb:551:in `rescue in block in build_extensions': ERROR: Failed to build gem native extension. (Gem::Installer::ExtensionBuildError)

    /Users/Morgan/.rvm/rubies/ruby-1.9.2-p290/bin/ruby extconf.rb

I have tried to install the Ruby Gem Sqlite3 (http://rubygems.org/gems/sqlite3-ruby) but it continues to fail. I found another post on here saying that I need to install C because that is what the compiler is written in? Wasn't sure exactly what that meant, or how I go about doing it.

Any help would be greatly appreciated!!

score 4 · Answer 1 · edited Oct 16 '21 at 05:45

4

If you don't already have homebrew installed, I would set that up first. It's a nice package manager and allows you to install things like sqlite with brew install sqlite.

To install brew you'll need xcode installed. If you don't already have that you'll probably need the cd that came with you system, or you can download from apple's website. On the latest OS, you can install it from the App Store which is nice (This might work for you too).

If you have mysql and would prefer to use that instead and sidestep the sqlite issue you can generate your rails project as such.

rails new my_new_project -d mysql

edited Oct 16 '21 at 05:45

Glorfindel

21,988
13
81
109

answered Oct 09 '11 at 03:27

Blake Taylor

9,217
5
38
41

omg...I have been looking for that answer for hours. Thanks! Will test it out and let you know (I have homebrew installed already)....update: that worked!! thank you – Morgan Allen Oct 09 '11 at 03:31

ryantm · Answer 2 · 2011-10-09T04:04:49.133

1

When you install the sqlite adapter gem, it has to compile code. To compile the code, it needs access to the sqlite development libraries.

This Rails on Mac OS X tutorial explains how to do it. Here is the most immediately relevant part:

   sudo chown -R `whoami` /usr/local #make sure we have correct permissions to install sqlite
   brew install sqlite
   gem install sqlite3

edited Oct 09 '11 at 04:04

answered Oct 09 '11 at 03:26

ryantm

8,217
6
45
57

I have homebrew installed. Yea, I have seen the posts for ubntu, but that doesn't seem to work in mac? – Morgan Allen Oct 09 '11 at 03:29
Certainly that doesn't work on OSX, it doesn't use apt as a package manager. – ryantm Oct 09 '11 at 03:36
yea, once I got brew install sqlite, I got it going from there. Thanks again for the help, the hair that I have left will remain on my head... – Morgan Allen Oct 09 '11 at 03:57
Good to hear. I'd give Blake Taylor best answer, then. – Adam Eberlin Oct 09 '11 at 04:00

score 0 · Answer 3 · edited Oct 13 '21 at 05:45

0

On Mac, you'll probably want to install Xcode. You will also likely need some other packages for sqlite3, which you should be able to get through MacPorts (ports: sqlite3 + rb19-sqlite3).

If you already have Xcode installed, go to the MacPorts Install page, download and install the provided .dmg. Then you should be able to run this from the console to install the necessary packages:

sudo port install sqlite3 rb19-sqlite3

You can also use Homebrew, as others have suggested.

edited Oct 13 '21 at 05:45

Glorfindel

21,988
13
81
109

answered Oct 09 '11 at 03:24

Adam Eberlin

14,005
5
37
49

Yea, I have Xcode installed. How do I install the other packages? – Morgan Allen Oct 09 '11 at 03:28

Installing Sqlite3 for Ruby (Mac OSX 10.5.8)

3 Answers3

Linked