News for hackers. Stuff that matters.

chathero

Re:Comparison of Vector Databases on Friday January 05, 2024 @05:18AM (#38877506)
be clear at a glance
Yes, MyScale can definitely help with that. Our platform supports storing multiple vector indexes, allowing you to store and perform vector searches on various types of embeddings. You can check out our documentation website for more information.
Thanks for asking!MyScale's advanced vector indexes, such as HNSW/HNSWSQ, are designed to provide much faster and more efficient search capabilities for large-scale vector data. Additionally, MyScale's proprietary algorithms further enhance the search capabilities of our vector indexes, allowing for more accurate and relevant search results.

In comparison, pgvector's plugin for Postgres is a valuable tool for adding vector support to Postgres, but it does not offer the same level of performance and advanced features as MyScale. Furthermore, MyScale's storage-optimized instances and distributed support for large-scale vector data provide additional benefits that are not available with pgvector. With MyScale, users can focus on their applications and data, while leaving the management and scaling of their vector database to us.

Show HN: Langchain's new member-A SQL+Vector database built on ClickHouse

https://myscale.com/

MyScale is designed for the storage and analysis of massive vector data with structured metadata. If you are eager to find a high-performance vector search using SQL queries, MyScale could be your preferred option. Thanks to the advantages of native structural database support, it provides you with a flexible filter with a WHERE clause, even JOIN when you want to jointly search vectors with...

( Read More... | 4 comments | 3 points | on HN )
Re:Run Vector Search with SQL on Monday April 24, 2023 @05:02PM (#35693250)
Hey HN! As SQL developers working with vector embeddings, we found ourselves facing limitations with existing solutions like PostgreSQL's pgvector extension and Clickhouse's annoy extension. We experienced restrictions in supported indexing types and struggled with performance when dealing with large-scale data. That's why we started integrating more indexing libraries in Clickhouse, which gradually grew into our current product, MyScale.

MyScale is a Clickhouse-based vector database that fuses vector search and SQL analytics to deliver a streamlined, fully managed, and high-performance experience. It's designed to help you perform joint queries and analyses on both structured and vector data, with complete SQL support for all data processing. Plus, MyScale offers a wider range of vector indexing types, such as IVF and HNSW, to enable more efficient search.

MyScale is now open for registration and offers a free tier plan capable of supporting millions of vectors! We'd love you to check it out and give us your feedback.

Hey everyone,

Looking for a high-performance database that lets you use SQL to perform joint queries on both structured and unstructured data? Look no further than MyScale!

With MyScale, you can manage both structured and unstructured (vectorized) data, and perform joint queries and analytics on both types of data using SQL. Plus, MyScale's cloud-native OLAP architecture, built on top of ClickHouse, enables lightning-fast data processing even on massive datasets.

We're excited to announce that MyScale is now in beta, and we'd love to get some early feedback from the community! If you're ready to revolutionize your applications with lightning-fast results and flexible querying, check out MyScale at https://myscale.com.