Build a vector database with one click

-- Create a table with a vector column
CREATE TABLE books (id SERIAL PRIMARY KEY, book_embedding REAL[3]);

-- Insert some vectors
INSERT INTO books (book_embedding) VALUES ('{0,1,0}'), ('{3,2,4}');

-- Create an index for faster queries
CREATE INDEX book_index ON books USING lantern_hnsw(book_embedding dist_l2sq_ops)
  WITH (M=2, ef_construction=10, ef=4, dim=3);

-- Query the nearest vector
SELECT id FROM books ORDER BY book_embedding <-> '{0,0,0}' LIMIT 1;

-- Query the nearest vector to a text embedding
SELECT id FROM books ORDER BY book_embedding <-> text_embedding('BAAI/bge-base-en', 'My text input') LIMIT 1;