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.
I Built a B-Tree in Pure Python and Finally Understood Why Postgres Uses It for Every Index

I Built a B-Tree in Pure Python and Finally Understood Why Postgres Uses It for Every Index

1
Comments
6 min read
The Soft Delete Trap: Unique Constraints in Laravel 🛑

The Soft Delete Trap: Unique Constraints in Laravel 🛑

Comments
3 min read
Optimistic concurrency is the whole design: event sourcing on Aurora DSQL

Optimistic concurrency is the whole design: event sourcing on Aurora DSQL

Comments
5 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
Retrieval-Augmented Self-Recall — Part 2: Hybrid RAG on Nothing but Postgres

Retrieval-Augmented Self-Recall — Part 2: Hybrid RAG on Nothing but Postgres

1
Comments 2
4 min read
PostgreSQL 22P02 Error: Causes and Solutions Complete Guide

PostgreSQL 22P02 Error: Causes and Solutions Complete Guide

Comments
3 min read
I indexed the entire Django codebase and traced 317 blast-radius references. Here's what I learned building the tool.

I indexed the entire Django codebase and traced 317 blast-radius references. Here's what I learned building the tool.

1
Comments 2
3 min read
There's no standard status page, and other lessons from tracking 96 providers

There's no standard status page, and other lessons from tracking 96 providers

2
Comments 1
5 min read
Installing GDOM with PostgreSQL as the Backend Database

Installing GDOM with PostgreSQL as the Backend Database

2
Comments
3 min read
The 5 RLS holes that quietly leak data in AI-built Supabase apps

The 5 RLS holes that quietly leak data in AI-built Supabase apps

Comments 2
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.