3 ms·
a binary comarison of features does not properly compare the technologies. the implementation makes a large difference in the quality of the software and it's
by dijit 12y ago
a binary comarison of features does not properly compare the technologies.
the implementation makes a large difference in the quality of the software and it's use.. objectively you could compare a ferarri and a honda this way and they would look comparatively similar.
postgresql isn't as feature complete as oracle.. but comparing it to mysql now is almost a moot point.
if it's not going to kill your company- or you're making something new from scratch- you're really doing yourself a disservice by not using postgresql.
there's more than a few reasons for this but a few that come to mind is:
* Sane Connector libraries (especially in C++ where mysql is inconsistent, lock prone and buggy)
* SQL standards compliance, not my pgsqlisms (there are, but they have namespaces which are obvious)
* MySQL has a habit of being massively inconsistent or not running in an expected way (input validation is very lacking, along with things like, changing column widths which irrevocably alters data)[0]
I mean, personally I'd rather not have a relational database which eats my data.
[0] - https://www.youtube.com/watch?v=emgJtr9tIME https://www.youtube.com/watch?v=emgJtr9tIME