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.
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
PostgreSQL vs MySQL in 2026: Why the Debate Is Already Over [Compared]

PostgreSQL vs MySQL in 2026: Why the Debate Is Already Over [Compared]

1
Comments
6 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
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
How Databases Search a Billion Rows

How Databases Search a Billion Rows

1
Comments
2 min read
Built my first web app

Built my first web app

3
Comments
7 min read
Building the Centralized Identity Hub: Secure API Handlers with Next.js & Prisma (Part 2)

Building the Centralized Identity Hub: Secure API Handlers with Next.js & Prisma (Part 2)

1
Comments
3 min read
PostgreSQL slow queries — 7 ways to find and fix performance bottlenecks

PostgreSQL slow queries — 7 ways to find and fix performance bottlenecks

Comments
10 min read
Instalação de programas no ubuntu via terminal

Instalação de programas no ubuntu via terminal

2
Comments
2 min read
My setup for integration tests in Go with embedded-postgres

My setup for integration tests in Go with embedded-postgres

Comments
3 min read
PostgreSQL indexing explained — 5 index types and when to use each

PostgreSQL indexing explained — 5 index types and when to use each

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