Parsing file formats, databases, data mining, and enrichment.
Three unrelated jobs share the name data normalization: relational normal forms, canonicalization of values, and feature scaling for models. How to tell which is meant, and what fails in each.
PHP bulk insert with prepared statements and rollback: timings for three methods on 20,000 rows, the 65,535-placeholder ceiling, and six cases where the rollback quietly does nothing.
Adjacency list, materialized path, nested set and closure table measured against each other on the same 100,000-node tree in PostgreSQL 16: subtree reads, ancestor lookups, the direct-children query most comparisons skip, and what a single leaf insert costs in each. Checked against vendor documentation in August 2026.
Every document format in one place, with numbers read from primary sources on 10 August 2026: current library versions, Textract and Document AI prices per 1,000 pages, hard API page limits, and a timed comparison of five PDF text extractors on the same file.
No-code chart and map tools for scraped data, with August 2026 prices, documented row and file limits, and data residency for each.
Find duplicate rows in SQL and print their ids: GROUP BY and ROW_NUMBER recipes checked against MySQL 8.4, PostgreSQL 18, SQL Server 2025 and Oracle 26ai docs in August 2026, with the id-list truncation limits and measured delete timings.
Frequent itemset mining with measured numbers: Apriori against FP-Growth and H-Mine on 50,000 baskets, how many rules pure noise produces, why Spark runs PFP and not SON, and every library version read from its own registry on 13 August 2026.
How data mining serves business analytics: the CRISP-DM cycle and where it stalls, six techniques and the mistake each one invites, and every Google analytics service rechecked in August 2026 with real limits and prices, from 14-month event retention in GA4 to BigQuery at $6.25 per TiB.
How CSV parsing breaks, measured on 13 August 2026: BOM, delimiter and ragged-row behaviour across Python, pandas 3.0.2, Papa Parse 5.5.4, PHP 8.4.21, Go and DuckDB, with throughput numbers.