Some of those terrible databases are Redshift, SQLite, Elasticsearch. Redshift does not enforce unique constraint, SQLite does not have datetime. Sure a trigge

Some of those terrible databases are Redshift, SQLite, Elasticsearch. Redshift does not enforce unique constraint, SQLite does not have datetime. Sure a trigger can be used. But they can also be disabled. So you end up verifying all data has been inserted using the trigger anyway.