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.
PostgreSQL vs MySQL: A 2026 Production Decision Framework

PostgreSQL vs MySQL: A 2026 Production Decision Framework

1
Comments
5 min read
Who's That Pokémon?
Cover image for Who's That Pokémon?

Who's That Pokémon?

2
Comments
12 min read
Supabase vs Firebase in 2026: The Honest Comparison After Using Both in Production

Supabase vs Firebase in 2026: The Honest Comparison After Using Both in Production

1
Comments
17 min read
How Instagram Scales Tagging for Billions of Users

How Instagram Scales Tagging for Billions of Users

Comments
2 min read
Full-Text Search in PostgreSQL: When You Can Skip Elasticsearch

Full-Text Search in PostgreSQL: When You Can Skip Elasticsearch

1
Comments
8 min read
Full-Text Search in PostgreSQL: When You Can Skip Elasticsearch

Full-Text Search in PostgreSQL: When You Can Skip Elasticsearch

1
Comments
8 min read
Racing Against 2 Billion: How We Survived a PostgreSQL Transaction ID Wraparound on a 2TB Production Table

Racing Against 2 Billion: How We Survived a PostgreSQL Transaction ID Wraparound on a 2TB Production Table

2
Comments
8 min read
Database Transaction Leak

Database Transaction Leak

Comments
3 min read
How We Tamed 300+ Stored Procedures in a Legacy PostgreSQL Project

How We Tamed 300+ Stored Procedures in a Legacy PostgreSQL Project

5
Comments
3 min read
AlloyDB + SQLAlchemy: Connection Pooling Strategies That Actually Work in Production

AlloyDB + SQLAlchemy: Connection Pooling Strategies That Actually Work in Production

Comments
3 min read
Kinora Home

Kinora Home

Comments 1
1 min read
How to Connect PostgreSQL to Google Apps Script (JDBC Guide)

How to Connect PostgreSQL to Google Apps Script (JDBC Guide)

1
Comments
15 min read
TimescaleDB Outperforms MongoDB for JSON Logs (100M Document Benchmark)
Cover image for TimescaleDB Outperforms MongoDB for JSON Logs (100M Document Benchmark)

TimescaleDB Outperforms MongoDB for JSON Logs (100M Document Benchmark)

11
Comments 4
7 min read
Scaling to 200+ Cities by Deleting 90% of My Database
Cover image for Scaling to 200+ Cities by Deleting 90% of My Database

Scaling to 200+ Cities by Deleting 90% of My Database

Comments 2
6 min read
A year-long hunt for a Linux kernel bug, or the unexpected zeros from XFS

A year-long hunt for a Linux kernel bug, or the unexpected zeros from XFS

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