pgvector vs Pinecone
Which Vector DB in 2026?

SQLAlchemy (Python)

from pgvector.sqlalchemy import Vector
from sqlalchemy import Column, Integer, Text
from sqlalchemy.orm import DeclarativeBase

class Item(Base):
    __tablename__ = "items"
    id = Column(Integer, primary_key=True)
    content = Column(Text)
    embedding = Column(Vector(1536))  # match your embedding dim

# Query nearest neighbors:
results = session.query(Item)
    .order_by(Item.embedding.cosine_distance(query_vec))
    .limit(5).all()

Drizzle ORM (TypeScript / Supabase)

import { pgTable, serial, text, vector } from "drizzle-orm/pg-core";

export const items = pgTable("items", {
  id: serial("id").primaryKey(),
  content: text("content"),
  embedding: vector("embedding", { dimensions: 1536 }),
});

// Query:
const results = await db.execute(sql`
  SELECT *, embedding <=> ${queryVec}::vector AS distance
  FROM items ORDER BY distance LIMIT 5
`);