Re:Pgvector – vector similarity search for Postgres
by patelajay285 on Thursday April 22, 2021 @03:05PM
(#26906785)
Our startup made a package powered by SQLite for this very purpose: https://github.com/plasticityai/magnitude
Might be worth checking out :)
Re:Pgvector – vector similarity search for Postgres
by ipsum2 on Thursday April 22, 2021 @10:36PM
(#26910449)
I'm not sure how this is relevant - the difficult part is doing the retrieval based off of similarity matching in an efficient way. Calling the cdist function to compare all vectors would be very slow.
Minimal working example of storing numpy vectors in sqlite3 using Python: