News for hackers. Stuff that matters.

A comment on The Part of PostgreSQL We Hate the Most (Multi-Version Concurrency Control). Parent comment

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 ;)

[ Parent | on HN ]
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.
[ Parent | on HN ]
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
[ Parent | on HN ]
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.
[ Parent | on HN ]
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)
[ Parent | on HN ]
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

[ Parent | on HN ]
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> #

[ Parent | on HN ]