Java Date Formatting Bug: YYYY vs yyyy ExplainedIn Java date formatting, uppercase YYYY represents the week-based year, while lowercase yyyy represents the calendar year. Using YYYY can cause dates in late December to print as the following calenda5h ago · 4 min readdoogal.dev
How GPS Works: Why Positioning Requires 4 SatellitesTL;DR: GPS is fundamentally a distributed network of atomic clocks broadcasting timestamps from space. Your phone calculates its location by measuring signal propagation delays. Because smartphone qua1d ago · 5 min readdoogal.dev
SQL NOT IN vs NOT EXISTS: Handling NULL Values SafelyQuick Answer: In SQL, using WHERE column NOT IN (SELECT ...) returns zero rows if the subquery contains a single NULL. This occurs because NOT IN expands to chained != operators joined by AND, and any54SVT2d ago · 5 min readdoogal.dev
Measuring Execution Time Safely with Monotonic ClocksQuick Answer: Measuring execution time using wall-clock functions like Date.now() or System.currentTimeMillis() can yield negative durations if your server synchronizes its clock mid-operation. To mea11S3d ago · 4 min readdoogal.dev
Why a Single Emoji Quadruples Python String MemoryTL;DR: CPython stores strings using PEP 393 (Flexible String Representation) rather than UTF-8. It selects a fixed width of 1, 2, or 4 bytes per character based on the widest character present. If an 4d ago · 5 min readdoogal.dev
