# Postmortem: Decimal Input Overflow in Calculator Application ## Summary A calculator application allowed users to input unlimited decimal digits via button presses despite UI-level safeguards. The attempted solution prevented duplicate decimal points but failed to enforce single-digit precision after the decimal separator in numeric inputs. ## Root Cause 1. Validation scope was incomplete: – … Read more
# Postmortem: Snowflake `COUNT_IF` Behavior vs. Documentation Discrepancy ## Summary – Snowflake’s `COUNT_IF` function returns `0` when no records meet the condition. – Official documentation claims it should return `NULL` in such cases. – Discrepancy confirmed via live testing of `COUNT_IF(1 != 1)` returning `0`. ## Root Cause – Implementation aligns with SQL’s `COUNT` aggregation … Read more
# Postmortem: Silent Failure in Google Sheets Macro Due to Missing Write Operation ## Summary A Google Sheets macro was created to add a value from cell B21 to cell B4. Despite correct value calculation, the updated result wasn’t saved because the script lacked a write operation to persist changes to the spreadsheet. ## Root … Read more
# Production Postmortem: Older Project Fails to Build Universal Binary for Apple Silicon ## Summary An Objective-C project migrated to Apple Silicon revealed compatibility issues: – Could only run under Rosetta emulation – Build system refused to target Apple Silicon (`arm64`) – Identified problematic third-party libraries (`libssl.a` and Crashlytics) – Build configuration showed `ARCHS_STANDARD` as … Read more
# Technical Postmortem: Book Ordering System Failure Due to Tight GUI-Coupling ## Summary A Python-based book ordering system implemented with Tkinter failed core separation requirements. The solution tightly coupled business logic with UI code, resulting in: – Invalid operation prevention failures – Validation logic duplication – Untestable core functionality – Rigid architecture resistant to change … Read more
# Autocomplete Error: USA Country Filter Returns Mexican Cities ## Summary – When users selected “United States” in a country-autocomplete field, the dependent city-autocomplete field incorrectly displayed Mexican cities – The app used Google Maps Legacy Place Autocomplete with country restriction parameters (`AutocompleteFilter`) – All tested countries (UK, France, Spain, Russia) worked correctly – error … Read more
Unexpected Behavior Analysis: git fetch origin master:master Does Not Update origin/master Summary Executing git fetch origin master:master failed to update origin/master despite fetching new commits The operation showed ! [rejected] master -> master (non-fast-forward) and created new tags FETCH_HEAD was successfully updated with the latest commit Running git fetch origin master later updated origin/master as … Read more
# Google Sheets Multiple Scripts: Resolving Conflicting `onEdit` Triggers ## Summary – Three separate functions named `onEdit` were implemented to handle spreadsheet edits – Conflicting trigger definitions caused only the final `onEdit` implementation to execute – Attempts to rename functions broke trigger registration while maintaining name collisions – Resolution required merging all logic into a … Read more
# `info.remote_addr()` – Method Not Found in warp::log::Info: A Production Postmortem ## Summary A compilation error occurred when using `info.remote_addr()` within `warp::log::custom`. The method `remote_addr` is absent in `warp::log::Info`, causing the Rust compiler to reject the code. The issue stems from API differences between Warp’s logging middleware and remote address extraction. ## Root Cause * … Read more
# Laravel Migration Rollbacks Fail to Trigger Model Deletion Events ## Summary – Model deletion events (`deleting`/`deleted`) are not triggered during Laravel migration rollbacks when using `Schema::drop()` or `Schema::dropIfExists()`. – This occurs because table dropping bypasses Eloquent model hooks and executes SQL-level `DROP TABLE` commands. – External API cleanup logic attached to model events fails … Read more