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.
Your Audit Log Agrees With Itself. That's the Problem.

Your Audit Log Agrees With Itself. That's the Problem.

12
Comments 3
5 min read
Row-level security in SvelteKit: defense-in-depth that actually works with Drizzle ORM

Row-level security in SvelteKit: defense-in-depth that actually works with Drizzle ORM

Comments 1
3 min read
Postgres 19 Learned to Speak Graph

Postgres 19 Learned to Speak Graph

Comments
19 min read
Directus + Coolify: Should You Decouple Postgres & Redis?

Directus + Coolify: Should You Decouple Postgres & Redis?

Comments
5 min read
Stop adding Redis just for simple job queues: I built catqueue, a PostgreSQL-native job queue for Node & TypeScript

Stop adding Redis just for simple job queues: I built catqueue, a PostgreSQL-native job queue for Node & TypeScript

1
Comments
1 min read
Backing Up and Restoring PostgreSQL Databases Using pg_dump and pg_restore

Backing Up and Restoring PostgreSQL Databases Using pg_dump and pg_restore

6
Comments
4 min read
Your audit log is probably lying to you. Postgres 18 fixes it in one statement.

Concurrently logged ghosts hide lost transactions

Your audit log is probably lying to you. Postgres 18 fixes it in one statement.

18
Comments 10
5 min read
Automated Student Report Delivery in Rust | Bulk Email PDF Reports

Automated Student Report Delivery in Rust | Bulk Email PDF Reports

Comments
1 min read
Docker Compose has init containers now. Here's what I deleted.

Docker Compose has init containers now. Here's what I deleted.

11
Comments 1
6 min read
Supabase migrations ship safely when every change is reversible and tested first

Supabase migrations ship safely when every change is reversible and tested first

Comments
7 min read
OpenSparrow v3.6 adds an External API module

OpenSparrow v3.6 adds an External API module

1
Comments
2 min read
We Deleted Our Vector Database. Postgres Was Faster.

We Deleted Our Vector Database. Postgres Was Faster.

11
Comments 3
9 min read
Supabase realtime keeps mobile presence honest without polling your database dead

Supabase realtime keeps mobile presence honest without polling your database dead

Comments
6 min read
Docker Alternatives for Local Postgres Dev: A 2026 Comparison

Docker Alternatives for Local Postgres Dev: A 2026 Comparison

Comments
4 min read
The side-project double tax nobody mentions

The side-project double tax nobody mentions

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