You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
(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)
.The text was updated successfully, but these errors were encountered: