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.
From 5 Seconds to 50ms: How I Stopped Nuking My Database Every Time I Deleted an Order

From 5 Seconds to 50ms: How I Stopped Nuking My Database Every Time I Deleted an Order

Comments
7 min read
Three PostgreSQL Master/Replica Discovery Problems — and How to Solve Them

Three PostgreSQL Master/Replica Discovery Problems — and How to Solve Them

Comments
17 min read
PostgreSQL 22P02 Error: Causes and Solutions Complete Guide

PostgreSQL 22P02 Error: Causes and Solutions Complete Guide

Comments
3 min read
I Built a Search Engine That Understands Meaning — in ~150 Lines, Zero API Keys

I Built a Search Engine That Understands Meaning — in ~150 Lines, Zero API Keys

1
Comments 1
3 min read
From Rate Card to Database: Engineering UPS Shipping Rates Into a Multi-Carrier Logistics Platform published: false

From Rate Card to Database: Engineering UPS Shipping Rates Into a Multi-Carrier Logistics Platform published: false

4
Comments
8 min read
PostgreSQL 22P01 Error: Causes and Solutions Complete Guide

PostgreSQL 22P01 Error: Causes and Solutions Complete Guide

Comments
3 min read
Why my first RAG layer starts in Postgres, not in a standalone vector database

Why my first RAG layer starts in Postgres, not in a standalone vector database

Comments
3 min read
PostgreSQL 2200F Error: Causes and Solutions Complete Guide

PostgreSQL 2200F Error: Causes and Solutions Complete Guide

Comments
3 min read
How I built a flash-sale engine that can't oversell

How I built a flash-sale engine that can't oversell

Comments
4 min read
Building a REST API with ASP.NET Core and PostgreSQL

Building a REST API with ASP.NET Core and PostgreSQL

Comments
2 min read
PostgreSQL 22027 Error: Causes and Solutions Complete Guide

PostgreSQL 22027 Error: Causes and Solutions Complete Guide

Comments
3 min read
Como reduzimos o backup PostgreSQL de 25 horas para menos de 3 horas (sem trocar hardware)

Como reduzimos o backup PostgreSQL de 25 horas para menos de 3 horas (sem trocar hardware)

Comments
3 min read
Four pgvector patterns that kept our RAG SaaS on one Postgres

Four pgvector patterns that kept our RAG SaaS on one Postgres

Comments
6 min read
Quand on vous signale 1 bug, il y en a toujours plus (le grep qui a démonté mes hypothèses)

Quand on vous signale 1 bug, il y en a toujours plus (le grep qui a démonté mes hypothèses)

Comments
3 min read
When a user reports 1 bug, there are always more (the grep that broke my assumptions)

When a user reports 1 bug, there are always more (the grep that broke my assumptions)

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