A place for code I want to explain, mistakes worth remembering, and the occasional story from my life.
Laravel 2 min read
Two transactions acquire rows in different orders and one is selected as a deadlock victim. A bounded retry can be appropriate, but the transaction callback may run again. Anything...
Laravel 2 min read
A profile PATCH request may omit a biography to leave it unchanged, or send null to clear it. Treating both cases as identical can erase existing text when a client only intended t...
Laravel 2 min read
A download link carries a valid signature, but the file is still private to one account. A signature proves that the signed URL has not been modified according to the application's...
Laravel 2 min read
A custom login screen checks credentials successfully, but the implementation stops immediately after authentication. A successful login should also rotate the session identifier s...
Laravel 2 min read
Returning a model directly is convenient until a new database column appears in the JSON response. An API resource gives the public contract an explicit place to live rather than i...
Laravel 2 min read
A growing activity feed becomes slow with deep offset pages. Cursor pagination can help, but it needs an ordering that identifies where the next page begins. A nonunique timestamp...
Laravel 2 min read
A cleanup job reads unprocessed rows in chunks and marks each chunk processed. Offset pagination can skip rows because the set shrinks between queries. The second offset is applied...
Laravel 2 min read
Two requests try to rebuild the same expensive report. A cache lock can avoid duplicate work, but the caller must decide what to do when it cannot acquire the lock promptly. Bound...
Laravel 2 min read
A dashboard caches its monthly totals under dashboard:month. The first tenant warms the key; the second tenant receives the same value. The database query may be correctly scoped w...