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.
Running Real Postgres Locally Without Docker (with Tinbase)

Running Real Postgres Locally Without Docker (with Tinbase)

Comments 1
4 min read
9 PostgreSQL Queries Every Data Analyst Should Know (Try Them in Your Browser)

9 PostgreSQL Queries Every Data Analyst Should Know (Try Them in Your Browser)

Comments 1
3 min read
PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

PostgreSQL numeric vs double precision vs money: Which Type to Use for Prices

Comments 1
9 min read
I Gave Every Pull Request Its Own Database

I Gave Every Pull Request Its Own Database

Comments 1
5 min read
Blueprint Full-Stack 2026: Kembali ke Dasar yang Powerfull

Blueprint Full-Stack 2026: Kembali ke Dasar yang Powerfull

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

A PostgreSQL deadlock hiding in a foreign key check

Comments
12 min read
How to catch a missing index in a test, when your test table has 20 rows.

How to catch a missing index in a test, when your test table has 20 rows.

Comments 4
6 min read
The Unique Index That Makes Your Endpoint Retry-Safe

The Unique Index That Makes Your Endpoint Retry-Safe

Comments
3 min read
PostgreSQL Generated Column vs Trigger: Which to Use for a Derived Column

PostgreSQL Generated Column vs Trigger: Which to Use for a Derived Column

Comments
10 min read
pg_restore finished fine. One of my tables wasn't there.

pg_restore finished fine. One of my tables wasn't there.

Comments 1
4 min read
Your Company Does Not Need Another AI Chatbot. It Needs a Knowledge Layer.

Your Company Does Not Need Another AI Chatbot. It Needs a Knowledge Layer.

Comments
12 min read
Preventing Race Conditions in Symfony with Doctrine and PostgreSQL

Preventing Race Conditions in Symfony with Doctrine and PostgreSQL

Comments
8 min read
PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

PostgreSQL Unique Constraint vs Unique Index: Which to Use, and How to Add One Without Locking the Table

Comments
9 min read
Your Test Suite Is Slow Because It Tests Postgres

Your Test Suite Is Slow Because It Tests Postgres

Comments
3 min read
PostgreSQL index bloat: why VACUUM never shrinks an index, and how to measure it with avg_leaf_density

PostgreSQL index bloat: why VACUUM never shrinks an index, and how to measure it with avg_leaf_density

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