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.
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
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 3
4 min read
Postgres Advisory Locks Are Not the Lock You Think

Postgres Advisory Locks Are Not the Lock You Think

Comments 1
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

Comments
6 min read
Designing a Privacy-First Architecture for Sensitive Data: Zero-IP Logging, Postgres RLS, and AI Safety

Designing a Privacy-First Architecture for Sensitive Data: Zero-IP Logging, Postgres RLS, and AI Safety

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

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

Comments 1
5 min read
Why the index I added made my query slower

Why the index I added made my query slower

Comments
3 min read
How I Cleaned Messy HR Dataset Using PostgreSQL: A Step-by-Step Guide

How I Cleaned Messy HR Dataset Using PostgreSQL: A Step-by-Step Guide

Comments
9 min read
From MERN to Laravel: Why I'm Learning PHP and PostgreSQL as a MERN Developer published: false tags: laravel, php, postgresql, webdev

From MERN to Laravel: Why I'm Learning PHP and PostgreSQL as a MERN Developer published: false tags: laravel, php, postgresql, webdev

Comments
4 min read
High-Throughput Database Optimization: Compound Indexing, Caching Patterns, and Query Tuning

High-Throughput Database Optimization: Compound Indexing, Caching Patterns, and Query Tuning

1
Comments
9 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
Handling Duplicate Webhooks Without Duplicating Work

Handling Duplicate Webhooks Without Duplicating Work

Comments
3 min read
Build a Postgres Audit Log Your Application Code Cannot Bypass

Build a Postgres Audit Log Your Application Code Cannot Bypass

Comments
9 min read
SQL vs NoSQL: Kenapa PostgreSQL Masih Jadi 'Swiss Army Knife' di 2026

SQL vs NoSQL: Kenapa PostgreSQL Masih Jadi 'Swiss Army Knife' di 2026

Comments
2 min read
I misspelt 12 footballers' names. Postgres full-text found 4, Meilisearch found all 12.

I misspelt 12 footballers' names. Postgres full-text found 4, Meilisearch found all 12.

5
Comments 1
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.