pentacent / keila

Open Source Newsletter Tool.
https://keila.io
GNU Affero General Public License v3.0
1.33k stars 69 forks source link

Migrate email fields (for users and contacts) to CITEXT #127

Closed wmnnd closed 1 year ago

wmnnd commented 2 years ago

Email fields for users and contacts should be migrated from :string to :citext.

Citext is a case-insensitive text field which helps avoid issues with users typing their email addresses with different capitalizations but still retains them as they’ve inputted them.

Technically, this might be against the SMTP specs but practically, email addresses are never case-sensitive.

wmnnd commented 1 year ago

Implemented in #143.