VectorDB in gigalixir

So I have been stuck for a alot of time tryi g to figure out how to get a vector db for parge vectors that can do KNN. Its suprisingly complicated to make something like ecto do it.

The reason i am asking specifcly here is that i sont really know how i would go about installing packages with ecto or if thats even a good idea.

Ideally i want somerhing like pgvector which is just made for this sort of quries but i dont mind writing it in pure sql of it can work.

If you are using Gigalixir’s STANDARD tier database, you can enable the pgvector extension.

gigalixir pg:psql

postgres=> CREATE EXTENSION IF NOT EXISTS vector;
1 Like