How Base64 turns bytes into text, why it hides nothing, how to handle accents and emoji correctly and when you need the URL-safe alphabet.
November 5, 20265 min readTool: Base64 Encoder/Decoder
Why a short regular expression can take seconds or hang a page, how to recognize nested quantifiers and how to rewrite the pattern so it stays fast.
November 5, 20266 min readTool: Regex Tester
How to turn a pasted column of values into a JavaScript or Python list, a SQL IN clause or CSV, with quoting, duplicates, empty lines and large lists handled safely.
November 5, 20265 min readTool: Column to Array
Trailing commas, single quotes, comments, unquoted keys and other reasons a JSON document is rejected, with the exact fix for each one.
November 5, 20265 min readTool: JSON Formatter
What the three parts of a JSON Web Token mean, how to read claims like exp and iat, and why a decoded token proves nothing until you verify it.
November 5, 20266 min readTool: JWT Decoder
How to lay out SELECT, JOIN, WHERE and CTEs so queries are easy to read and review, why the dialect matters when formatting, and the habits that prevent bugs.
November 5, 20265 min readTool: SQL Formatter
The difference between a time zone and a UTC offset, why the gap between two cities changes during the year, and how to store and convert times safely.
November 5, 20266 min readTool: Time Zone Converter
How to turn a JSON response into TypeScript types, when to choose interface or type, and what a type inferred from one sample can and cannot promise.
November 5, 20265 min readTool: JSON to TypeScript
What a Unix timestamp is, how to tell seconds from milliseconds by the number of digits, and how to convert it in JavaScript, Python and SQL without fuzzy dates.
November 5, 20265 min readTool: Unix Timestamp Converter
What the parts of a UUID mean, why v4 collisions are not a real concern, how to store UUIDs in a database and when a time-ordered UUID v7 is the better choice.
November 5, 20265 min readTool: UUID Generator