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.
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
Don't DROP COLUMN while old app code still reads it

Don't DROP COLUMN while old app code still reads it

1
Comments
3 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
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
The biggest delete in our app is one line of raw SQL against a table our ORM does not manage

The biggest delete in our app is one line of raw SQL against a table our ORM does not manage

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
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
CREATE INDEX on a live Postgres table locks writes. CONCURRENTLY fixes that, if you keep it out of a transaction

CREATE INDEX on a live Postgres table locks writes. CONCURRENTLY fixes that, if you keep it out of a transaction

Comments
3 min read
Supabase multi-tenant RLS: membership policy pattern

Supabase multi-tenant RLS: membership policy pattern

Comments 1
5 min read
When the Disparate Must Become One: On Honest Distributed Systems

When the Disparate Must Become One: On Honest Distributed Systems

Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.