Hell, 10 years ago (in a multi database project) I got bit by MySQL not supporting check constraints, but returning successfully when I ran the create check constraint statements.
Postgres has been great all around.
Re:Postgres is eating the database world
by derekperkins on Saturday March 16, 2024 @05:02PM
(#39729439)
It finally supports them, which is nice. It doesn't support deferred checks to the commit, like postgres, but are otherwise good. I've appreciated using it to enforce json schema at the db level
Despite me not knowing much about databases it seemed like an obvious choice.