Case insensitive emails and usernames with Postgres

11 minute read

TLDR: Use case insensitive text (citext) in Postgres, and don’t worry about email/usernames in application code.