News for hackers. Stuff that matters.
Re:The Part of PostgreSQL We Hate the Most (Multi-Version Co... by hodgesrm on Wednesday April 26, 2023 @07:38PM (#35721399)
> A non-trivial component to MySQL popularity was that easy installation

...Along with replication and being joined with the hip to PHP. As to installation, there was a point in time in the early 2000s where you could sudo to root, type 'mysql' and be talking to a live MySQL on most Linux distros that I used. No wonder a lot of people defaulted to it.

Re:The Part of PostgreSQL We Hate the Most (Multi-Version Co... by p_l on Wednesday April 26, 2023 @08:05PM (#35721597)
Replication came later - but the fact that you could do

  sudo apt-get install mysql-server mysql-client
  sudo -i mysql
and be logged in as admin into mysql database was indeed a huge reason for defaulting to it.

EDIT: Of course, at that time, there was no Ubuntu teaching everyone to sudo all the time, so drop all instances of sudo and add a su - at start ;)

Re:The Part of PostgreSQL We Hate the Most (Multi-Version Co... by tomnipotent on Wednesday April 26, 2023 @09:09PM (#35722012)
MySQL has had replication since May 2000.
Re:The Part of PostgreSQL We Hate the Most (Multi-Version Co... by p_l on Wednesday April 26, 2023 @09:31PM (#35722162)
Replication being easier as driver for developers defaulting to MySQL
Re:The Part of PostgreSQL We Hate the Most (Multi-Version Co... by masklinn on Thursday April 27, 2023 @01:41AM (#35723732)
Mysql also came with pretty much any webhost.
Re:The Part of PostgreSQL We Hate the Most (Multi-Version Co... by p_l on Thursday April 27, 2023 @05:53AM (#35725676)
That's exactly my point. A lot of people started with dynamic websites by using cheap webhosting that you FTP'ed your PHP files to, and used PhpMyAdmin to manage your smallish database, and 2000-2009 they still formed a strong portion of market for starting out (I chose 2009 because that's when EC2 becomes more accessible for this due to RDS)
Re:The Part of PostgreSQL We Hate the Most (Multi-Version Co... by porker on Thursday April 27, 2023 @02:13AM (#35723925)
> Of course, at that time, there was no Ubuntu teaching everyone to sudo all the time

Maybe that's why I am used to logging in as root rather than a user. I started in 1999 and have been surprised how few users now do

Re:The Part of PostgreSQL We Hate the Most (Multi-Version Co... by flumpcakes on Thursday April 27, 2023 @03:33AM (#35724511)
Most prod configs I've seen now days disable SSH-ing in as root and password auth so it just becomes:

$ ssh user@server <rsa key> $ sudo -i <user pass> #

Re:The Part of PostgreSQL We Hate the Most (Multi-Version Co... by ExoticPearTree on Thursday April 27, 2023 @12:10PM (#35730262)
Yes, replication. MySQL made it dead easy to have DB clusters in minutes.

I'd wish PostgreSQL would have as simple when it comes to replication and failover like MySQL does. It's always a pain when switching masters back and forth.