Uniqueness validations are fundamentally different from other types of validation. They require a database connection, which makes them susceptible to race conditions.

Read the article to learn how to use Ecto’s unsafe_validate_unique in combination with unique_constraint to ensure that no invalid data gets past your changesets.

https://phoenixonrails.com/blog/foolproof-uniqueness-validations-in-phoenix-with-ecto