Menu
I'm busy porting some MySQL specific code to Postgresql in order to use it with Heroku. Just wondering if there is any specific reason why Heroku went with Postgresql over MySQL? Performance, architecture, etc?
UPDATE: From a heroku blog post:
At Heroku, we believe PostgreSQL offers the best mix of powerful features, data integrity, speed, standards compliance, and open-source code of any SQL database on the planet.
919
Heroku offers a free plan for hosting PostgreSQL databases. This can be handy if you're getting started with a new project or "just quickly need a hosted database" for experimentation or prototyping.
PostgreSQL is the most professional of the relational Open Source databases and was awarded “Database System Of The Year” several times. It is a highly reliable, stable, scalable and secure system, and has been around for more than two decades now.
All databases managed by Heroku Postgres provide continuous protection by persisting snapshots, base backups and WAL files to S3. Also, fork and follower databases are implemented by fetching snapshots or persistent base backups and WAL files and replaying them on a fresh Postgres installation.
Heroku delivers the core open-source data projects that are widely adopted by developers— PostgreSQL, Redis, and Apache Kafka. Heroku data services are fully-configured, optimized, secure, and ready for production apps.
Postgres is better than mysql in many ways. You can read these posts about migration rails app from mysql to postgres. Though mysql is more popular than postgres, but instagram is using postgres maybe due to these reasons. I feel postgres is much more mature and robust than mysql. Whereas mysql is more easy and simple to use.
Migrating MySQL to PostgreSQL in Rails « m i n d l e v
Converting Rails application data from MySQL to PostgreSQL
For data migration, a handy little script: Rake task to transfer a Rails database, say from MySQL to Postgres and back again
175
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
