Tech Notes
52 articlesUnix timestamps that do not match the date: seconds, milliseconds and time zones
An order timestamp showing 1970 usually means a 10-digit seconds value and a 13-digit milliseconds value were mixed up. This note walks through digit count, time zone and boundary checks, with language-specific examples and notes on the 2038 overflow.
Inside the Notes section: tool tests, lessons learned and a category guide
The Notes section holds 58 articles across tech notes, life essays and resources. This page explains how articles differ from tool pages, what each category covers, and how to search by problem when you cannot recall a tool name.
Missing comma in JSON? Locating the error, minifying and escaping
Hand-written JSON configs throw syntax errors with no obvious location, and API responses often arrive minified into one line. This note covers common invalid forms, the exact error messages two tools produce, how to convert line and column numbers, and measured indentation size differences plus escaping layers on a 191-key sample.
Auto-increment IDs leak order volume: the real cost of switching to UUID
Auto-increment IDs expose business volume, but UUIDs bring collision odds and index storage costs. This note covers 122 random bits, birthday-bound collision math, how v4 differs from v1, and how to choose a primary key.