Build inwith Postgres

-- Create a table with vector support
CREATE TABLE IF NOT EXISTS articles (
  id SERIAL PRIMARY KEY,
  title TEXT NOT NULL,
  content TEXT NOT NULL,
  embedding VECTOR(384)
);

-- Insert data and generate embeddings
INSERT INTO articles (title, content, embedding)
VALUES (
  'How to use vector search',
  'This article explains how to implement vector search...',
  embedding('text-embedding-ada-002', 'This article explains how to implement vector search...')
);

-- Search by vector similarity
SELECT title, content, 1 - (embedding <=> embedding('text-embedding-ada-002', 'How to search with vectors')) as similarity
FROM articles
ORDER BY similarity DESC
LIMIT 5;