
Move permission checks out of the interface
Learn backend authorization with an organization wiki, scoped roles, direct endpoint tests and checks for alternate data paths.
The journal / Ideas in progress
Engineering & everyday learningSoftware, systems, and the things I’m learning along the way. From first principles to AI in production.
Find something to readA little theory. A lot of practice.

Learn backend authorization with an organization wiki, scoped roles, direct endpoint tests and checks for alternate data paths.

Compare repeated country codes and unique request IDs in real Parquet files, inspect dictionary metadata, and keep local array indices separate from stable identities.

Turn a vague CSV export fix into a bounded task with a failing example, data checks and clear handoff, while separating serialization from delivery and import.

Write the same twelve trips in two orders, inspect actual date statistics, and distinguish column projection, candidate row groups and measured query results.

A postal-address export demonstrates why line counts are not row counts. A worked analytical example with explicit assumptions and checked results.

Replay committed assignments, reject an unfinished tail, and expose the ordering failures that lose atomicity when home data or log deletion happens too soon.

Use RFC 9457 Problem Details for stable API errors, with field-level validation data, safe diagnostics and client behavior that survives wording changes.

Choose a programming project with fictional data and a repeatable reset, then add real-world constraints deliberately.

Assign boundary events exactly once with SQLite predicates, compare 23- and 25-hour local days, and separate late-arrival completeness from interval correctness.

Follow named-volume data through container recreation, distinguish mounts from backups and plan explicit data removal.

Read versioned preferences without startup rewrites, expose failed saves, preserve observed unknown records and test what storage events do across real tabs.

Count rows, submissions and observed ratings correctly with runnable SQL, an invitation denominator, empty cohorts and explicit missingness rules.