Skip to content

Revisions

  • 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 jqnatividad committed May 30, 2026
  • docs(geocode): document cache-* subcommands and %dyncols for opencage - Add the new `geocode cache-clear`/`cache-prune`/`cache-info` subcommands for managing the persistent on-disk OpenCage result cache. - Note `%dyncols:` support for the `opencage`/`opencagenow` subcommands. - Fix stale index-* docs: `index-info` does not exist (use `index-check`), and `index-load` takes a `.rkyv` file, not a Geonames zip. - Correct the cities5000 example (`index-update --cities-url`) and count. Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

    @jqnatividad jqnatividad committed May 21, 2026
  • Document geocode OpenCage, describegpt JSON Schema & sample VarOpt - Geospatial: new "Online geocoding with OpenCage" section, decision-table rows, updated geocode intro & subcommand count (7 -> 9) - Selection & Inspection: sample VarOpt + mergeable-reservoir + sketch I/O examples, method count 8 -> 10 - AI & Documentation: describegpt --format jsonschema section, x-qsv annotations, --allow-extra-cols / --strict-dates - Command Reference: refreshed sample, geocode & describegpt rows - Environment Variables: QSV_OPENCAGE_API_KEY - Recipes: OpenCage variation in Geographic Enrichment; describegpt JSON Schema variation in JSON Schema Validation Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

    @jqnatividad jqnatividad committed May 20, 2026
  • wiki: flesh out Conversion-and-IO + Geospatial + HTTP-and-Web Conversion-and-IO covers excel, to, json, jsonl, tojsonl, snappy, geoconvert (cross-ref), prompt, clipboard (cross-ref). Examples show Excel sheet selection by name/index, CSV -> Parquet with zstd, multi-CSV SQLite/PostgreSQL loads, Frictionless Data Package generation, smart JSONL type inference via the stats cache, multithreaded Snappy. Geospatial covers geocode + geoconvert in depth: forward/reverse geocoding, suggestnow/reversenow one-shot variants, IP lookup, country info, %dyncols output formatting for FIPS code enrichment, GeoJSON/SHP/KML/GPX conversions. Index setup walkthrough. HTTP-and-Web covers fetch + fetchpost with HTTP/2 flow control, RateLimit header awareness, four cache modes (memory/disk/Redis/none), MiniJinja templated POST bodies, GitHub stargazer fetch with --url-template, NOAA GHCN-Daily station data with --disk-cache, and a cache-strategy comparison table. Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

    @jqnatividad 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 jqnatividad committed May 13, 2026