Exclusion constraints in Postgres can efficiently detect overlapping bookings, appointments, and schedules and block their creation. This blog post explains how to implement them using Ecto.

https://www.peterullrich.com/prevent-overlapping-schedules-with-ecto-and-postgres