Ask HN: How long before databases get vector similarity search in them?

4 pointssharemywin2 comments

I know sqlite has it and you can always use a specialized service. But why not directly in mysql or other databases?

https://github.com/asg017/sqlite-vss

It's a different paradigm. I wouldn't expect the relational databases to start competing with the proper vector databases, as vectors do not fit SQL tables. Each problem should be solved with a specialized tool to achieve the best performance possible. We might be seeing some new plugins to relational DBs, but in reality, vector search comes with a bunch of other issues we need to solve. For example, memory usage. Here is how we made it at Qdrant: https://qdrant.tech/articles/scalar-quantization/

You can also read answer from this thread https://news.ycombinator.com/item?id=35495343

Reply on news.ycombinator.com