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 Dropping "await" is Broken: Building a Resilient Background Task Engine with Node.js, Redis Streams, and PostgreSQL

Why Dropping "await" is Broken: Building a Resilient Background Task Engine with Node.js, Redis Streams, and PostgreSQL

Comments
4 min read
Building an Agentic System in .NET, Part 3: Durable Memory with Postgres and pgvector

Building an Agentic System in .NET, Part 3: Durable Memory with Postgres and pgvector

Comments
6 min read
Self-Hosting Supabase for Health Data under GDPR: Lessons From Running a Telemedicine Platform

Self-Hosting Supabase for Health Data under GDPR: Lessons From Running a Telemedicine Platform

1
Comments
7 min read
Seven ways my pinball repair bot got the manual wrong

Seven ways my pinball repair bot got the manual wrong

Comments
5 min read
Why Rust + Postgres RLS

Why Rust + Postgres RLS

Comments
5 min read
Postgres triggers invalidate our Redis cache at Oizom

Postgres triggers invalidate our Redis cache at Oizom

Comments
11 min read
We shipped a feature whose only job is to stop the pipeline, and enough is two weekdays of outflow

We shipped a feature whose only job is to stop the pipeline, and enough is two weekdays of outflow

Comments
8 min read
Two campaigns in one city import the listing once, and the cache key is a half degree square

Two campaigns in one city import the listing once, and the cache key is a half degree square

Comments
6 min read
Borramos la tabla de producción a propósito: una prueba de desastre real con PostgreSQL, Neon y Render

Borramos la tabla de producción a propósito: una prueba de desastre real con PostgreSQL, Neon y Render

Comments
5 min read
1,250,964 audit rows recorded that we had decided nothing, and 51,884 recorded a decision

1,250,964 audit rows recorded that we had decided nothing, and 51,884 recorded a decision

Comments
5 min read
A search box is a second door into the same scanner, and Postgres made us write one expression twice

A search box is a second door into the same scanner, and Postgres made us write one expression twice

Comments
5 min read
We dropped 8 indexes and added 3 without a single production statistic

We dropped 8 indexes and added 3 without a single production statistic

Comments
5 min read
Our delete all my data button leaves one table alone, and the dialog says so

Our delete all my data button leaves one table alone, and the dialog says so

Comments
4 min read
A RAG consultant for an immigration law firm: what it answers and what it hands to the lawyer

A RAG consultant for an immigration law firm: what it answers and what it hands to the lawyer

Comments
3 min read
Estrategias de respaldo en PostgreSQL: lógico, físico y PITR (con un laboratorio que corre en tu navegador)

Estrategias de respaldo en PostgreSQL: lógico, físico y PITR (con un laboratorio que corre en tu navegador)

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