Conversation
Notices
-
@usblovedog @saper @uranther in my experience, postgres crashes less, and the results are less devastating if it does crash. I've had a mysql crash make the data unrecoverable. On the other hand I have a production postgres 8.1 installation (don't ask) that has been running without problems for over 10 years.
There is more community information and more third-party tools that require mysql, it has that advantage. the client tools for mysql are easier to use because the commands are in plain english ("show tables")unlike postgres that are commands like "\dt+". but if I'm doing my own thing though, I use postgres.
-
@usblovedog mysql is still a good database in many ways, you should stick with the one you're most comfortable with and maybe experiment with postgres sometime.