home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 392575160

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/datasette/issues/36#issuecomment-392575160 https://api.github.com/repos/simonw/datasette/issues/36 392575160 MDEyOklzc3VlQ29tbWVudDM5MjU3NTE2MA== 9599 2018-05-28T17:30:52Z 2018-05-28T17:30:52Z OWNER

I've changed my mind about this.

"Select every record on the 3rd day of the month" doesn't strike me as an actually useful feature.

"Select every record in 2018 / in May 2018 / on 1st May 2018", if you are using the SQLite-preferred datestring format, are already supported using LIKE queries (or the startswith filter):

  • https://fivethirtyeight.datasettes.com/fivethirtyeight/inconvenient-sequel%2Fratings?timestamp__startswith=2017
  • https://fivethirtyeight.datasettes.com/fivethirtyeight/inconvenient-sequel%2Fratings?timestamp__startswith=2017-08
  • https://fivethirtyeight.datasettes.com/fivethirtyeight/inconvenient-sequel%2Fratings?timestamp__startswith=2017-08-29
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
268262480  
Powered by Datasette · Queries took 0.856ms · About: github-to-sqlite