Historical data analysis when MySQL runs out of room
Running decades of data through wp_postmeta will take your server down. Here is how I structured a 500 million row temperature dataset as an OLAP schema and queried it with MDX instead of raw SQL.
Tag: APIs
What 2025 changed about WordPress Playground
WordPress Playground spent 2025 getting 42% faster and reaching 99% compatibility with the top 1,000 plugins. Here is what changed in Blueprints and database support, and why it now works for real testing.
Transformer high-norm artifacts and the Softmax bottleneck
High-norm spikes in Vision Transformers come from Softmax, not from bad training data. Here is why the sum-to-1 constraint turns background tokens into attention sinks, and what registers, sigmoidal gating and self-distillation actually do about it.
Human-centered data analytics starts with a decision
Most reporting tools get built because someone asked for data, not because anyone had a decision to make. Here is how I pick which metrics are worth building, why clarity beats accuracy, and where ethics fits in before the first line of SQL.
WooCommerce REST API special characters: what 10.5 fixes
WooCommerce 10.5 fixes two decoding bugs that broke Arabic, Persian and Chinese attribute names and values on variation writes. What changed, how to test it with cURL, and which old workarounds to pull out.
Production ML failures usually start in the data, not the model
Perfect offline metrics mostly prove the model fits your assumptions. Point-in-time joins, zero-filled features the model reads as a signal, and cohorts that change while the histograms hold still.
Federated learning: train the model where the data lives
Instead of hauling data into one bucket, federated learning sends the model to the device and gets weights back. A look at FedAvg in NumPy, horizontal vs vertical setups, and the non-IID problem.
The CSS :drag pseudo-class and the JavaScript it replaces
Notes on the proposed CSS :drag pseudo-class and ::drag-image pseudo-element, and how they replace the dragstart and dragend listeners we currently use to style drag states in WordPress UIs.
How WooCommerce 10.5 picks a product permalink category
WooCommerce 10.5 changes which category ends up in a product URL: the deepest one in the hierarchy now wins instead of the lowest term ID. Here is what that does to existing URLs and how to put the old sorting back.
Building an AI language tutor with n8n and multimodal models
How I built a Mandarin tutor on n8n: audio in through a webhook, transcription with pinyin, Gemini for the pronunciation feedback, and ElevenLabs for the voice. It runs under 1 euro a month.