Articles

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

Filter: All tech 4 postgresql 2 databases 2 narrative essay 1 programming 1 nfs 1 file system 1 ai 1 sql 1 postgres 1 ruby on rails 1 performance 1

Showing articles tagged: tech

Nov 09, 2025 14 min

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

rails ruby on rails postgres

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.

databases postgresql sql

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