3 ms·

> MySQL's silent data truncation is such a nuisance. Yes, yes it is - it burned me so badly (catastrophic, unrecoverable production data loss) in the early day

by eric_h 9y ago

> MySQL's silent data truncation is such a nuisance. Yes, yes it is - it burned me so badly (catastrophic, unrecoverable production data loss) in the early days of my career (~15 years ago as a junior level dev in a senior level role) that it has forever colored my opinion of MySQL - I will really never trust it again. Long live PostgreSQL!

rimliu 9y ago
Long live reading documentation. Otherwise you risk data loss no matter the DB.
- eric_h 9y ago
  At the time silent truncation was an undocumented "feature", IIRC. I think I found a description of the issue buried on some forum somewhere.