8000 sqlite-utils memory --analyze option · Issue #320 · simonw/sqlite-utils · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

sqlite-utils memory --analyze option #320

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.

Sign up for GitHub

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

Jump to bottom
Closed
simonw opened this issue Aug 22, 2021 · 2 comments
Closed

sqlite-utils memory --analyze option #320

simonw opened this issue Aug 22, 2021 · 2 comments
Labels
cli-tool enhancement New feature or request

Comments

@simonw
Copy link
Owner
simonw commented Aug 22, 2021

To provide a way of running analyze-tables directly against JSON or CSV data.
@simonw simonw added enhancement New feature or request cli-tool labels Aug 22, 2021
@simonw simonw closed this as completed in 9258f4b Aug 22, 2021
@simonw
Copy link
Owner Author
simonw commented Aug 22, 2021 •
edited
Loading 
curl 'https://api.github.com/users/dogsheep/repos' | sqlite-utils memory - --analyze

stdin.id: (1/73)

  Total rows: 13
  Null rows: 0
  Blank rows: 0

  Distinct values: 13

stdin.node_id: (2/73)

  Total rows: 13
  Null rows: 0
  Blank rows: 0

  Distinct values: 13

stdin.name: (3/73)

  Total rows: 13
  Null rows: 0
  Blank rows: 0

  Distinct values: 13

stdin.full_name: (4/73)

  Total rows: 13
  Null rows: 0
  Blank rows: 0

  Distinct values: 13

stdin.private: (5/73)

  Total rows: 13
  Null rows: 0
  Blank rows: 0

  Distinct values: 1

  Most common:
    13: 0

stdin.owner: (6/73)

  Total rows: 13
  Null rows: 0
  Blank rows: 0

  Distinct values: 1

  Most common:
    13: {"login": "dogsheep", "id": 53015001, "node_id": "MDEyOk9yZ2FuaXphdGlvbjUzMDE1MD...

stdin.html_url: (7/73)

  Total rows: 13
  Null rows: 0
  Blank rows: 0

  Distinct values: 13

stdin.description: (8/73)

  Total rows: 13
  Null rows: 0
  Blank rows: 0

  Distinct values: 13

stdin.fork: (9/73)

  Total rows: 13
  Null rows: 0
  Blank rows: 0

  Distinct values: 1

  Most common:
    13: 0

stdin.url: (10/73)

  Total rows: 13
  Null rows: 0
  Blank rows: 0

  Distinct values: 13

stdin.forks_url: (11/73)

  Total rows: 13
  Null rows: 0
  Blank rows: 0

  Distinct values: 13

stdin.keys_url: (12/73)

  Total rows: 13
...

@simonw
Copy link
Owner Author
simonw commented Aug 22, 2021

Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#schema-analyze-dump-and-save

simonw added a commit that referenced this issue Aug 24, 2021
@simonw
Release 3.17
c18ae2f 
Refs #319, #320
simonw added a commit that referenced this issue Aug 24, 2021
@simonw
Release 3.17
77c240d 
Refs #319, #320
This was referenced Jan 7, 2022
Closed
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
cli-tool enhancement New feature or request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@simonw
0