papanda925 - papanda925.com

Inspecting Column Structure with Power Query Table.Schema: Detecting Missing Required Columns Before Ingestion

Verify column names, positions, and types using Power Query M Table.Schema, and detect missing required columns using Table.HasColumns and List.Difference. Includes three dummy data examples and official specifications.

2026.10.12

VBA / Office

Aborting fetch in JavaScript with AbortController – Request timeout and cleanup

Demonstrating how to abort JavaScript fetch requests using AbortController with a Node.js localhost server. Also explains the differences between AbortError/TimeoutError and HTTP 500.

2026.10.12

Programming / Web Development

Tracking configuration sources with git config –show-origin: Precedence of system, global, and local

Where Git's user.name comes from. Using --show-origin and --show-scope in a temporary repository, explaining the difference between local and command, and addressing secrets in CI.

2026.10.12

Linux / CLI / DevOps

Standardizing Full-Width Alphanumeric Characters with PowerShell Unicode Normalization NFKC – A Non-Destructive Method for Source Data

Using .NET Normalize(FormKC) in PowerShell to unify full-width alphanumeric characters and half-width kana. Explains the differences from NFC and precautions regarding ID collisions.

2026.10.10

PowerShell

Comparing SQLite's PRAGMA quick_check and integrity_check: Detecting database corruption via read operations

Explores the differences between SQLite's quick_check, integrity_check, and foreign_key_check using an in-memory database, explaining why an 'ok' result can still miss foreign key violations.

2026.10.10

Programming / Web Development

Observing HTTP 103 Early Hints on localhost: Verifying the difference from 200 using Node.js and curl

What is the difference between HTTP 103 Early Hints and 200? Observe localhost communication using Node.js and curl. Explanations cover RFC 8297 and the boundary between preloads and final responses.

2026.10.10

Networking / RFC

Combining Multiple Tables with Excel HSTACK and VSTACK – Handling Empty Cells and Mismatched Column Counts

Compare through practical examples where #N/A occurs when combining tables with differing row or column counts using Excel HSTACK/VSTACK, and how to use IFNA.

2026.10.10

VBA / Office

Predicting next execution time with systemd-analyze calendar – Differences between OnCalendar and Persistent

Calculate the next execution time of a systemd timer without changing configurations. Review OnCalendar timezone specifications, Persistent, AccuracySec, and differences from actual services.

2026.10.10

Linux / CLI / DevOps

Safely replacing CSV files in Python: Preserving original data even if write fails mid-process

A practical example of safely updating CSV files in Python using tempfile and os.replace. It introduces code that preserves the original file even if an error occurs during writing, along with three unit tests.

2026.10.10

Programming / Web Development

Appending and Inspecting JSONL Logs Line by Line in PowerShell – How to Isolate Corrupted Lines

How to append JSON Lines (JSONL) without a UTF-8 BOM and validate them line by line in PowerShell 7. Using dummy events and invalid lines, we explain expected results, character encoding, and error handling precautions.

2026.10.10

PowerShell