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.
Zero-Downtime MariaDB PostgreSQL Migration: Why the Usual Tools Fell Short, and How Debezium CDC Solved It

Zero-Downtime MariaDB PostgreSQL Migration: Why the Usual Tools Fell Short, and How Debezium CDC Solved It

Comments
9 min read
Setting Up PostgreSQL the Right Way

Setting Up PostgreSQL the Right Way

Comments
6 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
The Role of a Database Administrator: Building a Database from Scratch in PostgreSQL

The Role of a Database Administrator: Building a Database from Scratch in PostgreSQL

Comments
8 min read
lib/tasks/force_drop.rake

lib/tasks/force_drop.rake

Comments
7 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
Does Prisma respect Supabase RLS? No — here's why

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

Comments 1
6 min read
NOT IN returned zero rows. It wasn't your data — it was one NULL.

NOT IN returned zero rows. It wasn't your data — it was one NULL.

Comments 1
2 min read
Why Fuzzy Search Alone Produces Bad Food Results

Why Fuzzy Search Alone Produces Bad Food Results

5
Comments
5 min read
Rails Wasn’t Our Bottleneck. PostgreSQL I/O Was.

Rails Wasn’t Our Bottleneck. PostgreSQL I/O Was.

Comments
2 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.