[dijit]

If it costs development time because they need to be extra careful about not sending queries that ERROR and 'wipe' data.

If it silently corrupts data over years and gets discovered much later. (As was the case with my previous company, an e-commerce retailer that lost large chunks of order history)

[otterley]

Are those problems still unresolved in MySQL today? How do you know that similar or worse problems did not exist in alternative solutions at the time it was implemented?

[dijit]

MySQL is making strides to fix these kinds of issues ever since the Oracle acquisition for sure.

> How do you know that similar or worse problems did not exist in alternative solutions at the time it was implemented?

Because I've been working on database solutions for over 10 years, there are problems in other software but I consider data loss to be worse than any of them. For example the autovacuum in postgresql 8.3 and before was mostly garbage which ended up bloating highly transactional databases. But deleting data when you fail a constraint is worse.