Articles

Thoughts on software development, databases, and the things I learn along the way.

Filter: All tech 4 postgresql 3 postgres 3 rails 3 databases 2 ruby on rails 2 performance 1 sql 1 travel 1 nfs 1 btrees 1 lifestyle 1

May 15, 2026 7 min

Rails: Polymorphic Associations With Referential Integrity

rails ruby on rails activerecord

On Instagram, posts have comments; stories too have comments. A comment can belong to either a post or a story, not neither or both at a time. Ther...

Read article

May 05, 2026 12 min

Postgres: B+tree scalar array search and skip scan

postgresql postgres indexes

PostgreSQL 18 shipped with a bunch of nice features, and since I have been knee-deep into database indexes lately, one feature that piqued my inter...

Read article

Nov 09, 2025 14 min

Zero-Downtime PostgreSQL Upgrade with Logical Replication and Application-Level Switching

tech databases postgresql

A few months ago, I helped my company upgrade our production PostgreSQL database from version 14 to 17. For context, our product is a physical sec...

Read article

Oct 20, 2025 2 min

Blame It On AI?

tech ai programming

"Shit, AI 🙈", "Ah, fuckin co-pilot 🤦". Lately, I can't keep count of the number of times I've seen such comments on GitHub pull request conversati...

Read article

Oct 12, 2025 8 min

The cost of redundant indexes and how to identify and prevent them.

tech databases postgresql

Indexes function like a double-edged scalpel: precise and lifesaving when wielded skillfully, but capable of impeding a database’s performance if u...

Read article

Sep 27, 2025 6 min

Network file system

tech nfs file system

NFS (Network File System) is a protocol used to mount remote file systems on a computer and perform file operations on the remote files as if they’...

Read article