As a user of sqliteviz,
In order to import data whose machine-readable representation is only available in JSON,
I want to be able to import JSON files in sqliteviz.
Abstract
JSON is ubiquitous. Some Linux tools, for instance smemstat, only have JSON as a machine-readable output format option.
JSON1 and recursive CTEs (both are out-of-the-box in sql.js) are sufficient for most cases of extracting data from JSON document(s) and JOINing them with other tables.
JSON file import UI
Similar UI as for CSV.
User should be able to provide a table name.
The schema for the table is always like CREATE TABLE user_provided(id INT, filename TEXT, document TEXT).
In the file dialogue multiple JSON file selection is possible.
(original idea from #56)
As a user of sqliteviz, In order to import data whose machine-readable representation is only available in JSON, I want to be able to import JSON files in sqliteviz.
Abstract
smemstat, only have JSON as a machine-readable output format option.sql.js) are sufficient for most cases of extracting data from JSON document(s) and JOINing them with other tables.JSON file import UI
CREATE TABLE user_provided(id INT, filename TEXT, document TEXT).