improved SQL error message is dsquery

This release has improved SQL error message for dsquery.

Full Changelog: v2.1.8...v2.1.9

dsimport rename dsimporter

On macOS ships with a program called dsimport so dataset's importer collides with that name. I have renamed my importer to dsimporter to avoid that problem.

dsimport added

This release includes a new program called dsimport which will import a CSV file into a collection much like the import verb did in v1 of dataset. An "-all" option is included with the dataset clone action to make it easy to copy the content of a SQL based collection since copying the collection using the standard operating system copy will not resolve database and table name relationships when using a SQL engine to store your JSON.

Full Changelog: v2.1.6...v2.1.7

added csv output to dsquery

This is a minor feature release adding CSV output support to dsquery. Some bug fixes. No changes to libdataset so not included with release.

Full Changelog: v2.1.5...v2.1.6

dsquery with pairtree support

This release features an improved dsquery that can index and query a pairtree based dataset collection. In addition to supporting all the dataset collection storage engines the following options have been added or improved.

-sql
: Read SQL from a file

-grid
: Given a list of attribute names returned by the object in the SQL statement, make a 2D values grid and return instead
of a list of JSON objects.

-index
: Read the contents of a collection into a SQLite 3 database called index.db. It uses the same structure as a SQL storage
engine based collection.

There were no changes to libdataset in this release.

Full Changelog: v2.1.4...v2.1.5

dsquery

This release includes an experimental command dsquery which will let you query SQL based collections to return a list of objects as a JSON array. This approach looks to improve on the data frame generation previously implemented for pairtree.

v2.1.3

This release is primarily a documentation update. I've documented postgres support in the dataset command dataset help init. Note if you need to set sslmode when using Postgres to store your dataset collection you need to pass it as part of the DSN uri.

dataset init data.ds "postgres://$DB_USER@localhost/data?sslmode=disabled"

NOTE: there was a problem when did the initial release for v2.1.3, you should see the hash "6e51f3e" in the version number if you run

dataset --version

improved JSON handling

This release is based on improved json handling and made to align it with datatools v1.2.4 json handling.

Bug fixes, cleanup, clarifications

Fixed bugs described in issue #123. Cleaned up some documentation, clarified thinking on versioning, brought libdataset inline with main v2 dataset codebase for version handling.

Add set versioning and get versioning to cli as well as libdataset.

Updates dependencies and bug fixes

This release sees the return of libdataset C-shared library an a minimal level of backward compatibility added with v1.1 branch of dataset.

Full Changelog: v2.0.1...v2.1.0