4 ms·
> Are you trolling? Both MyIsam and Aria are not ACID compliant. May as well use /dev/null. This is silly. I would say most databases in production in the wor
by phil21 3y ago
> Are you trolling? Both MyIsam and Aria are not ACID compliant. May as well use /dev/null.
This is silly. I would say most databases in production in the world have zero need for ACID compliance.
I know plenty of companies making millions of dollars of revenue per month off their MyISAM table database products. Hard to do that with /dev/null I assume.
It works fine depending on what you are doing. Granted, there are typically better options these days, but this goes back 15+ years of silliness. Many (most?) web apps are write once, read millions.
For high volume/low value data that doesn't need perfect accuracy or consistency you can make MySQL/MariaDB absolutely fly.
That said, I hear PSQL can get close these days turning some knobs as well.
But, the ACID argument is tired and usually made in places where it simply is irrelevant. Most apps simply don't matter if they drop some data here and there, but developers act like they are building critical banking systems for their ad viewing platform. This is probably a top 10 favorite bike shedding topic I've seen in dev meetings over my career. In 90% or better cases you could have chosen literally any RDBMS and been fine, the arguments about it taking more time than the choice made will ever save.