Post

Writes and queries work like a normal RDBMS. Store your vector data in a column in your existing database, build an index with an ALTER or CREATE VECTOR INDEX statement, or write SELECT statements with JOIN and WHERE clauses like any other data.

One of the biggest differentiators of PlanetScale vector support is the ability to use indexes larger than RAM. We are the first to incorporate an index based on SPANN (Space-Partitioned Approximate Nearest Neighbors) into an RDBMS.

SPANN is a hybrid index design that combines the best aspects of partition-based and tree-based indexes. In SPANN, vectors are assigned to small partitions, which are stored in hidden InnoDB tables.