Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
59 points
5 days ago
| 8 comments
| rendiment.io
| HN
fsckboy
2 hours ago
[-]
these days i find myself yearning to type "Beatles abbey rd" and find only "Beatles abbey rd"
reply
storystarling
1 hour ago
[-]
I learned this the hard way on a book platform I'm working on. While semantic search is useful for discovery, we found that prioritizing exact matches is critical. It seems users get pretty frustrated if they type a specific title and get a list of conceptually similar results instead of the actual book. We ended up having to tune the ranking to heavily favor literal string matches over the vector distance to keep people from bouncing.
reply
fsckboy
38 minutes ago
[-]
everything you are saying rings perfectly true to me but there's an additional problem I encounter. (i'm going to make up my example because i'm lazy to check but you'll get the idea) say you want to look up "Alexander the Great"...

...God help you if Brad Pitt and or the Jonas Brothers ever played a role with exactly that name-match. The web and search (and the culture?) have become super biased toward video especially commercial offerings, and the sorting ranked by popularity means pages and pages of virtually identical content about that which you are not interested in.

reply
digiown
25 minutes ago
[-]
Related but I wish Wikipedia would provide a filter against movies, music, pop culture related topics. They take up a huge amount of the namespace for things for whatever reason and often directs me to unintended pages.
reply
cess11
16 minutes ago
[-]
reply
Manfred
2 hours ago
[-]
Especially with small datasets it’s more important to be exact at the expense of a user having to fix a typo.
reply
gingerlime
2 hours ago
[-]
Great post. Explains the concepts just enough that they click without going too deep, shows practical implementation examples, how it fits together. Simple, clear and ultimately useful. (to me at least)
reply
lbrito
2 hours ago
[-]
I was just starting to learn about embeddings for a very similar use on my project. Newbie question: what are pros/cons of using an API like gpt Ada to calculate the embeddings, compared to importing some model on Python and running it locally like in this article?
reply
storystarling
2 hours ago
[-]
The main trade-off I found is the RAM footprint on your backend workers. If you run the model locally, every Celery worker needs to load it into memory, so you end up needing much larger instances just to handle the overhead.

With Ada your workers stay lightweight. For a bootstrapped project, I found it easier to pay the small API cost than to manage the infrastructure complexity of fat worker nodes.

reply
alright2565
2 hours ago
[-]
Do you want it to run on your CPU, or someone else's GPU?

Is the local model's quality sufficient for your use case, or do you need something higher quality?

reply
TeamDman
2 hours ago
[-]
for 50,000 rows I'd much rather just use fzf/nucleo/tv against json files instead of dealing with database schemas. When it comes to dealing with embedding vectors rather than plaintext then it gets slightly more annoying but still feels like such an pain in the ass to go full database when really it could still be a bunch of flat open files.

More of a perspective from just trying to index crap on my own machine vs building a SaaS

reply
pinkmuffinere
2 hours ago
[-]
The rewritten title is confusing imo. Can I propose:

“Finding ‘Abbey Road’ given ‘beatles abbey rd’ search with Postgres”

reply
pinkmuffinere
2 hours ago
[-]
(The missing close-apostrophe, and the use of “type” are what really confuse me in the original submission)
reply
danielfalbo
2 hours ago
[-]
> Abbey Road

> The Dark Side of the Moon

> OK Computer

Those are my 3 personal records ever. I feel so average now...

reply
cess11
2 hours ago
[-]
I found fuzzy search in Manticore to be straightforward and pretty good. Might be a decent alternative if one perceives the ceremony in TFA as a bit much.
reply
esafak
1 hour ago
[-]
tl,dr: A demo of pg_trgm (fuzzy matcher) + pgvector (vector search).
reply