Why Uber Engineering Switched from Postgres to MySQL (2016)

#1

Post by syspec » Sat, Feb 27, 2021, 7:34 AM UTC

Why Uber Engineering Switched from Postgres to MySQL (2016)
eng.uber.com

Re: Why Uber Engineering Switched from Postgres to MySQL (2016)

#2

Post by chovybizzass » Sat, Feb 27, 2021, 7:37 AM UTC

because its simpler? i found postgres to be overly complicated compared to MySQL/Maria

Re: Why Uber Engineering Switched from Postgres to MySQL (2016)

#3

Post by DaiPlusPlus » Sat, Feb 27, 2021, 10:24 AM UTC

chovybizzass wrote: post #2

because its simpler? i found postgres to be overly complicated compared to MySQL/Maria

Define: "complicated"

Re: Why Uber Engineering Switched from Postgres to MySQL (2016)

#4

Post by sschueller » Sat, Feb 27, 2021, 10:53 AM UTC

DaiPlusPlus wrote: post #3

chovybizzass wrote: post #2

because its simpler? i found postgres to be overly complicated compared to MySQL/Maria

Define: "complicated"

Recovering a split brain Galera cluster. Fun times...

Re: Why Uber Engineering Switched from Postgres to MySQL (2016)

#5

Post by ignoramous » Sat, Feb 27, 2021, 10:59 AM UTC

Previous discussions:

2016: https://news.ycombinator.com/item?id=12166585

2018: https://news.ycombinator.com/item?id=17280239

Community responses:

- https://news.ycombinator.com/item?id=12216680

- https://news.ycombinator.com/item?id=12179222

Re: Why Uber Engineering Switched from Postgres to MySQL (2016)

#6

Post by burnthrow » Sat, Feb 27, 2021, 11:00 AM UTC

2016

Re: Why Uber Engineering Switched from Postgres to MySQL (2016)

#7

Post by eznzt » Sat, Feb 27, 2021, 11:03 AM UTC

DaiPlusPlus wrote: post #3

chovybizzass wrote: post #2

because its simpler? i found postgres to be overly complicated compared to MySQL/Maria

Define: "complicated"

Just creating a new user is annoying enough.

Permissions are also much more complex.

What the hell are schemas?

Re: Why Uber Engineering Switched from Postgres to MySQL (2016)

#8

Post by corty » Sat, Feb 27, 2021, 11:05 AM UTC

DaiPlusPlus wrote: post #3

chovybizzass wrote: post #2

because its simpler? i found postgres to be overly complicated compared to MySQL/Maria

Define: "complicated"

PostgreSQL: "your date 2020-02-31 isn't a date, fix that"

MySQL: "2020-02-31? Whatever man, I'll just enter something..."

Re: Why Uber Engineering Switched from Postgres to MySQL (2016)

#9

Post by consp » Sat, Feb 27, 2021, 11:18 AM UTC

corty wrote: post #8

DaiPlusPlus wrote: post #3

Earlier quoted context omitted.

Define: "complicated"

PostgreSQL: "your date 2020-02-31 isn't a date, fix that" MySQL: "2020-02-31? Whatever man, I'll just enter something..."

Considering the US uses a weird date format, I definitely prefer the former in combination with input sanitation forcing you to thing about your actions before assuming the database will fix it for you.

Re: Why Uber Engineering Switched from Postgres to MySQL (2016)

#10

Post by frankietaylr » Sat, Feb 27, 2021, 11:21 AM UTC

Has Postgres architecture changed since Postgres 9.2 in terms of the inefficiencies mentioned in the article?