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.
Saved to Postgres, never queued: the transactional outbox for Node

Saved to Postgres, never queued: the transactional outbox for Node

Comments
6 min read
Postgres Restore Drill: What a Green pg_dump Exit Code Proves

Postgres Restore Drill: What a Green pg_dump Exit Code Proves

Comments
6 min read
Big Billion Days - System Design

Big Billion Days - System Design

Comments
4 min read
Supabase RLS checklist for Lovable and Bolt apps: what we found in 38 codebases

Supabase RLS checklist for Lovable and Bolt apps: what we found in 38 codebases

Comments 1
9 min read
Exploring tenant isolation with Spring Boot, OIDC, and PostgreSQL RLS

Exploring tenant isolation with Spring Boot, OIDC, and PostgreSQL RLS

1
Comments
5 min read
Why COUNT(*) Is So Slow in PostgreSQL (And How to Fix It)

Why COUNT(*) Is So Slow in PostgreSQL (And How to Fix It)

6
Comments
3 min read
Read-Only Postgres Role for AI Agents: 7 Gaps to Close

Read-Only Postgres Role for AI Agents: 7 Gaps to Close

2
Comments 2
10 min read
Measuring realized Cardano staking yield from cardano-db-sync: epoch rewards over epoch stake, split by pool size

Measuring realized Cardano staking yield from cardano-db-sync: epoch rewards over epoch stake, split by pool size

Comments
4 min read
3 Bugs We Found Auditing Our Own Payments System (Before a Customer Did)

3 Bugs We Found Auditing Our Own Payments System (Before a Customer Did)

Comments 1
3 min read
The Compose Race Your Coding Agent Inherits From You

The Compose Race Your Coding Agent Inherits From You

Comments
12 min read
Migrax vs Flyway: generated vs hand-written migrations

Migrax vs Flyway: generated vs hand-written migrations

Comments
5 min read
Catching schema drift before it breaks production

Catching schema drift before it breaks production

Comments
6 min read
Stop using ddl-auto=update in production

Stop using ddl-auto=update in production

Comments
8 min read
Our maintenance mode is one boolean in a TypeScript file, and it taught us that our sign-in pages are not public

Our maintenance mode is one boolean in a TypeScript file, and it taught us that our sign-in pages are not public

Comments
6 min read
Our 32 migrations are 36 KB of SQL, and the folder they live in holds 2.4 MB of JSON

Our 32 migrations are 36 KB of SQL, and the folder they live in holds 2.4 MB of JSON

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