Forem

# 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)
Cover image for 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
Cover image for 🧠 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for El camino hacia Amazon Aurora DSQL

El camino hacia Amazon Aurora DSQL

7
Comments
10 min read
The Path to Amazon Aurora DSQL
Cover image for 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
Cover image for 🧠 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
Cover image for 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
How we built a real-time service that handles 20,000 updates per second
Cover image for 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
Cover image for 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
Cover image for 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

3
Comments
4 min read
From JSONL to a normalized relational database. Is a tool necessary?

From JSONL to a normalized relational database. Is a tool necessary?

5
Comments 4
2 min read
loading...