Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
1–10 of 27 posts
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#2I 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?
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#3Great 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)
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#4I 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.
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#5I 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?
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?
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#6I 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?
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.
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#7The rewritten title is confusing imo. Can I propose:
“Finding ‘Abbey Road’ given ‘beatles abbey rd’ search with Postgres”
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#8these days i find myself yearning to type "Beatles abbey rd" and find only "Beatles abbey rd"
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#9The rewritten title is confusing imo. Can I propose: “Finding ‘Abbey Road’ given ‘beatles abbey rd’ search with Postgres”
(The missing close-apostrophe, and the use of “type” are what really confuse me in the original submission)
Re: Find 'Abbey Road when type 'Beatles abbey rd': Fuzzy/Semantic search in Postgres
#10these days i find myself yearning to type "Beatles abbey rd" and find only "Beatles abbey rd"
Especially with small datasets it’s more important to be exact at the expense of a user having to fix a typo.