gwilliamnn
gwilliamnn2y ago

indexSearch with "match"

Hello, I'm trying to make a simple search index, but the db will be large, because is customers db, and we have more than 10.000. I wanna search the user by a name query, example, when user search mari this will match with (maria, mariah, mariana) on documentation, i'm trying to do with the tasks table, and the only match with the exacly word.
7 Replies
Michal Srb
Michal Srb2y ago
Hey @gwilliamnn , this is a current limitation of our Search beta, it only supports exact word match. Totally agree with you that this is limiting/surprising. For now you'll either have to: - Work around this in Convex by adding a table with name prefixes (ma, mar, mari...) that point to a list of customer Ids - then you can search this table for exact match - Plug in external search solution like Elastic search We might be adding the prefix search or a vector search capability in the future. Vector search might or might not serve your needs (since it won't be exact prefix search).
gwilliamnn
gwilliamnnOP2y ago
how make this external soluction?
Omar Farooq
Omar Farooq2y ago
Hello @Michal Srb, just to confirm. If a document had a field with the value "what is a walrus"? Would the query 'walrus' match to this document or will it only match to a field that is exactly as 'walrus'? Thanks!
gwilliamnn
gwilliamnnOP2y ago
Yes.
Michal Srb
Michal Srb2y ago
(@gwilliamnn is correct, search for "walrus" does match "what is a walrus")
Michal Srb
Michal Srb2y ago
@gwilliamnn for an external solution you'd want to look into our the export functionality we support to export your data to an Elastic Search DB and then query it from actions. https://docs.convex.dev/database/import-export/airbyte
Using Convex with Airbyte | Convex Developer Hub
Analyze your Convex data by exporting via Airbyte.
Omar Farooq
Omar Farooq2y ago
Awesome, perfect for my use case. Thanks!

Did you find this page helpful?