How to make a SQL query on a field which can be NULL and values, and only chose the largest value if possible

by

# Postmortem: Incorrect Handling of NULL in SQL MAX Queries ## Summary An incorrect SQL query attempted to retrieve records with the largest non-NULL value in column `fd`, falling back to NULL values when no non-NULL data existed. The query failed due to improper NULL handling in comparison logic, yielding no results when NULL values … Read more

Django Docker production solutions

by

# Production Incident: Worker Timeouts After Migrating Django App From runserver to Gunicorn ## Summary A Django application migrated from `runserver` to Gunicorn in Docker production experienced intermittent HTTP worker timeouts (`WORKER TIMEOUT`), resulting in incomplete data processing during TMDB API integrations. Development server worked without issues. Quick fix was reverting to `runserver`. ## Root … Read more

How to programmatically scroll to the top of a lengthy text in a customized JDialog?

by

# Postmortem: JDialog Scroll Position Misfire When Displaying Lengthy Text ## Summary A customized `JDialog` designed to display lengthy text consistently opened scrolled to the bottom despite multiple attempts to programmatically reset the scroll position to the top. Attempted solutions like setting view position, scrollbar value, and `scrollRectToVisible` failed to correct initial positioning. ## Root … Read more

Change all relative paths

by

# Postmortem: Improper Relative Path Rewriting Caused Broken Asset Loading ## Summary A user script (Tampermonkey) was deployed to rewrite relative paths on a web page to point to a new domain (`www.mypage.com`). Absolute paths were meant to be preserved. The script incorrectly modified some absolute paths and mishandled relative path resolution, causing CSS/JS files … Read more

How to set journaling mode in Python 3.12 and Sqlite3 with autocommit=False

by

# How to Set Journaling Mode in Python 3.12 and SQLite3 with autocommit=False ## Summary Attempts to set SQLite’s journaling mode (e.g., `PRAGMA journal_mode = WAL`) fail with `OperationalError` when opening a connection with `autocommit=False` in Python 3.12. This occurs because an implicit transaction starts immediately, preventing journal mode changes within a transaction. ## Root … Read more

Initializer for saving request data with uninitialized constant

by

# Initializer for Saving Request Data with Uninitialized Constant ## Summary A Rails initializer attempted to subscribe to controller events using `ActiveSupport::Notifications` and create `RequestLog` records. The `RequestLog` constant was unavailable during initialization, causing `NameError: uninitialized constant RequestLog` failures. ## Root Cause – The `request_logging.rb` initializer executes **before** Rails loads application classes – `RequestLog` model … Read more

Blazor project from standard template errors after edit

by

# Blazor Web App Edit Failure After Template Modification ## Summary After modifying a Razor component in a newly created Blazor Web App project from the standard template, the application fails to execute correctly during debugging. Static content renders partially, but interactive features break due to JavaScript module loading failures with MIME type errors. Manually … Read more

Ai is the replacer of Web developer

by

The Disruption: AI’s Impact on Web Developer Roles Summary Industry buzz about AI replacing human web developers caused significant anxiety among aspiring developers. Discussions escalated after multiple AI tools demonstrated rapid scaffolding and prototyping capabilities, creating perception challenges about career viability. Root Cause Cognitive bias toward visible automation outputs (code generation) without contextual awareness Overestimation … Read more

Is there an official API or SDK to integrate Sham Cash with a Flutter mobile app?

by

# Postmortem: Payment Integration Failure Due to Unavailable Sham Cash Flutter SDK ## Summary – Attempted to integrate Sham Cash payment functionality into a Flutter app – Assumed existence of official SDK based on industry-standard providers – Discovered post-development that Sham Cash lacks public API/SDK documentation – Integration stalled, requiring redesign and vendor change ## … Read more

Bazel build fails when generating OpenVINO Test Drive Windows bindings (MSVC toolchain / DLL errors)

by

Bazel Build Fails When Generating OpenVINO Test Drive Windows Bindings: Solving MSVC Toolchain and DLL Errors ## Summary **Windows developers compiling OpenVINO Test Drive bindings with Bazel frequently encounter MSVC toolchain errors and DLL version mismatches**, especially when using Visual Studio Build Tools. These failures typically manifest as missing `opencv_world*.dll` files or protobuf compilation crashes. … Read more