Skip to content

v0.36.0

Compare
Choose a tag to compare
@neilotoole neilotoole released this 26 May 06:17
· 258 commits to master since this release

The major feature is the long-gestating sq diff.

Added

  • #229: sq diff compares two sources, or tables.
  • sq inspect --dbprops is a new mode that returns only the DB properties.
    Relatedly, the properties mechanism is now implemented for all four supported
    DB types (previously, it was only implemented for Postgres and MySQL).
  • CSV format now colorizes output.

Changed

  • sq inspect -v previously returned DB properties in a field named db_variables.
    This field has been renamed to db_properties. The renaming reflects the fact
    that some of those properties aren't really variables in the sense that they
    can be modified (e.g. DB server version or such).
  • The structure of the former db_variables (now db_properties) field has
    changed. Previously it was an array of {"name": "XX", "value": "YY"} values,
    but now is a map, where the keys are strings, and the values can be either
    a scalar (bool, int, string, etc.), or a nested value such as an array
    or map. This change is made because some databases (e.g. SQLite) feature
    complex data in some property values.
  • CSV format now renders byte sequences as [777 bytes] instead of dumping
    the raw bytes.
  • ☢️ TSV format (--tsv) no longer has a shorthand form -T. Apparently that
    shorthand wasn't used much, and -T is needed elsewhere.
  • ☢️ Likewise, --xml no longer has shorthand -X. And --markdown has lost alias --md.
  • In addition to the format flags --text, --json, etc., there is now
    a --format=FORMAT flag, e.g. --format=json. This will allow sq to
    continue to expand the number of output formats, without needing to have
    a dedicated flag for each format.