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.