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.
The auth_rls_initplan linter has a blind spot: SECURITY DEFINER bodies

The auth_rls_initplan linter has a blind spot: SECURITY DEFINER bodies

7
Comments
2 min read
5 gotchas I hit moving LLM logs from Postgres to ClickHouse

5 gotchas I hit moving LLM logs from Postgres to ClickHouse

1
Comments 2
8 min read
Why your DB audit always finds more than your inventory says

Why your DB audit always finds more than your inventory says

Comments 4
3 min read
CQRS in Go — Part 4: PostgreSQL as an event store

CQRS in Go — Part 4: PostgreSQL as an event store

Comments
8 min read
How I built a pure client-side sanitizer to stop leaking Stripe tokens to ChatGPT.

How I built a pure client-side sanitizer to stop leaking Stripe tokens to ChatGPT.

Comments
2 min read
Stop Leaking Tenant Data: PostgreSQL Row-Level Security in Laravel 🛡️

Stop Leaking Tenant Data: PostgreSQL Row-Level Security in Laravel 🛡️

Comments
3 min read
The Autovacuum Scale Factor Problem at Scale - Know Your Defaults

The Autovacuum Scale Factor Problem at Scale - Know Your Defaults

1
Comments 2
6 min read
Database Partitioning: Does It Always Provide Scalability?

Database Partitioning: Does It Always Provide Scalability?

Comments
9 min read
Polymarket 如何用 Postgres + ClickHouse 扩展数据架构

Polymarket 如何用 Postgres + ClickHouse 扩展数据架构

8
Comments
1 min read
I built a local Postgres triage co-pilot because HIPAA says I can't paste plans into ChatGPT or Claude

Gemma 4 Challenge: Build With Gemma 4 Submission

I built a local Postgres triage co-pilot because HIPAA says I can't paste plans into ChatGPT or Claude

13
Comments 4
6 min read
Live, Snapshot, Cache: the three-way decision before storing a derived value

Live, Snapshot, Cache: the three-way decision before storing a derived value

Comments
5 min read
How Polymarket Scaled Their Data Stack with Postgres + ClickHouse

How Polymarket Scaled Their Data Stack with Postgres + ClickHouse

Comments
2 min read
Building an Error Monitoring Tool Without Pricing Overages

Building an Error Monitoring Tool Without Pricing Overages

3
Comments
11 min read
5 PostgreSQL locking behaviors that trip people up

5 PostgreSQL locking behaviors that trip people up

7
Comments 1
7 min read
MongoDB vs PostgreSQL: What is the Difference?

MongoDB vs PostgreSQL: What is the Difference?

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