2 ms·
It's been a while since I've given serious thought to this question but I'm glad it's asked because I would like to re-learn and find out if those using it do s
by mikece 4y ago
It's been a while since I've given serious thought to this question but I'm glad it's asked because I would like to re-learn and find out if those using it do so for the reasons I perceive PostgreSQL to be "superior" based on talk among peers. The basic "MySQL is faster but lighter on features" is what I recall hearing; also that PostgreSQL is "multi-paradigm" in that you can run document/NoSQL tables, ETL, and data warehousing all in one product. Then again, maybe MySQL supports JSON tables now as well and I just haven't noticed since my head has been in the AWS cloud and tied to Dynamo for the last three years.
- ericbarrett 4y agoMySQL 8.0 has JSON column support: https://dev.mysql.com/doc/refman/8.0/en/json.html https://dev.mysql.com/doc/refman/8.0/en/json.html
- evanelias 4y agoMySQL 5.7 does too, it's a fairly mature feature at this point :) Meanwhile MariaDB lacks a distinct JSON type, but instead provides a lot of functions for manipulating JSON stored in textual types.
- postdb 4y agoI started with mysql in late 90's, switched to postgre and would prefer that instead of MySQL if it is my decision. MySQL is faster than postgres is a myth. Please see this https://arctype.com/blog/performance-difference-between-postgresql-and-mysql/ https://arctype.com/blog/performance-difference-between-post... One thing mysql is better than postgres is that mysql can fast replicate across different data centers. See this blog: https://www.uber.com/en-DK/blog/postgres-to-mysql-migration/ https://www.uber.com/en-DK/blog/postgres-to-mysql-migration/ However what Uber is doing may not be what you doing. So do some research and hire qualified db admin or devop people to make the informed choice.