Building semantic search with pgvector: embeddings inside your existing Postgres
You don't need a dedicated vector database for semantic search. pgvector turns Postgres into a vector store — here's the production setup,…
Appesto
Tag: postgres
Postgres connection pooling in serverless: why it breaks and how to fix it
Each serverless invocation opens a new DB connection. At scale, this exhausts Postgres in seconds. PgBouncer, Neon's pooler, and the Neon serverless…
Drizzle vs Prisma in 2026: which TypeScript ORM should you reach for?
Drizzle overtook Prisma in npm downloads for new projects. Prisma 7 fixed the edge cold start problem. Here's an honest decision guide…
Postgres indexing in practice: B-tree, GIN, BRIN, and when each one wins
Most slow queries aren't missing an index — they're using the wrong kind. A working tour of Postgres index types, partial and…
Postgres RLS without the foot-guns
Row-level security is the cheapest authorization layer you'll ever ship - if you avoid the four mistakes that quietly leak data.