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.
What It Actually Takes to Audit Aurora PostgreSQL on AWS

What It Actually Takes to Audit Aurora PostgreSQL on AWS

Comments
7 min read
Most AI Agents Do Not Have a Memory Problem. They Have a Coordination Problem.

Most AI Agents Do Not Have a Memory Problem. They Have a Coordination Problem.

Comments
5 min read
How I built a free real estate AVM with 375k notary transactions, PostGIS, and a 4€/month VPS

How I built a free real estate AVM with 375k notary transactions, PostGIS, and a 4€/month VPS

3
Comments
4 min read
I Renamed a Hot Postgres Table Without Dropping a Request

I Renamed a Hot Postgres Table Without Dropping a Request

1
Comments 1
5 min read
Preventing double-bookings with PostgreSQL exclusion constraints

Preventing double-bookings with PostgreSQL exclusion constraints

Comments
6 min read
RAG and Vector Search with pgvector and Amazon Bedrock (Part 4)

RAG and Vector Search with pgvector and Amazon Bedrock (Part 4)

Comments 1
8 min read
Testing NGB Platform Beyond a Small Demo Dataset with k6 and TypeScript

Testing NGB Platform Beyond a Small Demo Dataset with k6 and TypeScript

Comments
5 min read
Stop Reading EXPLAIN Plans by Hand: Introducing pgexplain and pgwatch 🐘

Stop Reading EXPLAIN Plans by Hand: Introducing pgexplain and pgwatch 🐘

Comments
4 min read
PostgreSQL backup tool Databasus released backup verification in real database Docker containers

PostgreSQL backup tool Databasus released backup verification in real database Docker containers

Comments 1
7 min read
Multi-Tenant Auth with Cognito and PostgreSQL Row-Level Security (Part 2)

Multi-Tenant Auth with Cognito and PostgreSQL Row-Level Security (Part 2)

Comments 1
7 min read
76 RLS policies rewritten in one migration: the auth.uid() init-plan trap in Supabase

76 RLS policies rewritten in one migration: the auth.uid() init-plan trap in Supabase

1
Comments
6 min read
Why Real-Time Analytics Eventually Changes Your Database Architecture

Why Real-Time Analytics Eventually Changes Your Database Architecture

2
Comments
4 min read
The Outbox Pattern in PHP from Scratch (No Library, 80 Lines)

The Outbox Pattern in PHP from Scratch (No Library, 80 Lines)

Comments
8 min read
The Other Half of the Dual-Write Problem: What Happens When a Job Finishes

The Other Half of the Dual-Write Problem: What Happens When a Job Finishes

Comments
7 min read
Your agent forgets yesterday's lessons by tomorrow. Here's the layer we built to fix that.

Your agent forgets yesterday's lessons by tomorrow. Here's the layer we built to fix that.

Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.