News for hackers. Stuff that matters.

A comment on MariaDB ditches products and staff in restructure. Parent comment

Re:MariaDB ditches products and staff in restructure by bombcar on Sunday October 15, 2023 @01:45PM (#37891763)
This is the root of it all - for years and years MySQL was perfectly capable of doing the needful, but it shipped with default configurations that would do things like use "not_quite_really_UTF8" and "myisam_tables_please_no_acid".

If you knew enough to switch to innodb and "mysql_real_utf8_string" or whatever it was, you had a quite performant and stable system.

[ Parent | on HN ]
Re:MariaDB ditches products and staff in restructure by justinclift on Sunday October 15, 2023 @02:11PM (#37891957)
There have also been numerous horror stories where people discovered (after the fact) that MySQL wasn't storing their data as given, but instead internally silently converting it to some other format/type and storing that.

People that directly experienced this very thing will probably chime in to give examples (etc). :)

[ Parent | on HN ]
Re:MariaDB ditches products and staff in restructure by jarym on Sunday October 15, 2023 @02:36PM (#37892162)
Yep - ME! Happened to ME! Now some will blame bad development, should have caught it in the application code via testing, etc.

A 'true' DBMS will provide some guarantees and rather fail a transaction than do a 'best endeavours' job with it.

[ Parent | on HN ]
Re:MariaDB ditches products and staff in restructure by anonacct37 on Sunday October 15, 2023 @06:47PM (#37894110)
You hit the nail on the head, those were my top two complaints, but the rabbit hole goes deep.

It's not an exaggeration to say that trying to keep mysql from corrupting your data feels like a full-time job. Mysql in many ways, especially as used by massive social media companies early on was closer to a SQLish DSL for a non-transactional kv store than a "real" ACID database.

That's why "but it can do 70k rps" is just noise to someone. I don't care how fast it can lose my data.

I'm all for people needing to read the docs but man a database burns trust pretty fast when it's so easy to have it pretend to support transactions or pretend to support utf8.

[ Parent | on HN ]