Deploying RoR app to Heroku with SQLite 3 fails

by

Heroku doesn’t support SQLite databases. You need to use PostgreSQL on production, as I also explained in this post.

group :production do
  gem "pg"
end

group :development, :test do
  gem "sqlite3", "~> 1.3.0"
end

Actually, it’s recommended to use in development/test an environment as close as possible to production. Therefore, I suggest you to switch all your environments to PostgreSQL.

# replace gem "sqlite3" with
gem "pg"

More Related Contents:

  1. Heroku deployment failed because of sqlite3 gem error
  2. Pushing Rails with SQLite3 to Heroku fails [duplicate]
  3. Errors of pushing rails app to Heroku error occurred while installing sqlite3, and Bundler cannot continue [duplicate]
  4. Heroku deployment error H10 (App crashed)
  5. Change from SQLite to PostgreSQL in a fresh Rails project
  6. HEROKU – cannot run git push heroku master [duplicate]
  7. Boolean Validation
  8. cannot load such file — sqlite3/sqlite3_native (LoadError) on ruby on rails
  9. Rails 2.3-style plugins and deprecation warnings running task in Heroku
  10. Clean way to find ActiveRecord objects by id in the order specified
  11. How to fix the uninitialized constant Rake::DSL problem on Heroku?
  12. OpenSSL::SSL::SSLError on Heroku [duplicate]
  13. How to configure Google Domains + Heroku w a Naked Domain
  14. Rails 4 images not loading on heroku
  15. Heroku/devise – Missing host to link to! Please provide :host parameter or set default_url_options[:host]
  16. Heroku upload-Precompiling assets failed
  17. Cannot add a NOT NULL column with default value NULL in Sqlite3
  18. GroupingError: ERROR: column must appear in the GROUP BY clause or be used in an aggregate function
  19. Why do people use Heroku when AWS is present? What distinguishes Heroku from AWS? [closed]
  20. Heroku not sending email with Gmail SMTP
  21. “bin/rails: No such file or directory” w/ Ruby 2 & Rails 4 on Heroku
  22. Slow initial server startup when using Phusion Passenger and Rails
  23. Long running delayed_job jobs stay locked after a restart on Heroku
  24. How can I solve this trouble to deploy a Rails App to Heroku?
  25. Why can’t I install the SQLite gem?
  26. Heroku SSL on root domain
  27. sqlite3 gem fails to install
  28. Why won’t Heroku accept my Gemfile.lock in Windows?
  29. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  30. Heroku – Display hash of current commit in browser

Leave a Comment