How to deploy a Rails application with SQLite3 gem to Heroku

Question

I'm trying to deploy my application to Heroku and it's failing. I get this error:

Failed to install gems via Bundler.
remote:  !     Detected sqlite3 gem which is not supported on Heroku:
remote:  !     https://devcenter.heroku.com/articles/sqlite3
remote:  !
remote:  !     Push rejected, failed to compile Ruby app.

This is my Gemfile:

source 'https://rubygems.org'

gem 'rails', '4.2.5'
gem 'sqlite3'
gem 'sass-rails', '~> 5.0'
gem 'uglifier', '>= 1.3.0'
gem 'coffee-rails', '~> 4.1.0'
#Authentication Gem -> https://github.com/thoughtbot/clearance
gem 'clearance', '~> 1.16.1'
gem 'bootstrap'
gem 'jquery-rails'
gem 'turbolinks'
gem 'jbuilder', '~> 2.0'
gem 'sdoc', '~> 0.4.0', group: :doc
#Gem for search
#https://github.com/karmi/retire
gem 'tire'
gem 'simple_form', '~> 3.4'
gem 'jquery-turbolinks'
gem "chartkick"

group :development, :test do
  gem 'byebug'
end

group :development do
  gem 'web-console', '~> 2.0'
  gem 'spring'
end

Possible duplicate of Heroku deployment failed because of sqlite3 gem error — Mike Szyndel
– Mike Szyndel, Commented Mar 31, 2018 at 20:37

the Tin Man · Accepted Answer · 2020-01-10 04:04:08Z

2

Heroku does not support SQLite3. You can use PostgreSQL instead.

Add sqlite3 only for development:

group :development do
   gem 'sqlite3'
end

group :test, :production do
    gem 'pg'
end

Then run bundle install before committing the changes.

edited Jan 10, 2020 at 4:04

the Tin Man

161k44 gold badges222 silver badges308 bronze badges

answered Mar 31, 2018 at 19:41

Ganesh

2,0141 gold badge20 silver badges33 bronze badges

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

2 Comments

user9409047 Over a year ago

Do i have to reconfigurer my code for postgresql, or will it just work?

Ganesh Over a year ago

It will work, just make changes in gemfile, as suggested in my answer.

ohiodn8 · Accepted Answer · 2018-04-02 04:43:28Z

Ganesh started you off right... in addition to updating your gemfile, you'll also want to edit your config/database.yml

Gemfile =>

group :development, :test do
   gem 'sqlite3'
end

group :production do
    gem 'pg'
end

config/database.yml =>

default: &default
  adapter: sqlite3
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  timeout: 5000

development:
  <<: *default
  database: db/development.sqlite3

test:
  <<: *default
  database: db/test.sqlite3

production:
  adapter: postgresql
  encoding: unicode
  host: localhost 
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  database: sample_production
  username: sample
  password: <%= ENV['SAMPLE_DATABASE_PASSWORD'] %>

where SAMPLE is usually the name of your app...

Collectives™ on Stack Overflow

How to deploy a Rails application with SQLite3 gem to Heroku

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related