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.
Why I don't trust AI with my query plans

Why I don't trust AI with my query plans

Comments
2 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

27
Comments 2
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
How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

2
Comments
4 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

7
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
How diffChangelog and Snapshots Work Together

How diffChangelog and Snapshots Work Together

5
Comments
4 min read
Fix “invalid literal for int() with base 10: 'None'” in FastAPI (Asyncpg + Docker)

Fix “invalid literal for int() with base 10: 'None'” in FastAPI (Asyncpg + Docker)

3
Comments
4 min read
Building a Directory Platform with Node.js & PostgreSQL (Lessons from a Niche Gaming Project)

Building a Directory Platform with Node.js & PostgreSQL (Lessons from a Niche Gaming Project)

Comments
2 min read
Why Your PostgreSQL Keeps Running Out of Connections

Why Your PostgreSQL Keeps Running Out of Connections

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