Developer & Data
Read an IPv4 Subnet’s Range and Usable Addresses
A prefix length describes how much of an IPv4 address belongs to the network. The resulting block can include addresses reserved for…
Category: Developer & Data
Developer & Data
Prepare SQL Inserts From CSV for Manual Review
A CSV to SQL conversion is useful for a small fixture or controlled import. The generated statements still need review, particularly where…
Developer & Data
Read a JWT Payload Without Treating It as Verified
A decoded token can look convincing because its header and claims are readable. Readability is not authentication. Someone can change a payload…
Developer & Data
Test Small Regular Expressions With Bounded Matches
A regular expression can match exactly what you expected in one example and behave badly in another. Testing a short pattern against…
Developer & Data
Convert Opaque Colours Between HEX, RGB and HSL
A design specification may list a colour in HEX while an editor asks for RGB or HSL. The colour can be represented…
Developer & Data
Tell Decimal File Units Apart From Binary Units
A file allowance described as MB can be confused with MiB. The names refer to different multipliers, so the same written quantity…
Developer & Data
Convert Large Integers Between Number Bases
A long integer can lose precision if it is converted through a floating point number. That is a problem when you are…
Developer & Data
Convert Pakistan Time Without Guessing DST Offsets
An interview at 14:00 in Karachi and a meeting at 14:00 in London are not scheduled for the same instant. Timezone conversion…
Developer & Data
Convert Unix Timestamps With the Correct Unit
A timestamp with three extra digits can describe the same instant in milliseconds rather than seconds. Reading it with the wrong unit…
Developer & Data
Generate Random UUIDs for New Records
A record identifier should not depend on the next person guessing a sequence. A random UUID offers a convenient identifier format when…