Command for outputting a dump as NL objects

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.

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.

Release 0.5

Navigation Menu