Restricting Overlapping Time Periods in MySQL
I previously wrote about avoiding overlapping time periods in Postgres here: https://www.avaitla16.com/application-time-periods-in-postgres
Postgres' tsmultirange types make restriction and update quite clean. MySQL doesn't have btree_gist constraint...
nocd.hashnode.dev2 min read