- New experimental
sqlite-utils tui
interface for interactively building command-line invocations, powered by Trogon. This requires an optional dependency, installed usingsqlite-utils install trogon
. There is a screenshot in the documentation. (#545) sqlite-utils analyze-tables
command (documentation) now has a--common-limit 20
option for changing the number of common/least-common values shown for each column. (#544)sqlite-utils analyze-tables --no-most
and--no-least
options for disabling calculation of most-common and least-common values.- If a column contains only
null
values,analyze-tables
will no longer attempt to calculate the most common and least common values for that column. (#547) - Calling
sqlite-utils analyze-tables
with non-existent columns in the-c/--column
option now results in an error message. (#548) - The
table.analyze_column()
method (documented here) now acceptsmost_common=False
andleast_common=False
options for disabling calculation of those values.