home / github / issue_comments

Menu
  • GraphQL API

issue_comments: 850765291

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/sqlite-utils/issues/260#issuecomment-850765291 https://api.github.com/repos/simonw/sqlite-utils/issues/260 850765291 MDEyOklzc3VlQ29tbWVudDg1MDc2NTI5MQ== 9599 2021-05-29T04:07:48Z 2021-05-29T04:08:21Z OWNER For the CLI version I could say that you can use a `-` prefix to specify reverse direction: ```sh sqlite-utils create-index mydb.db dogs -age name ``` No, that doesn't work - it could get confused with a command-line flag. I guess you could do this: ``` sqlite-utils create-index mydb.db dogs "-age" name ``` This does mean that if any of your column names begin with a hyphen you can't use the CLI to add indexes to them. Is that an acceptable limitation? Users can always use `sqlite-utils mydb.db "create index ..."` in that case. {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} 906330187  
Powered by Datasette · Queries took 0.806ms