HEROKU AND SQLITE - I HAVE A PROBLEM

rubyonrails-talk
1

Hello People,

I can´t publish Ruby on Rails application on HEROKU. It says "file sqlite3 is missing". But I know it´s 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,

3

Hello People,

I can´t publish Ruby on Rails application on HEROKU. It says "file

sqlite3 is missing". But I know it´s 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

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

5

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