←back to thread

479 points jgruber | 3 comments | | HN request time: 0.026s | source
Show context
minimaxir ◴[] No.43489167[source]
For posterity, here's a spreadsheet of all Daring Fireball submissions to HN, sorted chronologically: https://docs.google.com/spreadsheets/d/1A7ljmWbHtFsB4VRJ1Q0d...

From first glance there's still some decent traffic on Daring Fireball submissions, even inside the times Gruber asserts deadweighting.

replies(4): >>43489180 #>>43489311 #>>43489705 #>>43498038 #
minimaxir ◴[] No.43489180[source]
The data was retrieved from the public HN dataset on BigQuery: https://news.ycombinator.com/item?id=40644563

    SELECT
      id,
      title,
      url,
      FORMAT_TIMESTAMP("%Y-%m-%d %H:%m:%S", timestamp, "America/New_York") AS 
    submission_datetime,
      score,
      descendants as comments
    FROM
      `bigquery-public-data.hacker_news.full`
    WHERE
      type = "story"
      AND REGEXP_CONTAINS(url, r"daringfireball\.net")
    ORDER BY submission_datetime
replies(1): >>43502286 #
1. someothherguyy ◴[] No.43502286[source]
Should be %H:%i:%S?
replies(1): >>43507392 #
2. minimaxir ◴[] No.43507392[source]
%i is not an option. https://cloud.google.com/bigquery/docs/reference/standard-sq...

Looking it up it's only used in really old DBs.

...but that table reveals I should have used %M instead of %m. Whoops! Although in this particular case it doesn't make a difference. And apparently I can do "%F %X" instead of the whole string.

replies(1): >>43512870 #
3. someothherguyy ◴[] No.43512870[source]
Yeah, just looked wrong, didn't check the docs