Blog Post: Guide how to make Hybrid search with Elixir and PostgreSQL

Learning Resources Blogs & Podcasts
, , ,
1

Hi,
I wrote longer article about multiple approaches for search in PostgreSQL and Ecto/Elixir. There are example in SQL and also in Ecto syntax.
I tried to describe main possible options for full text search, Semantic search with OpenAI Embeddings and later combinations of those approaches. Also I mentioned some hints, tricks and a lot of links to some interesting readings. To give readers also another options than PostgreSQL I mentioned some other services/systems which can be used.

Search is not magic with PostgreSQL

https://blog.ideax.sk/search-is-not-magic-with-postgresql-613069cb2f21

13 Likes
2

Amazing article, especially the part about semantic search!

1 Like
3

Thank you. There are a lot of details that should be added exactly to this part. Like the description of distance calculations(cosine distance, inner product,…), which one is good for specific usecases, why choosing a good model is very important, etc… But my main motivation was to help people get started with Semantic Search and show them that it’s not an incredibly hard task to make it work for your project.