CODEWITHSUNDEEP
ruby-on-rails-3herokusqlite
CiaranC94
CiaranC94

Reputation: 184

I can't migrate the database of my Rails app on Heroku with sqlite

I'm following this tutorial on creating Ruby on Rail apps, and I've hit a roadblock. I am trying to migrate its database to Heroku, only to be told this:

c:\Sites\railsbridge\test_app>heroku run rails db:migrate
Running rails db:migrate on floating-ocean-40882... up, run.5709 (Free)
rails aborted!
Gem::LoadError: Specified 'sqlite3' for database adapter, but the gem is not 
loaded. Add `gem 'sqlite3'` to your Gemfile (and ensure its version is at the 
minimum required by ActiveRecord).

I already have sqlite3 listed in my Gemfile, what am I doing wrong?

Upvotes: 0

Views: 325

Answers (2)

user7208575
user7208575

Reputation:

Heroku doesn't support SQLite it only support PostgresSQL here is full documentation for deployment on Heroku

Upvotes: 0

logesh
logesh

Reputation: 2662

Heroku does not support sqlite and it is suggested to use postgresql for production

Please look into the following posts

Heroku deployment failed because of sqlite3 gem error

Deploying RoR app to Heroku with Sqlite3 fails

You can use Postgresql for production and the change should be simple. Just a change of gem in Gemfile and change in database.yml will do.

Upvotes: 3

Related Questions