Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEATURE] More powerful user search #32

Open
JakubKoralewski opened this issue Jan 15, 2021 · 0 comments
Open

[FEATURE] More powerful user search #32

JakubKoralewski opened this issue Jan 15, 2021 · 0 comments
Labels
enhancement New feature or request

Comments

@JakubKoralewski
Copy link
Owner

Currently user search is done solely on an insensitive Prisma contains query (I think this uses LIKE under the hood):

const users = await prisma.user.findMany({
where: {
name: { contains: query, mode: 'insensitive' },
AND: { id: { not: { equals: session.user['id'] } } }
},

We could investigate using:

  • a search engine
    • elastic search
    • tantivy
  • Postgres Full Text Search
  • RediSearch

All of these may be impossible using Heroku's free tier's limits.

@JakubKoralewski JakubKoralewski added the enhancement New feature or request label Jan 15, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant