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.
7 PostgreSQL monitoring tools every DBA should know in 2026

7 PostgreSQL monitoring tools every DBA should know in 2026

Comments
7 min read
🐳 Fixing “FATAL: database does not exist” in PostgreSQL Docker (Healthcheck Mistake)

🐳 Fixing “FATAL: database does not exist” in PostgreSQL Docker (Healthcheck Mistake)

Comments
2 min read
I built an open-source PostgreSQL backup manager — self-host it in one command

I built an open-source PostgreSQL backup manager — self-host it in one command

1
Comments 1
1 min read
Scaling Laravel + PostgreSQL: The 'Lateral Join' Pattern for High-Performance SaaS

Scaling Laravel + PostgreSQL: The 'Lateral Join' Pattern for High-Performance SaaS

2
Comments
5 min read
The Supabase Gotchas Nobody Warns You About (Until You Hit Them)

The Supabase Gotchas Nobody Warns You About (Until You Hit Them)

1
Comments
5 min read
Why I don't trust AI with my query plans

Why I don't trust AI with my query plans

Comments
2 min read
From 8s to 47ms: Optimizing PostgreSQL for a Government Tender Search Platform

From 8s to 47ms: Optimizing PostgreSQL for a Government Tender Search Platform

Comments
9 min read
I built a PostgreSQL client in Rust because DBeaver was eating my RAM

I built a PostgreSQL client in Rust because DBeaver was eating my RAM

21
Comments 2
2 min read
pgit: What If Your Git History Was a SQL Database?

pgit: What If Your Git History Was a SQL Database?

7
Comments
10 min read
Why PostgreSQL Row-Level Security Is the Right Approach to Django Multitenancy

Why PostgreSQL Row-Level Security Is the Right Approach to Django Multitenancy

8
Comments 8
13 min read
The Queue Was a Table: How I Built Claim/Unclaim Workers with SKIP LOCKED, Stale Recovery, and Retry Caps

The Queue Was a Table: How I Built Claim/Unclaim Workers with SKIP LOCKED, Stale Recovery, and Retry Caps

2
Comments 1
12 min read
The Day My AI Forgot Everything (So I Built a Context-Continuity Inference Stack)

The Day My AI Forgot Everything (So I Built a Context-Continuity Inference Stack)

1
Comments
14 min read
The Search Router That Saved Me From One Index to Rule Them All: Azure AI Search for CRM, pgvector for Transcripts, the CRM a...

The Search Router That Saved Me From One Index to Rule Them All: Azure AI Search for CRM, pgvector for Transcripts, the CRM a...

1
Comments
10 min read
Heat scoring: teaching your data to forget (gracefully)"

Heat scoring: teaching your data to forget (gracefully)"

6
Comments
7 min read
Building a personal knowledge graph with just PostgreSQL (no Neo4j needed)"

Building a personal knowledge graph with just PostgreSQL (no Neo4j needed)"

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