wiki: adopt GitHub Alerts for callouts across the wiki Convert advisory blockquotes and inline callouts to semantic GitHub Alerts (NOTE/TIP/IMPORTANT/CAUTION): - [!NOTE] for the standard category-page "workflow layer" ledes and other top-of-page orientation / "canonical reference" notes - [!IMPORTANT] for behavior-affecting gotchas (auto approx-stats on OOM, group-by unsupported aggs, MiniJinja filter-errors-as-values, synthesize cross-column correlation, profile always-warn RFC4180) - [!TIP] for the Binary-Variants TL;DR and Why-qsv "why it matters" - [!CAUTION] for foreach shell-injection risk and joinp --cross blowup Also update the Contributing-to-the-Wiki category template to use the [!NOTE] lede so new pages follow the convention. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

jqnatividad committed May 30, 2026

wiki: expand pivotp section with detailed examples Restructure the SQL-and-Polars pivotp coverage into workflow subsections drawn from src/cmd/pivotp.rs USAGE: pivot vs group-by mode mechanics, multi-column on/values + --col-separator, full --agg function table (first/last/sum/min/max/mean/median/quantile@p/len/item/smart), how smart aggregation reads the stats/moarstats caches, --grand-total/ --subtotal/--total-label, and --maintain-order/--sort-columns/--validate/ parsing + pschema.json behavior. Notes CSV-only output and that stdin, --agg item/none, --subtotal, --sort-columns, and --validate are unsupported in group-by mode. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

jqnatividad committed May 30, 2026

wiki: expand sqlp section with detailed Polars SQL examples Restructure the SQL-and-Polars sqlp coverage into workflow subsections drawn from src/cmd/sqlp.rs USAGE: table naming/stdin/directory inputs, multi-format table functions + SKIP_INPUT, joins & set ops, pattern/ regex/comparison operators, expressions & FILTER aggregates, CTEs & window functions, multi-query SQL scripts, output formats/compression, schema caching & type casting, and EXPLAIN/perf debugging. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

jqnatividad committed May 30, 2026

docs(wiki): update for qsv 20.1.0 — "Synthetic Data" release - AI & Documentation: add synthesize section; expand describegpt with Content Types (47-token vocab), --two-pass cross-field refinement, deterministic unique_id tag, --markdown-template, lower-LLM-cost notes - Aggregation & Statistics: document auto-fallback to approximate modes on OOM (stats: --quantile/cardinality-method approx; frequency: --sketch-method frequent_items) with little-endian gating - Recipe-Larger-than-RAM: reframe explicit approx flags as auto-on-OOM (override-to-lock semantics) with stats cache mode-key note - SQL & Polars: pivotp --agg quantile@<p> / q@<p> with p95 example - Command Reference: add synthesize row in AI & Documentation table - Cookbook: new "Generate" section; new Recipe-Synthesize-Fake-Data.md with end-to-end describegpt --two-pass --infer-content-type → synthesize walkthrough, locale switching, --consistent-fakes variant, caveats - Sidebar: link the new Synthesize Fake Data recipe - Home: bump "70+ commands" → "73 commands across four binary variants"; add 20.1.0 highlight strip with deep-links - FAQ: refresh MSRV anchor 20.0.0 → 20.1.0 (Rust 1.95 unchanged) - Troubleshooting: link both 20.0.0 and 20.1.0 changelogs in excel section Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

jqnatividad committed May 18, 2026

wiki: flesh out SQL-and-Polars + Validation-and-Schema SQL-and-Polars covers sqlp, scoresql, pivotp, with cross-reference to joinp. Examples: aggregate NYC 311 by Borough x Month -> Parquet, join wcp.csv with country_continent.csv, UNION ALL across yearly exports + window function, dollar-quoting, read_parquet inline, score-before-run warnings and DuckDB plan mode, pivot Allegheny property sales. Validation-and-Schema covers validate, schema, sniff. Highlights the 780k rec/sec validate benchmark, the three custom keywords (currency, dynamicEnum, uniqueCombinedWith), and the schema -> validate workflow loop. Polars schema (.pschema.json) explained as the speed-up feeder for sqlp/joinp/pivotp. Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

jqnatividad committed May 13, 2026

wiki: add stubs for Phase B/C/D/E pages so sidebar links resolve Adds 39 placeholder pages so every sidebar entry resolves to real content rather than a 404. Each stub declares its tier, the phase it will be filled in, and a one-paragraph preview of what's coming. They link back to Home / Getting-Started / Command-Reference / Cookbook for navigation. Pages added: - Phase B (Command Reference, 13): Command-Reference, Selection-and- Inspection, Transform-and-Reshape, Aggregation-and-Statistics, Joins- and-Set-Ops, SQL-and-Polars, Validation-and-Schema, Conversion-and-IO, Geospatial, HTTP-and-Web, Scripting-Luau-Python, Indexing-Compression- Diff, AI-and-Documentation - Phase C (Cookbook recipes, 12): Recipe-Inspect-Unknown-CSV, Recipe- Clean-and-Normalize, Recipe-Geographic-Enrichment, Recipe-Date- Enrichment, Recipe-CKAN-Integration, Recipe-JSON-Schema-Validate, Recipe-Build-a-Data-Pipeline, Recipe-Stats-to-Insights, Recipe-Fetch- and-Cache, Recipe-Larger-than-RAM, Recipe-Diff-and-Audit, Recipe-Multi- Table-Joins - Phase D (Tuning + ecosystem, 8): Performance-Tuning, Environment- Variables, Stats-Cache-and-Caching, Lookup-Tables, Claude-Cowork-Plugin, MCP-Server, qsv-pro-Spotlight, Integrations - Phase E (Polish, 6): Troubleshooting, FAQ, Comparison, Glossary, External-Resources, Contributing-to-the-Wiki Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

jqnatividad committed May 13, 2026