A few months ago I sat down to add "loyalty points" to Glazed, my waffle kiosk brand. Simple, right? Add a points column to the users table, increment it on checkout, done by lunch.

Three weeks and six tables later, I had something that looks less like a points system and more like a tiny accounting engine. 🧾

Here's why it ended up that way —...