Heroku and sqlite - i have a problem

Rails
1

Hello People,

I cant publish Ruby on Rails application on HEROKU. It says “file
sqlite3 is missing”. But I know its not missing and the application
runs allright on my computer.

Is it true that I should stop using SQLITE as database and replace it
for POSTGRES ?

HEROKU works only with POSTGRES on a Ruby On Rails application ?

Thanks a Lot
Frederico

2

Frederico Barbosa wrote in post #949839:

Hello People,

I cant publish Ruby on Rails application on HEROKU. It says “file
sqlite3 is missing”.

Let’s see the error trace.

But I know its not missing and the application
runs allright on my computer.

Is it true that I should stop using SQLITE as database and replace it
for POSTGRES ?

HEROKU works only with POSTGRES on a Ruby On Rails application ?

Heroku uses PostgreSQL – a good thing, since SQLite is not appropriate
for production use. You can still develop locally with SQLite, or you
can install PostgreSQL locally for development. I’ve done it both ways.

Thanks a Lot
Frederico

Best,

Marnen Laibow-Koser
http://www.marnen.org
[email protected]

3

On Wed, Oct 13, 2010 at 8:01 AM, Frederico Barbosa
[email protected]wrote:

Hello People,

I cant publish Ruby on Rails application on HEROKU. It says “file
sqlite3 is missing”. But I know its not missing and the application
runs allright on my computer.

It may be because you have sqllite gem in your gemfile? If so, you
should
try doing something like this which isolates gems you dont need to send
to
heroku. I had a similar problem with trying to push the ruby-debug gem
to
them:

$heroku = ENV[‘USER’] ? !! ENV[‘USER’].match(/^repo\d+/) :
ENV.any?{|key, |
key.match(/^HEROKU/)}
unless $heroku
group :development, :test do
gem ‘ruby-debug19’
gem ‘cucumber-rails’
gem ‘cucumber’, ‘>=0.8.5’
gem ‘capybara’
gem ‘rspec-rails’, ‘>=2.0.0.beta.20’
gem ‘factory_girl_rails’
gem ‘webrat’, ‘>=0.4.3’
gem ‘heroku’
gem ‘database_cleaner’
end
end

4

Pierrot wrote in post #949900:
Hi,
just edit gemfile and comment out the sqlite entry, then ‘bundle
install’.
This should help.
Dani

5

Hi. I use sqlite to develop no problem. When you push heroku maps the
db to postgress. It’s done automatically.