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.
A refactor that touched no database changed our database password

A refactor that touched no database changed our database password

Comments
2 min read
Ranking Scanned PDFs While Preserving OCR Uncertainty

Ranking Scanned PDFs While Preserving OCR Uncertainty

Comments
7 min read
Adding a NOT NULL Column to a Large PostgreSQL Table: Constant Default, Backfill or NOT VALID

Adding a NOT NULL Column to a Large PostgreSQL Table: Constant Default, Backfill or NOT VALID

Comments
10 min read
Database MCP Server: Should an AI Agent Run SQL or Only Read the Schema?

Database MCP Server: Should an AI Agent Run SQL or Only Read the Schema?

Comments
7 min read
ON DELETE SET NULL vs CASCADE vs RESTRICT in PostgreSQL: Which to Use

ON DELETE SET NULL vs CASCADE vs RESTRICT in PostgreSQL: Which to Use

Comments
8 min read
A PostgreSQL Role That Reads the Schema but Not the Data: What to Grant

A PostgreSQL Role That Reads the Schema but Not the Data: What to Grant

Comments
8 min read
Giving a Discord bot long-term memory, and the two ways it went wrong

Giving a Discord bot long-term memory, and the two ways it went wrong

Comments
2 min read
PostgreSQL 19 WAIT FOR LSN from PHP: read-your-writes on a replica, and four ways it bites" published: false

PostgreSQL 19 WAIT FOR LSN from PHP: read-your-writes on a replica, and four ways it bites" published: false

Comments
5 min read
The judges agreed no better than chance: 4 lessons from building a hackathon judging platform

The judges agreed no better than chance: 4 lessons from building a hackathon judging platform

Comments
8 min read
How We Handle 10,000+ Product Queries with Django + PostgreSQL Without Breaking a Sweat

How We Handle 10,000+ Product Queries with Django + PostgreSQL Without Breaking a Sweat

Comments
1 min read
5432 and 1433: two database ports, ten million answers, and the question of what answered

5432 and 1433: two database ports, ten million answers, and the question of what answered

Comments
3 min read
Shopify's draftOrderCreate has no idempotency key, so a timeout is not a failure

Shopify's draftOrderCreate has no idempotency key, so a timeout is not a failure

Comments
4 min read
A Reseller Wallet Balance Is a Ledger Projection

A Reseller Wallet Balance Is a Ledger Projection

Comments
7 min read
TeaQL Was 2,000x Faster Than the Obvious SQLx Query—Here’s What Actually Happened

TeaQL Was 2,000x Faster Than the Obvious SQLx Query—Here’s What Actually Happened

Comments
6 min read
Implementing Node.js Postgres Cron Error Capture — Attributing Media Retry Costs

Implementing Node.js Postgres Cron Error Capture — Attributing Media Retry Costs

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