search

rasocbo / bublol

0 stars 0 forks source link

Case sensitivity #36

Open rasocbo opened 3 years ago

rasocbo commented 3 years ago

Database is currently case-sensitive - including username. These should be case-insensitive:

rasocbo commented 3 years ago

postgre lowercase restriction https://stackoverflow.com/questions/9046825/postgresql-auto-lowercase-text-while-or-before-inserting-to-a-column

postgre lowercase restriction CREATE UNIQUE INDEX lower http://shuber.io/case-insensitive-unique-constraints-in-postgres/

knex citext https://fdp.io/blog/2017/03/12/using-citext-with-knex-js/