Posts
JavaScript Basics: Use Symbol Keys without Mistaking Them for Privacy
String property names work well for everyday data. A Symbol gives a property a distinct identity when separate pieces of code need to attach information without accidentally …
October 21, 2026
JavaScript Basics: Keep the Right Receiver with this, call, and bind
A method can work when called on its object and fail when passed elsewhere as a callback. The difference is often its receiver: the value available as this. This tutorial makes …
October 21, 2026
JavaScript Basics: Choose Precise Strict Assertions
A test is only as useful as the claim its assertion actually makes. Identity, nested structure, and rejected promises need different checks. This tutorial examines those …
October 21, 2026
JavaScript Basics: Build Lazy Pipelines with Iterator Helpers
Array methods usually produce an array immediately. Synchronous iterator helpers can instead describe a transformation and pull values only when a consumer asks. This is useful …
October 21, 2026
JavaScript Basics: Attach Object Metadata with WeakMap
Sometimes you need information about an object without adding properties to it. A WeakMap stores that association separately and does not, by itself, keep an otherwise unreachable …
October 21, 2026
SQLite Basics: Reuse Queries with Views
A view gives a query a reusable name. Use one for a repeated filter or report, then select from it like a table. A normal view saves the query definition, not a frozen copy of the …
October 20, 2026
SQLite Basics: Inspect Indexes with EXPLAIN QUERY PLAN
An index gives SQLite another way to find rows. EXPLAIN QUERY PLAN shows the chosen access strategy. Use these small examples to read a plan before measuring performance with …
October 20, 2026
SQLite Basics: Combine and Compare Lists with Set Operations
Compound queries combine result rows from separate SELECT statements. UNION combines lists, INTERSECT finds their overlap, and EXCEPT finds what is missing from the second list. …
October 20, 2026
SQLite Basics: Choose Labels and Sort Priorities with CASE
CASE chooses a result inside a query. It is useful for readable labels, ordered rules, and a business-specific sort order. The examples below keep the stored data unchanged. …
October 20, 2026
SQLite Basics: Check for Related Rows with EXISTS
Use EXISTS when a report needs to know whether a related row is present. These examples select customers with orders, find missing matches, and add a yes-or-no flag without …
October 20, 2026