Posts
JavaScript Basics: Label Language and Region Codes with Intl.DisplayNames
A language selector should store a stable code such as ko while showing a label a reader understands. Intl.DisplayNames converts supported language, region, and other codes into …
October 25, 2026
JavaScript Basics: Inspect Directory Entries with opendir
A directory scan needs more than a list of names when files, subdirectories, and symbolic links require different handling. Node’s opendir returns a directory stream whose entries …
October 25, 2026
JavaScript Basics: Describe Relative Times with Intl.RelativeTimeFormat
A status display often needs “3 minutes ago” rather than a full timestamp. Intl.RelativeTimeFormat supplies the language and number formatting. Your application still chooses the …
October 25, 2026
SQLite Basics: Match Queries to Expression Indexes
Filtering on a calculated value does not have to mean storing that value as a separate application-maintained column. SQLite can index an expression such as lower(code) or …
October 24, 2026
SQLite Basics: Inspect Tables, Columns, and Indexes with SQL
Before changing an unfamiliar database, inspect its structure. SQLite exposes schema metadata through sqlite_schema and table-valued PRAGMA functions, so you can filter and order …
October 24, 2026
SQLite Basics: Index Selected Rows with Partial Indexes
An application may keep years of completed jobs while repeatedly looking up a small active queue. A partial index stores entries only for rows that satisfy its WHERE condition. It …
October 24, 2026
SQLite Basics: Build Conditional Reports with Aggregate FILTER
A dashboard often needs several totals from the same rows: all tickets, open tickets, and completed work. An aggregate FILTER clause gives each calculation its own condition …
October 24, 2026
SQLite Basics: Avoid Surprises in Integer and REAL Arithmetic
A percentage query can return zero even when work is partly complete. In SQLite, division between two integer values produces an integer result, while a REAL operand selects …
October 24, 2026
Python Basics: Parse and Build MIME Messages with email
An email archive contains more than a block of text: headers can repeat, subjects can be encoded, and one message can contain several bodies or attachments. Python’s email package …
October 24, 2026
Python Basics: Inspect Comments and Tokens with tokenize
A source-maintenance tool sometimes needs details that a syntax tree leaves out, especially comments and the spelling of literals. tokenize exposes those lexical pieces without …
October 24, 2026