home / github / issues

Menu
  • Search all tables
  • GraphQL API

issues: 314455877

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
314455877 MDExOlB1bGxSZXF1ZXN0MTgxNzIzMzAz 209 Don't duplicate simple primary keys in the link column 45057 closed 0     6 2018-04-15T21:56:15Z 2018-04-18T08:40:37Z 2018-04-18T01:13:04Z CONTRIBUTOR simonw/datasette/pulls/209

When there's a simple (single-column) primary key, it looks weird to duplicate it in the link column.

This change removes the second PK column and treats the link column as if it were the PK column from a header/sorting perspective.

This might make it a bit more difficult to tell what the link for the row is, I'm not sure yet. I feel like the alternative is to change the link column to just have the text "view" or something, instead of repeating the PK. (I doubt it makes much more sense with compound PKs.)

Bonus change in this PR: fix urlencoding of links in the displayed HTML.

Before:

After:

107914493 pull    
{
    "url": "https://api.github.com/repos/simonw/datasette/issues/209/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
0  

Links from other tables

  • 0 rows from issues_id in issues_labels
  • 6 rows from issue in issue_comments
Powered by Datasette · Queries took 14.618ms · About: github-to-sqlite