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.
Change Data Capture in 2026: Supabase Webhooks, Prisma Pulse, and the "Thundering Herd" Problem

Change Data Capture in 2026: Supabase Webhooks, Prisma Pulse, and the "Thundering Herd" Problem

Comments 2
7 min read
How to Check Supabase Row Level Security Holes (Free SQL Audit)

How to Check Supabase Row Level Security Holes (Free SQL Audit)

Comments
3 min read
Testing FastAPI Endpoints: From Unit Tests to Integration Tests with PostgreSQL

Testing FastAPI Endpoints: From Unit Tests to Integration Tests with PostgreSQL

Comments
4 min read
You Might Not Need Kafka: Building a Job Queue with PostgreSQL

You Might Not Need Kafka: Building a Job Queue with PostgreSQL

Comments
4 min read
Stop Compiling Postgres Extensions in Your Dockerfile: How pglayers Works

Stop Compiling Postgres Extensions in Your Dockerfile: How pglayers Works

1
Comments
8 min read
Connection Pooling in the Serverless Era: Five Failure Modes

Connection Pooling in the Serverless Era: Five Failure Modes

Comments 2
13 min read
lib/tasks/force_drop.rake

lib/tasks/force_drop.rake

Comments
7 min read
Does Prisma respect Supabase RLS? No — here's why

Does Prisma respect Supabase RLS? No — here's why

Comments 1
6 min read
PostgreSQL a scala “planetaria”: l’architettura semplice (ma disciplinata) per reggere carichi enormi

PostgreSQL a scala “planetaria”: l’architettura semplice (ma disciplinata) per reggere carichi enormi

Comments
4 min read
Why Fuzzy Search Alone Produces Bad Food Results

Why Fuzzy Search Alone Produces Bad Food Results

5
Comments
5 min read
Map First, Walk Second: What a Librarian Taught Me About Postgres

Map First, Walk Second: What a Librarian Taught Me About Postgres

1
Comments
3 min read
Postgres vs Redis, Mongo, and RabbitMQ: Do You Really Need All Four?

Postgres vs Redis, Mongo, and RabbitMQ: Do You Really Need All Four?

Comments
8 min read
Five specific schema patterns — unbounded VARCHAR, nullable columns inside multi

Five specific schema patterns — unbounded VARCHAR, nullable columns inside multi

Comments
7 min read
I Stopped My PostgreSQL Primary 10 Times to Measure Real RPO

I Stopped My PostgreSQL Primary 10 Times to Measure Real RPO

Comments 1
3 min read
Introducing tinbase — local Supabase without Docker (one process, real Postgres)

Introducing tinbase — local Supabase without Docker (one process, real Postgres)

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