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.
Two currencies of concession, and only one of them can be haggled over

Two currencies of concession, and only one of them can be haggled over

Comments
6 min read
The Hidden Cost of Unoptimized REST API Payloads in Node.js

The Hidden Cost of Unoptimized REST API Payloads in Node.js

1
Comments 1
1 min read
How to Schedule Marketplace Data Cleanup with App Cron (and Recover Cleanly)

How to Schedule Marketplace Data Cleanup with App Cron (and Recover Cleanly)

Comments
8 min read
The Hour That Doesn’t Exist: Booking Slots Across Daylight Saving Time

The Hour That Doesn’t Exist: Booking Slots Across Daylight Saving Time

2
Comments
9 min read
How I Ran a Zero-Downtime Postgres Migration on a 180M-Row Table With Claude Code

How I Ran a Zero-Downtime Postgres Migration on a 180M-Row Table With Claude Code

Comments
7 min read
I Fixed a Pricing Disaster With a Database Branch

I Fixed a Pricing Disaster With a Database Branch

Comments
4 min read
From 35 seconds to half a second: 70 faster dashboards in plain Postgres

From 35 seconds to half a second: 70 faster dashboards in plain Postgres

Comments
5 min read
Respaldo y recuperaciĂłn de PostgreSQL con despliegue automatizado en la nube

Respaldo y recuperaciĂłn de PostgreSQL con despliegue automatizado en la nube

Comments
6 min read
Normalization vs denormalization in a real Postgres schema: what I fixed, and the copy I kept

Normalization vs denormalization in a real Postgres schema: what I fixed, and the copy I kept

1
Comments 2
7 min read
Fixture Databases or Disposable Servers: A Debate for Agent SQL Rehearsal

Fixture Databases or Disposable Servers: A Debate for Agent SQL Rehearsal

Comments
8 min read
Postgres says NULL is not equal to NULL, which is a bug in one of our unique indexes and a feature in another

Postgres says NULL is not equal to NULL, which is a bug in one of our unique indexes and a feature in another

Comments
6 min read
One line in our Postgres config would have renamed the keys inside our JSONB

One line in our Postgres config would have renamed the keys inside our JSONB

Comments
5 min read
Four things can close the same quiz question, and three of them have to lose

Four things can close the same quiz question, and three of them have to lose

Comments
6 min read
High-Throughput Financial Timeseries with TimescaleDB CAGGs & pgvector Cosine Search

High-Throughput Financial Timeseries with TimescaleDB CAGGs & pgvector Cosine Search

Comments
3 min read
Learning .NET Architecture — Part 1: Design and Setup

Learning .NET Architecture — Part 1: Design and Setup

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