Page 5 - Monthly Archives: September 2025

Codegen turns a TypeScript spec file into the single source of truth for a TurboModule, generating matching interface code for iOS and Android at build time. This article walks through what codegen actually does, how a new TurboModule spec comes together in practice, and which class of bugs disappears entirely compared to hand-written bridging declarations.

Conditional aggregation is one of the most common needs in reporting queries: how many orders are cancelled, how many completed, how many still open, all in a single row per group. The classic path there runs through COUNT combined with a CASE WHEN expression that returns either a value or null depending on the condition. The SQL standard has offered a noticeably clearer alternative for a while now: the FILTER clause, attached directly to the aggregate function. This article covers how FILTER works, why it beats CASE WHEN for readability in many cases, how it combines with window functions for several parallel metrics, and where database availability draws the line.

Setting canonical tags incorrectly on a Magento store wastes ranking signals and creates duplicate content problems through filter URLs, sorting parameters, and products assigned to multiple categories. This article explains how rel canonical actually works as a hint for Google, when a 301 redirect or noindex is the right choice instead, and how to override Magento's default canonical behavior when needed.

INP breaks down into three measurable phases that most performance guides only cover on the surface. This deep dive examines input delay, processing time, and presentation delay individually, explains the role of third party scripts and Alpine.js reactivity in Hyva stores, and walks through the Chrome DevTools Performance panel to show exactly how long tasks get found and fixed.

A single stolen admin password today is enough to cause total damage in a Magento backend. This article shows how TOTP per RFC 6238, hashed backup codes, and phishing resistant WebAuthn/FIDO2 are implemented correctly at the technical level, and how Magento's native Two-Factor Auth module can be enforced for every admin user to close this gap.

Declarative Schema replaces old InstallScripts, but only when tables, constraints, indexes, and patches are kept cleanly separated. These five mistakes cause most of the problems in Magento projects.

Offset pagination with OFFSET and LIMIT looks simple at first glance, but returns shifted, duplicate, or skipped entries once the underlying data changes between two requests. Cursor-based pagination (also called keyset pagination) fixes this structurally by anchoring every page to an actual record instead of a numeric position, through an opaque token built from a sort key and a unique id.

Replacing REST endpoints is not the goal of GraphQL, the goal is to load exactly the data a component needs and cache it at the right moment. Anyone running Vue GraphQL without a cache strategy loads the same data over and over and loses the biggest advantage of the approach.

One thread per connection works well as long as the number of concurrent connections stays modest. Once PHP-FPM pools or similar setups generate thousands of parallel connections, that model tips over and the server loses throughput instead of gaining it. The thread pool plugin deliberately caps how many threads actually run at once.

Snapshot testing promises to automatically catch every unintended change to a component. In practice, huge, unreadable snapshots are often blindly updated with a keystroke instead of being investigated for real regressions. This article shows where snapshot testing genuinely helps and where targeted assertions and small inline snapshots bring far more confidence.