(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
- 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.
- Single JSON file/document produces single row.
(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).