Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[RFE] JSON file import #61

Open
saaj opened this issue Jun 13, 2021 · 0 comments
Open

[RFE] JSON file import #61

saaj opened this issue Jun 13, 2021 · 0 comments

Comments

@saaj
Copy link
Contributor

saaj commented Jun 13, 2021

(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

  1. JSON is ubiquitous. Some Linux tools, for instance smemstat, only have JSON as a machine-readable output format option.
  2. 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

  1. Similar UI as for CSV.
  2. User should be able to provide a table name.
  3. The schema for the table is always like CREATE TABLE user_provided(id INT, filename TEXT, document TEXT).
  4. In the file dialogue multiple JSON file selection is possible.
  5. Single JSON file/document produces single row.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant