Make requests case insensitive

[jaaneh]

For example, making a request to get a profile with the name Jan will not return the profile of an existing user with name jan. Seeing as emails and usernames are unique, we should make these case insensitive.

[jaaneh]

This may be a tad harder than initially thought. While Prisma with PostgreSQL does support case insensitive queries, they have to be enabled on a per-query basis.

await prisma.users.findFirst({
  where: {
    equals: name,
    mode: "insensitive"
  }
})

It does not look like the findUnique() method supports this, as the where query it expects can only be one of the properties of the model and can't include any other inputs or filters.

To properly support this we'll need to switch all of our instances of findUnique() to findFirst() but not sure if there are other caveats to this. Could we for example get a return value we didn't expect with findFirst()?

PostgreSQL requires this to be set per field you query for.

[jaaneh]

@Fermain Any thoughts on this? I can't really find any downsides to switching to findFirst, as long as we use equals and not something like contains where it may return incorrect result. I may be missing something though.

[Fermain]

I'm not sure about the use case. If you're searching for a username shouldn't you be precise?

[jaaneh]

I'm not sure about the use case. If you're searching for a username shouldn't you be precise?

Sure, but shouldn't also jAn return the profile for jan when the username is unique?

[jaaneh]

Or when logging in, and trying your email with a capital letter at the start

[Fermain]

If they are unique case insensitive, then yeah, the API should be insensitive too. Email is always insensitive so that makes sense.