Hacker News new | ask | show | jobs
by seanharr11 3219 days ago
Just a quick interjection: I wrote a library that migrates between any 2 relational databases. In my case, I migrated off of Oracle and onto MySQL, but the tool supports any RDBMS supported by SQLAlchemy.

https://github.com/seanharr11/etlalchemy

The best way to know is to try! It takes 4 lines of python to get you migrated.

PostgreSQL is a bit more feature rich in my findings, but for the majority of web development there really aren't huge differences. In my experience, MySQL performs a bit better for lots of simple READ queries, while PostgreSQL can handle larger, more complex queries and very frequent WRITEs.