Getting SQLite3 errors even though I am trying to use PostgreSQL on Rails 3 development machine

Question

Newbie question on Rails 3 development.

I am creating my first app and planning on deploying it to Heroku. Since Heroku uses PostgreSQL I thought I would change from SQLite on my development machine and move to PostgreSQL. Here is the gem file:

***source 'http://rubygems.org'

gem 'rails', '3.0.1'

gem 'pg', :require => 'pg'

gem 'devise', '1.2.0'

group :development do

gem 'rspec-rails', '2.0.1'

end

group :test do

gem 'rspec', '2.0.1'

gem 'webrat', '0.7.1'

end***

I ran a page generator but whenever I try to view the pages locally, I get the following error:

no such file to load -- sqlite3

I don't understand where this SQLite error is coming from because I commented out SQLite from the gemfile.

The bigger question is rather it is neccesary to change my database gem at all. Is it better to develop with SQLite and let the host convert the databases?

TIA

mu is too short · Accepted Answer · 2011-03-27 18:50:54Z

1

The problem is probably in your database.yml, I'd guess that it looks something like this:

development:
  adapter: sqlite3

but you want it to look more like this:

development:
  adapter: postgresql

You'll probably want to apply the same change to the test: and production: sections as well; Heroku won't pay attention to the adapter but consistency is a good idea.

As far as the second question goes, I think you're better off developing and deploying on identical platforms. You can usually get away with developing on OSX or Windows but deploying on Linux if you're careful but you should have the same gem versions, same Ruby version, same Rails version, same database (including the version!), etc. Anything else is going to cause you a lot of pain and suffering sooner or later. So, kudos for developing on PostgreSQL when you're deploying on Heroku, good call.

edited Mar 27, 2011 at 18:50

answered Mar 27, 2011 at 4:47

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user678604 Over a year ago

Thanks for the help. You were correct on the database.yml. Unfortunately that was the tip of the iceberg. I installed the postgresql gem after i started the aplication. Thats why the database was setup to look for sqlite. After slugging through error after error, I decide to just start over from scratch (not really that far along anyway.) In case anyone is googling and looking for info on setting up postgresql on rails 3 I am following this guide -- funonrails.com/2011/03/…. For some reason i didnt find this guide the first time

user678604 Over a year ago

here is the link funonrails.com/2011/03/…

Collectives™ on Stack Overflow

Getting SQLite3 errors even though I am trying to use PostgreSQL on Rails 3 development machine

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related