4 ms·
There's Postgres with pgvector extension.
by romanhn 2y ago
There's Postgres with pgvector extension.
- dghlsakjg 2y agoThis would be my vote. There are probably more performant options, but for universality, you are best off going with a popular SQL DB that has vector extensions or support. SQLLite is another option if you want even more portability.
- muzani 2y agopgvector is very performant for tiny scale, especially if they don't expect to update the knowledge base constantly and don't care about millisecond differences in speed. It's also probably the only major vector db with ACID. And it's substantially cheaper than many others. I haven't looked into SQLite and such, but many of the other SQL type of options were not good last I checked. And it takes quite a bit of effort to dig through them because all of these will show research that puts themselves as the best lol.
- redskyluan 2y agoHow is pg performed on windows? Never tried before
- tmaly 2y agoI have used pg years ago on windows when it was like version 7, so I suspect it still works well.
- bilater 2y agoyup keep it simple. hybrid search on supabase with keyword + pg vector. use a good embedding model with inner product (not cosine so its faster). there was a good article about learnings in this space recently here https://news.ycombinator.com/item?id=43299659 https://news.ycombinator.com/item?id=43299659
- saturn_vk 2y agoDo you have recommendations for embedding models?