22h ago · 5 min read · The Setup I was building a FastAPI backend with async SQLAlchemy, asyncpg, and Alembic for database migrations. The stack was clean — PostgreSQL as the database, pydantic-settings for environment mana
Join discussion
1d ago · 7 min read · When I started this project, my goal was simple. I wanted to learn modern backend and distributed system tools in a way that feels real. I didn’t want to just watch tutorials or memorize commands. I w
Join discussion
2d ago · 27 min read · Docker Setup for Multi-Read Replica PostgreSQL In Part 2 of this series, we configured replication entirely by hand — shelling into containers, editing config files, and running commands one at a time
Join discussion1d ago · 13 min read · If you've ever watched a query go from 30 ms to 30 seconds after a data load — without a single line of SQL changing — you've been on the wrong side of a join-strategy flip. Joins are the part of PostgreSQL that's most sensitive to statistics. A 10× ...
Join discussion2d ago · 5 min read · My employment contract said "maintain the database." On my first day I asked where the database was. There was no database. There were 7 Excel sheets. So I built one. The Excel I'll let the data speak for itself. 7 sheets, split by region: a main tab...
Join discussion2d ago · 8 min read · PostgreSQL Index Usage and Optimization If you've spent any time tuning PostgreSQL, you've hit the same frustrating moment: you added an index, you're sure it should be used, and the plan still shows a sequential scan. Or the index is used, but the q...
Join discussion3d ago · 3 min read · Alright, let's talk AlloyDB for a minute. If you're using it, or thinking about it, there's some genuinely exciting stuff dropping. Google just rolled out a bunch of new AI functions and made some big improvements to vector search. And honestly, it m...
Join discussion
