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.
Your stateless service is lying: it's the connection pool

Your stateless service is lying: it's the connection pool

1
Comments 4
4 min read
Why I Chose PDF RAG Chunking and Metadata for Catalog Semantic Search

Why I Chose PDF RAG Chunking and Metadata for Catalog Semantic Search

Comments
6 min read
Eight ways a Lovable + Supabase app leaks its users' data — and how to check yours in ten minutes

Eight ways a Lovable + Supabase app leaks its users' data — and how to check yours in ten minutes

Comments 4
8 min read
Add AI search to existing application

Add AI search to existing application

7
Comments 4
12 min read
Six ways I leaked data through correct RLS policies

Six ways I leaked data through correct RLS policies

Comments
6 min read
Benchmarkée el ORM Postgres nativo de mi lenguaje contra SQLAlchemy: ~8 más rápido en reads, 5.7 menos memoria — y dónde empata

Benchmarkée el ORM Postgres nativo de mi lenguaje contra SQLAlchemy: ~8 más rápido en reads, 5.7 menos memoria — y dónde empata

Comments
6 min read
What a Large-Vehicle Router Cannot Know

What a Large-Vehicle Router Cannot Know

Comments
3 min read
One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17

One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17

Comments 3
6 min read
Your AI SDK chat table breaks every six months

Your AI SDK chat table breaks every six months

1
Comments 5
6 min read
We attacked our own AI-agent governance 69 times. Here are the 5 times it gave way.

We attacked our own AI-agent governance 69 times. Here are the 5 times it gave way.

1
Comments 4
4 min read
The Billion-Row Table: Database Partitioning in Laravel 🗄️

The Billion-Row Table: Database Partitioning in Laravel 🗄️

Comments 1
4 min read
How We Reset Monthly Quotas Without Race Conditions or Cron Drift

How We Reset Monthly Quotas Without Race Conditions or Cron Drift

Comments 1
5 min read
The Order That Got Charged Twice - A Race Condition Post-Mortem

The Order That Got Charged Twice - A Race Condition Post-Mortem

1
Comments 4
5 min read
Deduplicating feature requests with pgvector: the threshold is a trap

Deduplicating feature requests with pgvector: the threshold is a trap

1
Comments 4
5 min read
Postgres Advisory Locks Are Not the Lock You Think

Postgres Advisory Locks Are Not the Lock You Think

Comments 2
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.