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.
What I learned counting 600,000 live job adverts every night

What I learned counting 600,000 live job adverts every night

Comments
3 min read
Idempotency keys, under load

Idempotency keys, under load

Comments
4 min read
Safe Multi-Environment Database Orchestration

Safe Multi-Environment Database Orchestration

Comments
3 min read
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.109: $match $sort $limit $project covered by index scan

DocumentDB 0.109: $match $sort $limit $project covered by index scan

Comments
5 min read
The Outbox Held, the Ledger Didn't

The Outbox Held, the Ledger Didn't

Comments
4 min read
Postgres Evidence for 2-Stage Image Generation API Prompt Safety (During Churn)

Postgres Evidence for 2-Stage Image Generation API Prompt Safety (During Churn)

Comments
6 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.