CODEWITHSUNDEEP
ruby-on-railsruby-on-rails-3heroku
glarkou
glarkou

Reputation: 7101

Two different databases

Is it possible to have two different databases for development or production? One for Heroku and one for local development?

Heroku uses PostgreSQL but I prefer SQLlite for local development.

Upvotes: 0

Views: 69

Answers (1)

John Beynon
John Beynon

Reputation: 37507

yes, it's totally possible - you can then use heroku db:push to push your local SQLite database into postgres running on Heroku.

BUT

And this is from personal experience, I've run into situations where SQL I've written is different between sqlite/postgres/mysql AND also gems I've used which themselves used findbysql which weren't tested against postgres and has then caught my out when I've put it on Heroku.

For the few seconds it takes to install postgres locally I would STRONGLY recommend you use the DB platform you are ultimately going to deploy to.

Upvotes: 3

Related Questions