Re:We saved millions in SSD costs by upgrading our filesystem
by throwdbaaway on Wednesday November 10, 2021 @04:32AM
(#29172780)
Actually, there was a significant regression. Many many years ago, Oracle decided to drop the support for the gpl-licensed readline altogether, likely because they can't ship it with MySQL Enterprise. To this day, Percona still carries a small patch to add that functionality back, which is great because I wouldn't touch any CLI without readline.
Re:We saved millions in SSD costs by upgrading our filesystem
by JonyEpsilon on Wednesday November 10, 2021 @05:28AM
(#29173152)
Dropping a link to `rlwrap` in case anyone is not familiar with it:
https://github.com/hanslub42/rlwrap
Note that I've never tried it myself with the mysql/mariadb CLI, but I have used it with other tools, and it's brilliant.
Re:We saved millions in SSD costs by upgrading our filesystem
by jamesfinlayson on Wednesday November 10, 2021 @02:14AM
(#29171971)
Yep Postgres seems to have more features too for sure.
Also, a fun little limitation of the MySQL CLI is that it truncates hostnames to 100 characters - not usually a problem, but AWS database VPC hostnames easily hit that limit, and it just silently truncates rather than failing.
Re:We saved millions in SSD costs by upgrading our filesystem
by agent327 on Wednesday November 10, 2021 @06:57AM
(#29173694)
"It silently does something unexpected rather than failing" succinctly summarizes all the reasons you shouldn't be using MySQL.
Re:We saved millions in SSD costs by upgrading our filesystem
by NegativeLatency on Wednesday November 10, 2021 @01:40AM
(#29171790)
I’ve been using a Postgres foreign data wrapper to interact with a MySQL database and it’s much nicer for interactive use.
One tiny example: I prefer to work with databases using CLI interfaces (mysql and psql).
psql CLI is a tool which is pleasant to use, has no bugs in the interface and it even gets improvements from time to time.
mysql CLI is awful to use (e.g. doesn't display long lines properly, has difficulties with history editing, etc) and looks like there wasn't a single improvement since 1996 (I'm sure there were, I just never felt the effect of such improvements).