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.

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

sqlite-utils rows options --limit and --offset #381

Closed
simonw opened this issue Jan 11, 2022 · 2 comments
Closed

sqlite-utils rows options --limit and --offset #381

simonw opened this issue Jan 11, 2022 · 2 comments
Labels
cli-tool enhancement New feature or request

Comments

@simonw
Copy link
Owner

simonw commented Jan 11, 2022

Because I often want to use it just to preview a few rows from the database. Piping through | head -n 20 works for JSON and CSV (they stream) but not for --table.
@simonw simonw added enhancement New feature or request cli-tool labels Jan 11, 2022
@simonw simonw mentioned this issue Jan 11, 2022
Closed
@simonw
Copy link
Owner Author

simonw commented Jan 11, 2022 •
edited
Loading

sqlite-utils search has --limit already: https://sqlite-utils.datasette.io/en/latest/cli-reference.html#search

  --limit INTEGER        Number of rows to return - defaults to everything

@simonw simonw closed this as completed in 324ebc3 Jan 11, 2022
@simonw
Copy link
Owner Author

simonw commented Jan 11, 2022

Documentation: https://sqlite-utils.datasette.io/en/latest/cli.html#returning-all-rows-in-a-table

simonw added a commit that referenced this issue Jan 11, 2022
@simonw
Release 3.22
74586d3 
Refs #381, #382, #383
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