At 22 years old, Postgres might just be the most advanced database yet

Re:At 22 years old, Postgres might just be the most advanced... by siquick on Wednesday December 05, 2018 @02:43PM (#18611737)

Started using PG recently at a new job but can't really see any benefit over MySQL. What am I missing?

[ Parent | on HN ]

Re:At 22 years old, Postgres might just be the most advanced... by mooreds on Wednesday December 05, 2018 @08:48PM (#18614689)

The big one I am aware of is transactional ddl, which I believe got integrated into MySQL 8.

[ Parent | on HN ]

Re:At 22 years old, Postgres might just be the most advanced... by gaius on Wednesday December 05, 2018 @04:37PM (#18612851)

If you lose the root password, you can fix it in Postgres without taking the database down.

[ Parent | on HN ]

Re:At 22 years old, Postgres might just be the most advanced... by captainperl on Wednesday December 05, 2018 @10:17PM (#18615067)

There are several ways to update the root password in MySQL with zero down-time, either by manipulating the user table, using replication, or using other accounts (ie. most people grant excessive privileges to role accounts.)

https://www.percona.com/blog/2014/12/10/reset-mysql-root-pas...

[ Parent | on HN ]

Re:At 22 years old, Postgres might just be the most advanced... by guiriduro on Thursday December 06, 2018 @03:11AM (#18616253)

Data :)

[ Parent | on HN ]