issue_comments: 924443089

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/111#issuecomment-924443089 https://api.github.com/repos/simonw/datasette/issues/111 924443089 IC_kwDOBm6k_c43GeHR 9599 2021-09-21T22:45:14Z 2021-09-21T22:45:26Z OWNER

The audiences I care about here are:

  • Producers of this timestamp - generally that will be users who are using datasette publish to share their data
  • Human consumers of this timestamp - end users who look at a Datasette site and want to know how recent the data is
  • Machine consumers of this timestamp - API integrations that might want to check if a Datasette instance has been updated before downloading new data

For producers I think there are going to be two categories. The first is users who run "publish" and want the site to reflect when they did so (probably using --updated=now when they publish). The second are users who are willing to spend more time thinking about this - for example my various git scraping projects where I want to use a date derived from the git history.

For humans... I'd like to be able to calculate a relative time (3 hours ago) in addition to showing the display time, because that helps avoid confusion over timezones.

For machine consumers, it might be nice to offer the option of a calculated Unix timestamp-since-1970, since those can be easier to work with in some languages than running a full ISO date parser.

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 274615452