Posts
JavaScript Basics: Understand Microtask Ordering and Batch Small Updates
queueMicrotask() schedules a callback after the current synchronous work finishes, before the event loop moves on to a later task. Promise reactions also use the microtask queue. …
October 22, 2026
JavaScript Basics: Process Template Literals with Tags
A tagged template passes its literal text and interpolated values to a function separately. The function decides how to combine them and can return something other than a string. …
October 22, 2026
JavaScript Basics: Make Object Operations Explicit with Reflect
The Reflect object exposes operations such as reading, writing, and construction as functions. That is useful when keys or constructors are selected at runtime, or when a helper …
October 22, 2026
JavaScript Basics: Intercept Object Operations with Proxy
A Proxy places handlers around selected object operations. It can observe reads, validate assignments, or provide a temporary view that can later be revoked. Reach for an ordinary …
October 22, 2026
JavaScript Basics: Follow Prototype Delegation and Property Shadowing
A prototype supplies properties that an object does not have itself. This is delegation through a live object link, rather than a one-time copy. Understanding that link explains …
October 22, 2026
SQLite Basics: Walk Sequences and Trees with Recursive CTEs
A recursive common table expression starts with a small result and repeatedly derives more rows from it. Use one for a sequence, a hierarchy, or reachable nodes in a graph. Unlike …
October 21, 2026
SQLite Basics: Record Row Changes with Triggers
A trigger runs SQL automatically when a table changes. It can keep a small change log consistent even when several application paths write to the same table. These examples use …
October 21, 2026
SQLite Basics: Read Changed Rows with RETURNING
RETURNING lets an INSERT, UPDATE, or DELETE produce result rows. It is useful when the application needs an assigned ID or the value produced by a write, without a separate lookup. …
October 21, 2026
SQLite Basics: Normalize Dates and Measure Elapsed Time
SQLite has date/time functions but no dedicated date/time storage type. A useful first step is choosing one representation and a timezone policy. These examples use fixed …
October 21, 2026
SQLite Basics: Derive Values with Generated Columns
A generated column keeps a calculation beside the data it describes. Instead of repeating an expression in every query or remembering to update a second value, write the rule in …
October 21, 2026