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.
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
Your AI agent writes migrations that look safe. Here's what they actually do to Postgres.

Your AI agent writes migrations that look safe. Here's what they actually do to Postgres.

Comments 2
5 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
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 2
8 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 3
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
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 1
6 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
Postgres RLS in Symfony: three green isolation tests, and the UPDATE that moves tenant 1's invoices into tenant 2's books

Postgres RLS in Symfony: three green isolation tests, and the UPDATE that moves tenant 1's invoices into tenant 2's books

1
Comments
6 min read
Database: SQLite Backup and Restore

Database: SQLite Backup and Restore

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