SiegMetro Cebu · 10°18′N
A second brain, kept in public
If I can't explain it plainly, I don't understand it yet.
Sieg is a software engineer in Metro Cebu, Philippines. TypeScript, the web, Postgres, and Linux. Everything here is a note to self that turned out to be worth publishing.
Latest entries
Full indexKeys and Types the Database Can Actually Check
My status columns were text with a TypeScript union on top, and my ids came in three kinds. What Postgres enforces, what it only pretends to, and what I changed.
· 5 min · postgres
5 minWhat Should Disappear When a User Is Deleted?
Every foreign key forces a decision about deletion. I went through MetaMove's tables one by one: cascade, restrict, or set null, and where none of them is the right answer.
· 6 min · postgres
6 minMy Claude Code Status Line Is a Mod Now
My status line was a bash script that printed a line of text. Now it's a Claude Code mod with live gauges. What a mod is, how to build a small one, and what tripped me up.
· 23 min · claude-code
23 minOne Table Doing Two Jobs
member_assignments was my roster and my plan assignment at the same time. Two facts in one row gave the database two ways to be wrong, and a copy-pasted twin table made it worse.
· 6 min · postgres
6 minMy Junction Table Had an Id and No Foreign Keys
Auditing one table in my fitness app taught me when a many-to-many table deserves its own id, why Drizzle relations are not constraints, and what rule the table actually needed.
· 7 min · postgres
7 min
Now
Relational database design, properly this time. Functional programming as a refresher. Postgres, Docker, and Linux administration.