Why You Should Use Postgres Over MySQL For Analytics Purpose

October 30, 2018

Contributed by Huy Nguyen

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.

Continue reading these reasons here >>

 

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.

 

Share this

Relevant Blogs

pgAdmin User Management in Server Mode

pgAdmin can be deployed as a web application by configuring the app to run in server mode. One can check out server deployment on how to run pgAdmin in...
August 24, 2023

pgAdmin CI/CD

Almost exactly three years ago I wrote a blog on my personal page entitled Testing pgAdmin which went into great detail discussing how we test pgAdmin prior to releases. Back...
August 24, 2023

More Blogs

Highlights from the PostgreSQL 16 Beta Release

The PostgreSQL Global Development Group released PostgreSQL 16 Beta 1 on May 25, 2023. PostgreSQL 16 improves logical replication by enabling replication from standbys as well as the ability to...
June 02, 2023