DEV Community

#postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Hybrid Search for AI Retrieval in Node: When Keywords Beat Embeddings

Hybrid Search for AI Retrieval in Node: When Keywords Beat Embeddings

Comments
5 min read
Multi-Tenant RAG in TypeScript: Keeping One Customer's AI Out of Another's Data

Multi-Tenant RAG in TypeScript: Keeping One Customer's AI Out of Another's Data

1
Comments 1
5 min read
I just published Postgres MCP Server in Go!

I just published Postgres MCP Server in Go!

Comments
2 min read
You Probably Don't Need Kafka: A Durable Outbox and Job Queue in Plain Postgres

You Probably Don't Need Kafka: A Durable Outbox and Job Queue in Plain Postgres

Comments
8 min read
pgvector from Node.js: Indexes, Pools, and the Query That Times Out

pgvector from Node.js: Indexes, Pools, and the Query That Times Out

Comments
6 min read
Your Database MCP Is Lying to You

Your Database MCP Is Lying to You

2
Comments 3
6 min read
Community Docker Images: keeping the operator open without a vendor registry lock-in

Community Docker Images: keeping the operator open without a vendor registry lock-in

Comments
9 min read
Avoid a Never-Ending SQL UPDATE with Chunking

Avoid a Never-Ending SQL UPDATE with Chunking

1
Comments 2
12 min read
Vector Search in Postgres: What pgvector's Indexes Actually Cost You

Vector Search in Postgres: What pgvector's Indexes Actually Cost You

1
Comments
8 min read
Your Postgres already knows why it's slow — you just have to ask it

Your Postgres already knows why it's slow — you just have to ask it

Comments
7 min read
Your Supabase notifications table has RLS on. Anyone signed in can still write into someone else's inbox.

Your Supabase notifications table has RLS on. Anyone signed in can still write into someone else's inbox.

Comments 7
4 min read
Ditch Polymorphism: Scaling Laravel with JSONB

Ditch Polymorphism: Scaling Laravel with JSONB

Comments
2 min read
Should You Migrate Off pgvector? Run This Shadow-Mode Benchmark First

Should You Migrate Off pgvector? Run This Shadow-Mode Benchmark First

Comments
6 min read
PostgreSQL vs MongoDB vs Cassandra: Multi-Node and How to Choose

PostgreSQL vs MongoDB vs Cassandra: Multi-Node and How to Choose

Comments
17 min read
Eighty Percent Done Is Not a Real Number

Summer Bug Smash: Smash Stories Submission 🐛🛹

Eighty Percent Done Is Not a Real Number

27
Comments 21
10 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.