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.
SQL for Frontend Engineers: Model the Relationship First

SQL for Frontend Engineers: Model the Relationship First

Comments
6 min read
A whole country on the phone, without map clustering

A whole country on the phone, without map clustering

Comments
6 min read
A quiet day sends no email, and an audit row is the only thing stopping a second one

A quiet day sends no email, and an audit row is the only thing stopping a second one

1
Comments
6 min read
Writing a Reconciliation Job in SQL and Python That Proves Two Systems Agree

Writing a Reconciliation Job in SQL and Python That Proves Two Systems Agree

2
Comments 2
12 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
Stop using ddl-auto=update in production

Stop using ddl-auto=update in production

Comments
8 min read
Catching schema drift before it breaks production

Catching schema drift before it breaks production

Comments
6 min read
Migrax vs Flyway: generated vs hand-written migrations

Migrax vs Flyway: generated vs hand-written migrations

Comments
5 min read
The double-booking bug I shipped in my Next.js booking app (and how Postgres fixed it)

The double-booking bug I shipped in my Next.js booking app (and how Postgres fixed it)

Comments 5
3 min read
Supabase Stops Auto-Exposing New Tables on Oct 30: The Checklist to Run This Week

Supabase Stops Auto-Exposing New Tables on Oct 30: The Checklist to Run This Week

1
Comments 1
12 min read
JSONB, Dynamic Columns, or a Search Engine — How Do You Store Tenant-Defined Fields?

JSONB, Dynamic Columns, or a Search Engine — How Do You Store Tenant-Defined Fields?

1
Comments 5
2 min read
Running Real Postgres Locally Without Docker (with Tinbase)

Running Real Postgres Locally Without Docker (with Tinbase)

Comments 1
4 min read
Two People Bought the Last Ticket. Both Got a Confirmation Email.

Two People Bought the Last Ticket. Both Got a Confirmation Email.

Comments 1
9 min read
The last month is always a lie: lessons from querying 1 billion rows of Brazilian crime data

The last month is always a lie: lessons from querying 1 billion rows of Brazilian crime data

1
Comments 2
3 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.