5 ms·
Started using PG recently at a new job but can't really see any benefit over MySQL. What am I missing?
by siquick 8y ago
Started using PG recently at a new job but can't really see any benefit over MySQL. What am I missing?
- gaius 8y agoIf you lose the root password, you can fix it in Postgres without taking the database down.
- captainperl 8y agoThere 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-password-without-restarting-mysql-no-downtime/ https://www.percona.com/blog/2014/12/10/reset-mysql-root-pas...
- mooreds 8y agoThe big one I am aware of is transactional ddl, which I believe got integrated into MySQL 8.
- guiriduro 8y agoData :)