New options for analyze-tables --common-limit --no-most and --no-least

[simonw]

The "least common" section is frequently uninteresting, especially for huge tables with a large number of repeated-once values.

sqlite-utils analyze-tables content.db repos --common-limit 20 --no-least

[simonw]

I generated the commit message in https://github.com/simonw/sqlite-utils/commit/1c1991b447a1ddd3d61d9d4a8a1d6a9da47ced20 using git diff | llm --system 'describe this change'.

[simonw]

New docs:

• https://sqlite-utils.datasette.io/en/latest/cli.html#cli-analyze-tables
• https://sqlite-utils.datasette.io/en/latest/cli-reference.html#analyze-tables
• https://sqlite-utils.datasette.io/en/latest/python-api.html#analyzing-a-column
• https://sqlite-utils.datasette.io/en/latest/reference.html#sqlite_utils.db.Table.analyze_column

New help output:

 % sqlite-utils analyze-tables --help
Usage: sqlite-utils analyze-tables [OPTIONS] PATH [TABLES]...

  Analyze the columns in one or more tables

  Example:

      sqlite-utils analyze-tables data.db trees

Options:
  -c, --column TEXT       Specific columns to analyze
  --save                  Save results to _analyze_tables table
  --common-limit INTEGER  How many common values
  --no-most               Skip most common values
  --no-least              Skip least common values
  --load-extension TEXT   Path to SQLite extension, with optional :entrypoint
  -h, --help              Show this message and exit.