3 ms·
I've only used MySQL in jobs, but for a personal project I recently changed from MySQL to Postgres just as a learning exercise and because everyone has such gre
by bratsche 14y ago
I've only used MySQL in jobs, but for a personal project I recently changed from MySQL to Postgres just as a learning exercise and because everyone has such great things to say about it. I'm very excited about learning more.
- jmspring 14y agoI've often used both for different projects, depending on the wrappers provided. Most of the PHP CMS world was all about MySQL first and foremost, which isn't a bad thing. But, if you ran into a MySQL limitation, you were pretty much stuck with trying to work around it -- see some of the notes about WP. Moving to an ORM layer or a level (or two) up from direct DB calls can result in more generic SQL and potentially a performance impact.
- jacques_chester 14y agoMy view is that these days, DBMS vendor lockin just isn't a problem if you're using an open source database. So you might as well take full advantage of the features that are available.