home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 379557982

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/189#issuecomment-379557982 https://api.github.com/repos/simonw/datasette/issues/189 379557982 MDEyOklzc3VlQ29tbWVudDM3OTU1Nzk4Mg== 9599 2018-04-08T15:16:49Z 2018-04-08T15:16:49Z OWNER

A note about views: a view cannot be paginated using keyset pagination because records returned from a view don't have a primary key - so there's no way to reliably distinguish between _next= records when the sorted column has duplicates with the same value.

Datasette already takes this into account: views are paginated using offset/limit instead. We can continue to do that even for views that have been sorted using a _sort parameter.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
309471814  
Powered by Datasette · Queries took 0.824ms · About: github-to-sqlite