3 ms·

Since I started programming, I have always used MySQL because honestly I think it is the best DB I have used because it has great software support and usability

Since I started programming, I have always used MySQL because honestly I think it is the best DB I have used because it has great software support and usability. I have tried Postgres and while I have no issues with it, I usually go with MySQL if I have a choice because I see no real reason to switch out something I know and like. Is there any real reason for a person like me to use postgres or another alternative instead of MySQL?

BozeWolf 8y ago
Many reasons, full text indexing is a good one for example. Although mysql claims to have support for it, it is not as far as postgres is (with tsvector). It has many more extensions. It depends on what frameworks you use, but django is mostly optimized for postgres. The MySQL ecosystem is a bit weird due to having multiple "mysql"-ish versions. I did a small project where mariadb and mysql where not interchangeable. Some stuff was causing problems, cannot remember exactly anymore. Edit: EXPLAIN ANALYZE in postgres I love it.