Octosql Versions Save

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

v0.12.2

10 months ago

Changelog

  • (Maintenance) Update Go dependecies (#324) (Thanks @jauderho!)
  • (Maintenance) update badge url as per https://github.com/badges/shields/issues/8671 (#322) (Thanks @phanirithvij!)
  • (Bugfix) Prevent creating ~/.octosql dir if XDG dirs exists (#316) (Thanks @Tony-Sol!)

v0.12.1

1 year ago

Changelog

  • (Feature) Add support for the XDG Spec (thanks @Tony-Sol for the contribution!).

v0.12.0

1 year ago

Changelog

  • (Feature) Change the semantics of double quotes from a string literal to a literal identifier (so they work the same way as backticks).
  • (Bugfix) Fix division using slash as an operator. Require a space between operands for it to be usable.

v0.11.1

1 year ago

Changelog

  • (Feature) Improve CSV value formatting.
  • (Feature) Add configuration parameters for JSON maximum line size as well as file reader buffer size.
  • (Feature) Add boolean to int conversion function.
  • (Performance) Hashing optimizations to reduce unnecessary allocations.

v0.11.0

1 year ago

Changelog

  • (Feature) Switch to using a hashmap instead of a BTree in some (not all yet) places where ordering is not important. This yields a small performance improvement for most group by queries, and a huge one (up to 4x measured) for groupings with a lot of keys.
  • (Bug) Fix bug where variables only used by a distinct node can be optimized out, making the distinct node work improperly.

v0.10.0

1 year ago

Changelog

  • (Feature) Parallelize JSON processing. Can result in 2x+ performance improvements for queries bottlenecked by JSON parsing.
  • (Stability) Improve error message when non-SELECT statement is used.

Contributions

  • Improve installation documentation (#294). Thanks @arikgrahl !

v0.9.4

1 year ago

Changelog

  • Internal Refactors

v0.9.3

1 year ago

Changelog

  • (Bug) Fix object field access for fields that have periods in them. I.e. object->`my.field`

v0.9.2

1 year ago

Changelog

  • (Feature) Add overloads for len function handling lists, objects and tuples.
  • (Feature) Improve automatic column naming based on variable names.
  • (Stability) Improve stdin reader error handling.
  • (Stability) Bump the number of schema introspection rows for the CSV datasource to 100, to keep it consistent with the JSON datasource.

v0.9.1

1 year ago

Changelog

  • (Feature) Make all file access consistent and available through the alternative <file_type>.<path> notation.
  • (Bug) Fix --describe to display names without qualifiers, if there are no duplicates.