Command for outputting a dump as NL objects

[simonw]

Rows are currently stored on disk in this format:

[1, "Simon"]
[2, "Cleo"]

You have to consult the accompanying metadata JSON file to find out what the column names are.

A command that streams out one of these dumps as newline separated objects with the column names as keys would be useful.

[simonw]

Potential design:

sqlite-diffable objects data/rows.ndjson

This would look for column info in data/rows.metadata.json.

It would stream newline delimited output to standard out.

-o filename could save to disk instead.

An option to write it out as a JSON array of objects would be useful too - maybe called --array.

[simonw]

Documentation: https://github.com/simonw/sqlite-diffable/blob/d8f071b3ff41147029d3a8c674509aef70c1241c/README.md#converting-to-json-objects