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.
Postgres triggers invalidate our Redis cache at Oizom

Postgres triggers invalidate our Redis cache at Oizom

Comments
11 min read
Migrating a Large Table Without Locking Production

Migrating a Large Table Without Locking Production

4
Comments 1
15 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
Your background jobs need SLOs too. 'It eventually ran' isn't good enough

Your background jobs need SLOs too. 'It eventually ran' isn't good enough

Comments
5 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
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
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
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
"Find What's Nearby" Doesn't Need a Separate GIS Stack

"Find What's Nearby" Doesn't Need a Separate GIS Stack

Comments
2 min read
Node.js Checkout Failure Alerts (Polling Postgres Metrics With Cost Attribution)

Node.js Checkout Failure Alerts (Polling Postgres Metrics With Cost Attribution)

Comments 1
7 min read
Node.js Transactional Email Service: Deliverability Plus Preview Tests for Gaming Support

Node.js Transactional Email Service: Deliverability Plus Preview Tests for Gaming Support

Comments 1
6 min read
Pause became a question with three answers, so we wrote the rules twice and only one copy has tests

Pause became a question with three answers, so we wrote the rules twice and only one copy has tests

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