Posts
JavaScript Basics: Run Small Commands with execFile
A Node.js script sometimes needs a result from another executable. execFile runs a program with a separate argument list and collects its output. These examples launch the current …
October 23, 2026
JavaScript Basics: Measure Work with Performance Marks
A performance mark records a moment, and a measure describes the elapsed interval between moments. Naming those boundaries makes timing code easier to inspect than scattered clock …
October 23, 2026
JavaScript Basics: Exchange Data with Worker Threads
A worker thread runs JavaScript separately from the main thread. It can keep substantial CPU work away from the main event loop, but starting a worker and moving data also cost …
October 23, 2026
JavaScript Basics: Compress Small Buffers with zlib
Compression changes a byte sequence into another representation that can be restored later. Node.js supplies gzip and Brotli through node:zlib. These examples stay in memory and …
October 23, 2026
JavaScript Basics: Carry Request Context with AsyncLocalStorage
Passing a request ID through every function can clutter otherwise small APIs. Node.js AsyncLocalStorage lets asynchronous work retrieve the context associated with its execution. …
October 23, 2026
SQLite Basics: Read and Update JSON Documents
An API response may contain optional settings or a list of tags that you want to inspect with SQL. SQLite’s JSON functions let you read those values without exporting every row to …
October 22, 2026
SQLite Basics: Page Through Rows with Composite Cursors
A next-page button needs a stable place to continue. Keyset pagination records the last displayed sort key and asks for rows after it, rather than skipping a growing number of …
October 22, 2026
SQLite Basics: Enforce Storage Types with STRICT Tables
An ordinary SQLite column’s declared type does not reject every value of a different type. STRICT tables make that boundary firmer when an application expects consistent integers, …
October 22, 2026
SQLite Basics: Choose Text Comparison Rules with Collations
Text that looks similar to a person does not always compare equal in a database. A collation defines the comparison rule used for text equality and ordering. Choose that rule …
October 22, 2026
SQLite Basics: Add, Rename, and Remove Table Columns
A schema often needs to evolve after rows already exist. SQLite’s ALTER TABLE handles several common changes without asking you to export and reload every column yourself. Start …
October 22, 2026