ruby on rails - Which database should be chosen in Heroku? -
i want migrate database heroku. old database exported json files, don't know how select database in heroku.
my issue is:
- the data increasing, in future, there lot of data. database available this?
- i can json files old database. can imported heroku database?
- my users in america. database in heroku whether lead user's access speed or not?
- my project using ruby on rails.
what should do?
first of all, heroku provides postgresql default database. might following reasons use it.
- postgresql powerful, open source object-relational database system. 
- heroku postgres sql database service run heroku provisioned , managed - add-on.
- heroku postgres accessible language postgresql driver including languages , frameworks supported heroku: java, ruby, python, scala, play, node.js , clojure. 
for more can refer http://www.postgresql.org/about/advantages/.