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.
5 PostgreSQL Tricks That Made My SaaS x10 Faster (2025 Edition)

5 PostgreSQL Tricks That Made My SaaS x10 Faster (2025 Edition)

Comments
4 min read
How to Fix Django Migration Errors: UUID vs. BigInt Foreign Key Conflicts

How to Fix Django Migration Errors: UUID vs. BigInt Foreign Key Conflicts

2
Comments 1
3 min read
🧠 Understanding SQL Query Execution Order: Not As Straightforward As You Think

🧠 Understanding SQL Query Execution Order: Not As Straightforward As You Think

1
Comments
2 min read
Database locking revisited

Database locking revisited

Comments
21 min read
Understanding Durability in PostgreSQL The "D" in ACID

Understanding Durability in PostgreSQL The "D" in ACID

5
Comments
5 min read
pg_dphyp: teach PostgreSQL to JOIN tables in a different way

pg_dphyp: teach PostgreSQL to JOIN tables in a different way

5
Comments 3
76 min read
PostgreSQL SET NOT NULL Zero Downtime Gotcha

PostgreSQL SET NOT NULL Zero Downtime Gotcha

Comments
3 min read
🔐 How to Reset Your Forgotten PostgreSQL Password (Windows Guide)

🔐 How to Reset Your Forgotten PostgreSQL Password (Windows Guide)

5
Comments
3 min read
From MySQL to PostgreSQL: Enforcing Row-Level Security

From MySQL to PostgreSQL: Enforcing Row-Level Security

Comments
2 min read
PostgreSQL Practical Labs: Error Handling, Maintenance, and Performance Tuning

PostgreSQL Practical Labs: Error Handling, Maintenance, and Performance Tuning

Comments
2 min read
Running PostgreSQL in Docker with Persistent Volume

Running PostgreSQL in Docker with Persistent Volume

12
Comments
3 min read
Brighter V10: Using PostgreSQL as a Lightweight Messaging Gateway

Brighter V10: Using PostgreSQL as a Lightweight Messaging Gateway

Comments
2 min read
Week 2 Building Treazurex — Lessons from the Backend and Beyond

Week 2 Building Treazurex — Lessons from the Backend and Beyond

Comments
3 min read
El camino hacia Amazon Aurora DSQL

El camino hacia Amazon Aurora DSQL

7
Comments
10 min read
The Path to Amazon Aurora DSQL

The Path to Amazon Aurora DSQL

3
Comments
9 min read
🧠 Optimizing PostgreSQL Queries in a Full-Stack App: A Developer’s Playbook

🧠 Optimizing PostgreSQL Queries in a Full-Stack App: A Developer’s Playbook

1
Comments
3 min read
How I got into open source in 2025 (with a PostgreSQL backup tool) after almost losing a ~$1,500/mo project in 2023

How I got into open source in 2025 (with a PostgreSQL backup tool) after almost losing a ~$1,500/mo project in 2023

1
Comments 2
6 min read
The Developer's Guide to Never Messing Up Time Zones Again: A TypeScript, Drizzle, and PostgreSQL Journey

The Developer's Guide to Never Messing Up Time Zones Again: A TypeScript, Drizzle, and PostgreSQL Journey

7
Comments 4
10 min read
Dump and Sync PostgreSQL Schema with Python (No Data, No BS)

Dump and Sync PostgreSQL Schema with Python (No Data, No BS)

25
Comments 4
2 min read
Streaming PostgreSQL Backups with pgrwl: Now with Time & Count-Based Retention!

Streaming PostgreSQL Backups with pgrwl: Now with Time & Count-Based Retention!

Comments
2 min read
How we built a real-time service that handles 20,000 updates per second

How we built a real-time service that handles 20,000 updates per second

24
Comments
6 min read
Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast

Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast

2
Comments 1
14 min read
Build a Full-Stack App with Next.js 14, Prisma, and PostgreSQL

Build a Full-Stack App with Next.js 14, Prisma, and PostgreSQL

Comments
1 min read
Top Free ER Diagram Tools for PostgreSQL in 2025

Top Free ER Diagram Tools for PostgreSQL in 2025

11
Comments 1
7 min read
Understanding the PostgreSQL Crosstab Function

Understanding the PostgreSQL Crosstab Function

2
Comments
4 min read
loading...