CODEWITHSUNDEEP
ruby-on-railsdatabaseheroku
Blues Zhou
Blues Zhou

Reputation: 306

Which database should be chosen in Heroku?

I want to migrate a database to Heroku. The old database is exported to some JSON files, but now I don't know how to select the database in Heroku.

My issue is:

What should I do?

Upvotes: 0

Views: 155

Answers (2)

Tzu ng
Tzu ng

Reputation: 9244

It's better that you specify the database you currently use for your application. If you give more information, I will update my answer.

But firstly, reading the article Moving a Rails App to Heroku will help you a lot with moving the application to Heroku.

  1. Heroku has addons from another provider. The only database they provide is PostgreSQL which is very nice and suitable for many kind of applications. It's just brilliant.
  2. Read the mentioned article above.
  3. If you create your application in Heroku, it will be located in the USA by default. I don't know if Heroku optimizes to the location of your application and addons or not, but normally if you have something slow in your application, it's your fault, not Heroku's.
  4. Yes! Heroku loves Ruby on Rails

Upvotes: 2

shrikant1712
shrikant1712

Reputation: 4446

First of all, Heroku provides PostgreSQL as the default database. It might be the following reasons for use it.

  1. PostgreSQL is a powerful, open source object-relational database system.

  2. Heroku Postgres is the SQL database service run by Heroku that is provisioned and managed as an add-on.

  3. Heroku Postgres is accessible from any language with a PostgreSQL driver including all languages and frameworks supported by Heroku: Java, Ruby, Python, Scala, Play, Node.js and Clojure.

For more you can refer this http://www.postgresql.org/about/advantages/.

Upvotes: 2

Related Questions