March 23, 2026

Normalizing the Weight Tracker DB

I’m deranged. I like normalization. Apparently (according to Claude), it can over-engineer things, but I like it. In a recent convo, I explored the pros and cons of using a db with normalized tables built for expansion versus a simple db designed for my specific use case. I have a little weight tracker app deployed[…]

March 13, 2026

Rethinkering

Relationships in SQLAlchemy

I got curious when I was looking over a Claude designed model for my weight tracker app. My intent was to learn why it didn’t full out normalize some tables. It scoffed and told me not to over-engineer my tables due to the scope of the audience. I might have made up the scoffing part,[…]

August 7, 2025

Factory Pattern for Testing Roles

I wanted to dig into the Factory pattern a bit. I was fighting the thought that conceptually, it’s just a class with methods, but that’s not entirely right. I think what I’m settling into is thinking of it as an object that has purpose. It’s not modeling something. It’s creating. It’s using a model, and[…]

May 7, 2025

Deploying PostgreSQL and pgAdmin4 to the Kubernetes Cluster

This semester featured MongoDB in a couple of classes. I’m guessing professors are gravitating to it because it’s relatively easy to get up and running with a cloud account on Atlas. I really enjoyed working with it, and I will probably toy with a local deployment. However, I wanted to deploy a PostgreSQL database to[…]

Posts Tagged: databases

Normalizing the Weight Tracker DB

Relationships in SQLAlchemy

Factory Pattern for Testing Roles

Deploying PostgreSQL and pgAdmin4 to the Kubernetes Cluster

Recent Posts