Blog

Thoughts & Stories

Sharing my experiences, learnings, and adventures in tech and beyond.

Browse by Topic

DevOps & Cloud Infrastructure (116)Web Development (78)ERP Systems (66)Backend & APIs (50)AI & LLMs (45)Career Reflections (22)Software Development (19)Security (14)Product & SaaS (6)Cloud (5)AI / Machine Learning (5)University (1)Hackathons (1)

OpenTofu vs Terraform: Migrating After the License Change

DevOps

July 20269 min read

OpenTofu vs Terraform: Migrating After the License Change

After HashiCorp's BSL relicense, is switching to OpenTofu worth it? A hands-on look at compatibility, state, the registry, and the actual migration commands.

PgBouncer Pooling Modes: Session vs Transaction vs Statement

Backend

July 20269 min read

PgBouncer Pooling Modes: Session vs Transaction vs Statement

The three PgBouncer pooling modes, the prepared-statement trap that bit me in transaction mode, and how to actually size pool_size for a real app.

Reading PostgreSQL EXPLAIN ANALYZE Like a Pro

Backend

July 20269 min read

Reading PostgreSQL EXPLAIN ANALYZE Like a Pro

How I read PostgreSQL EXPLAIN ANALYZE output: seq scan vs index scan, nested loop vs hash join, buffers, and how to find the node that is actually slow.

PostgreSQL Generated Columns for Computed Data

Backend

July 20269 min read

PostgreSQL Generated Columns for Computed Data

When to push derived logic into STORED generated columns, how to index them, and the constraints that bite you in production.

Zero-Downtime PostgreSQL Major Upgrades with Logical Replication

Backend

July 20269 min read

Zero-Downtime PostgreSQL Major Upgrades with Logical Replication

How to move a live PostgreSQL database to a new major version with sub-second downtime using publications and subscriptions — and the sequence, large-object, and DDL gaps that will bite you at cutover if you forget them.

A Reliable Job Queue in PostgreSQL with SKIP LOCKED

Backend

July 20269 min read

A Reliable Job Queue in PostgreSQL with SKIP LOCKED

How SELECT FOR UPDATE SKIP LOCKED turns a plain table into a concurrent job queue with no double-processing, and where a real broker still wins.

Showing 85–90 of 428 posts

Explore More

Projects

See the projects I've built

Experience

My professional career

Certifications

Professional certifications