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.
3 Bugs We Found Auditing Our Own Payments System (Before a Customer Did)

3 Bugs We Found Auditing Our Own Payments System (Before a Customer Did)

1
Comments 7
3 min read
Changing one field in a 100KB document, in Postgres and in MongoDB

Changing one field in a 100KB document, in Postgres and in MongoDB

9
Comments
6 min read
Window Functions, Joins, CTEs and Subqueries in SQL: A Hospital Dataset Walkthrough.

Window Functions, Joins, CTEs and Subqueries in SQL: A Hospital Dataset Walkthrough.

Comments
9 min read
The 8-Digit Code That Replaced Login Forms in My Vehicle Service History App

The 8-Digit Code That Replaced Login Forms in My Vehicle Service History App

2
Comments 1
3 min read
rm -rf on the wrong server: how GitLab lost its production database

rm -rf on the wrong server: how GitLab lost its production database

1
Comments 1
9 min read
PostgreSQL vs MongoDB di Era AI: Masihkah Document Store Menjadi Pilihan Utama?

PostgreSQL vs MongoDB di Era AI: Masihkah Document Store Menjadi Pilihan Utama?

Comments 2
2 min read
The YouTube API terms give you 30 days, so our database is built to forget

The YouTube API terms give you 30 days, so our database is built to forget

1
Comments
7 min read
10,000 units a day, one API key, and three caps that are not the same number

10,000 units a day, one API key, and three caps that are not the same number

1
Comments
6 min read
Our job queue is one Postgres table, and fairness is three ORDER BY terms

Our job queue is one Postgres table, and fairness is three ORDER BY terms

1
Comments
7 min read
Why COUNT(*) Is So Slow in PostgreSQL (And How to Fix It)

Why COUNT(*) Is So Slow in PostgreSQL (And How to Fix It)

6
Comments 2
3 min read
Two actors want the same reward row, and only the one that gets it back from the UPDATE may call Stripe

Two actors want the same reward row, and only the one that gets it back from the UPDATE may call Stripe

1
Comments
6 min read
I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.

I Almost Published a Chart Saying the Nifty Fell 51% in 2003. It Fell 16%. Here Is the Bug.

1
Comments 1
5 min read
A PostgreSQL deadlock hiding in a foreign key check

A PostgreSQL deadlock hiding in a foreign key check

Comments
12 min read
The SQL NOT IN Trap: When NULL Quietly Breaks Your Query

The SQL NOT IN Trap: When NULL Quietly Breaks Your Query

4
Comments 10
4 min read
Three Supabase RLS settings worth checking before launch

Three Supabase RLS settings worth checking before launch

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