Upserting Vectors

Every database needs data, and your vector database is no exception.

Our SDK makes it easy to insert or update (upsert) vector data in your indexes and/or namespaces.

​

Upsert

With Upstash Vector, you can upsert one or more vectors. For now, let’s focus on upserting a single vector.

We’ll use the upsert() method to instruct the SDK to upsert vectors into an index, as shown below:

You can also enhance your index by adding metadata, enabling more efficient filtering in the future.

You can read more about Metadata, Data and Metadata Filtering on our docs.

​

Upsert Many

Building on the previous section, Upstash Vector also supports upserting multiple vectors at once.

To do this, we’ll use the upsertMany() method, which allows you to efficiently insert or update multiple vectors into an index, as shown below:

Upserting multiple records simultaneously improves performance by allowing you to batch your upserts efficiently.

​

Update

When you upsert data you are basicly overriding the data that is already in the index. If you want to update the data you can use the update method.

The update method is similar to the upsert method, but it will only update the data that is already in the index.

​

Sparse Indexes

If you are using a sparse index, you’ll need to modify your upsert call accordingly.

Sparse indexes require a set of indices and their corresponding values, which can be upserted as demonstrated below:

You can read more about Sparse Indexes on our docs.

​

Hybrid Indexes

If you are using a hybrid index, you need to provide both sparse vectors and dense vectors.

You can read more about Hybrid Indexes on our docs.