Vectors

Explore vector data types. This section details how to store and manage numerical arrays, enabling efficient vector similarity search and machine learning applications within your database.

Vector Overview

Official MariaDB Vector reference: VECTOR(n) data type, VECTOR INDEX (M, DISTANCE=euclidean|cosine), VEC_FromText() inserts, VEC_DISTANCE() queries.

CREATE TABLE with Vectors

Create tables optimized for vector storage. Learn to define columns with the VECTOR data type and configure vector indexes for similarity search.

Vector System Variables

System variables that control MariaDB's vector storage and similarity-search features.

Vector Framework Integrations

MariaDB Vector integrations with popular AI and application frameworks.

Vector Functions

Explore vector functions. This section details SQL functions for manipulating and querying vector data types, enabling efficient similarity search and AI/ML applications within your database.

VECTOR

The VECTOR data type, available from MariaDB 11.7.1, for storing fixed- length numeric arrays used in vector search.

Optimizing Hybrid Search Query with Reciprocal Rank Fusion (RRF)

Combine full-text (keyword) and vector search using Reciprocal Rank Fusion (RRF) for higher-quality hybrid search results.