Posts
JavaScript Basics: Handle Fetch Responses with a Local HTTP Server
A successful fetch call does not by itself mean an HTTP request succeeded or that its JSON has the shape you expected. Use a tiny local server to practice checking status, …
October 24, 2026
JavaScript Basics: Build and Read Immutable Blobs
A Blob packages bytes without exposing a writable view of its contents. It is useful when an API expects a single binary object assembled from strings or typed arrays. Start with …
October 24, 2026
JavaScript Basics: Add Optional Diagnostics Channels
A library can report useful events without deciding where to log them. Node.js diagnostics_channel connects a named publisher to optional subscribers in the same runtime. Use it …
October 24, 2026
PHP2Shell: The Timeline Behind PHP's October 21, 2026 Disclosures
On October 21, 2026, PHP published emergency releases addressing CVE-2026-109618 and CVE-2026-109619, collectively discussed as PHP2Shell. Both carry a CVSS v4.0 score of 9.2, …
October 23, 2026
PHP's October 21, 2026 Security Updates: What to Patch and Verify
PHP released security updates on October 21, 2026 for two vulnerabilities that can allow unauthenticated remote code execution. Update the runtime, not just application …
October 23, 2026
SQLite Basics: Search Documents with FTS5
A notes application often needs to find words across both a title and a body. SQLite’s FTS5 extension provides a searchable virtual table for that job. These examples build a small …
October 23, 2026
SQLite Basics: Query Separate Database Files with ATTACH
Sometimes an import, archive, or lookup catalog lives in another SQLite file. ATTACH makes that database available to the current connection under a schema name, so a query can use …
October 23, 2026
SQLite Basics: Create Compact Database Copies with VACUUM INTO
VACUUM INTO writes a compact copy of a SQLite database to a new file while leaving the source database unchanged. It is useful for rehearsing exports and checking a snapshot before …
October 23, 2026
SQLite Basics: Clean and Split Text with Core Functions
Imported labels and compact references often need small, inspectable transformations. SQLite’s trim(), instr(), substr(), and replace() functions can perform those operations …
October 23, 2026
SQLite Basics: Choose Natural Keys with WITHOUT ROWID
A stock record identified by warehouse and product already has a useful key. SQLite’s WITHOUT ROWID option lets a table use its declared primary key as its storage key rather than …
October 23, 2026