Any modern distribution of MySQL or MariaDB should come configured to throw query errors rather than truncate data on insert. See STRICT_ALL_TABLES / https://m

Any modern distribution of MySQL or MariaDB should come configured to throw query errors rather than truncate data on insert. See STRICT_ALL_TABLES / https://mariadb.com/kb/en/library/sql-mode/ https://mariadb.com/kb/en/library/sql-mode/ Modern MySQL is extremely well suited for data that cannot be lost - as is I'm sure, Postgres. That said, if you're pre 5.6, I _strongly_ suggest upgrading to 5.6 or all the way to MariaDB 10. The performance, safety, stability, etc have skyrocketed in recent years.