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 database is not an audit log: 72 hours of verifiable hackathon judging

Your database is not an audit log: 72 hours of verifiable hackathon judging

1
Comments
13 min read
DocumentDB 0.116: $sort $group prefix pushdown

DocumentDB 0.116: $sort $group prefix pushdown

Comments
11 min read
Blue-green deploys do not save you from a bad migration

Blue-green deploys do not save you from a bad migration

Comments
4 min read
Django ORM & PostgreSQL Indexing: Benchmarking B-Tree, Composite, and GIN Indexes

Django ORM & PostgreSQL Indexing: Benchmarking B-Tree, Composite, and GIN Indexes

Comments
6 min read
Supabase stops auto-granting on Oct 30. Here is what breaks, and five traps the changelog does not mention.

Supabase stops auto-granting on Oct 30. Here is what breaks, and five traps the changelog does not mention.

Comments
7 min read
PostgreSQL vs MySQL: 7 syntax differences that break migrations

PostgreSQL vs MySQL: 7 syntax differences that break migrations

Comments
4 min read
Ota on dbmask: Proving a Synthetic PostgreSQL Masking Lane

Ota on dbmask: Proving a Synthetic PostgreSQL Masking Lane

Comments
2 min read
SQLite or PostgreSQL: one codebase, two engines, one env var

SQLite or PostgreSQL: one codebase, two engines, one env var

Comments
4 min read
One long SELECT, one ALTER TABLE, and every query behind them

One long SELECT, one ALTER TABLE, and every query behind them

6
Comments
6 min read
The Database Playground: Everything You Can Plug In and Tune in PostgreSQL and MySQL (Including AI Workloads)

The Database Playground: Everything You Can Plug In and Tune in PostgreSQL and MySQL (Including AI Workloads)

Comments
37 min read
Why Your AI Demo Is Fast and Production Is Slow (and the 4 Fixes That Worked)

Why Your AI Demo Is Fast and Production Is Slow (and the 4 Fixes That Worked)

Comments
5 min read
ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N

ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N

Comments
4 min read
The NOT IN trap: why your SQL query returns zero rows

The NOT IN trap: why your SQL query returns zero rows

Comments
3 min read
Gerador Simples de Catálogo de Produtos

Gerador Simples de Catálogo de Produtos

Comments
1 min read
How to Actually Diagnose a Postgres Deadlock in a Spring Boot App

How to Actually Diagnose a Postgres Deadlock in a Spring Boot App

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