Showdown : #mysql 8 vs PostgreSQL 10
▻https://hackernoon.com/showdown-mysql-8-vs-postgresql-10-3fe23be5c19e?source=rss----3a8144eabfe
Photo by David MarcuNow that MySQL 8 and PostgreSQL 10 are out, it’s a good time to revisit how the two major open source relational databases compete against each other.Before these versions, the general perception has been that while #postgres is superior in feature sets and its pedigree, MySQL is more battle tested at scale with massive concurrent reads /writes.But with the latest releases, the gap between the two has gotten significantly narrowed.Feature ComparisonLet’s take a look at the “trendy” features that we all love to talk about.It used to be easy to say that MySQL works best for online transactions, and PostgreSQL works best for analytical processes. But not anymore.Common Table Expressions (CTEs) and window functions have been the main reason to choose PostgreSQL. But now, (...)