Being an analytics/reporting product company, we’ve worked with a fair amount of customers who run Postgres/Redshift for their analytics, and the same fair amount who uses MySQL.
And from our experience with both, I’d prefer our new customers to use Postgres all the time. For reporting/analytics/data-warehouse purpose, Postgres wins over MySQL hands-down.
In this post I lay down a few practical reasons why working with Postgres is so much better than MySQL from a data analyst perspective.
From Raw Data To Insights: Holistics is a cloud-based Business Intelligence & Data Analytics Platform including ETL Data Preparation for growing businesses. Holistics connects to your databases and helps you get the data-driven insights you need.