Multiprocessio Dsq Versions Save

Commandline tool for running SQL queries against JSON, CSV, Excel, Parquet, and more.

v0.23.0

1 year ago

v0.22.0

1 year ago

0.21.0

1 year ago

0.20.2

1 year ago
  • Properly quote fields when using new CSV writer (see #74 )
  • Handle --convert-numbers flag in new SQLiteWriter by using NUMERIC field type, no conversions in Go
  • Properly handle no query case by disabling SQLiteWriter in this case so intermediate JSON file does get written

0.20.1

1 year ago
  • Limit SQLite writer to only CSV, TSV and Regexp newline files for now since nested objects aren't translated the same way yet in the SQLite writer.

0.20.0

1 year ago
  • Speed up most runs of dsq on large files 2x by skipping intermediate writes to JSON, writing directly from file to SQLite (see https://github.com/multiprocessio/datastation/pull/267 for details). If this breaks things for you you can add the --no-sqlite-writer flag to go back to the old code path. This path isn't taken for JSON, Excel, and ODS files or when schema or --convert-numbers is set.

0.19.0

1 year ago
  • -n, --convert-numbers flag to automatically convert values to integers or floats when reading CSV/TSV; courtesy of @fritzgrabo

0.18.0

1 year ago
  • New hashing/encoding functions: base64, from_base64, md5, sha1, sha256, sha512, etc. See here for the full list.
  • New string functions: len, split_part, regexp_count, regexp_split_part. See here for details.

0.17.0

2 years ago
  • Bring in go-sqlite3-stdlib with functions for parsing URLs, best-effort date parsing, string and math helpers, and aggregate functions like percentiles, stddev, median, mode, etc. See that repo README for full details.

0.16.0

2 years ago
  • Support for a basic interactive REPL with the -i or --interactive flag courtesy of @Ghibranalj