181–190 of 229 posts
Earlier quoted context omitted.
If the last story on HN was at December 26, that is.
Continuously updated != instantly updated
Perhaps “regularly updated” would be less contentious wordage?
Is it a thing that the design is almost unusable on a mobile phone? The tech making this possible is beyond cool, but it's just presented in such a brutal way for phone users, even though fixing it would be super simple.
threw some heatmaps together of post volume and average score by day and time (15min intervals) story volume (all time): https://ibb.co/pBTTRznP average score (all time): https://ibb.co/KcvVjx8p story volume (since 2020): https://ibb.co/cKC5d7Pp average score (since 2020): https://ibb.co/WpN20kfh
added median too. median score (all time): https://ibb.co/gZV5QVMG median score (since 2020): https://ibb.co/Gfv8T7k8
Earlier quoted context omitted.
PMTiles is absurdly great software.
My only gripe is that the tile metadata is stored as JSON, which I get is for compatibility reasons with existing software, but for e.g. a simple C program to implement the full spec you need to ship a JSON parser on top of the PMTiles parser itself.
Similar in spirit to a recent tool I recently posted Show HN on, https://exopriors.com/scry . You can use Claude Code to SQL+vector query HackerNews and many other high quality public commons sites, exceptionally well-indexed and usually 5+ minute query timeout limits, so you can run seriously large research queries, to rapidly refine your worldview (particular because you can do easily to EXHAUSTIVE exploration).
Earlier quoted context omitted.
added median too. median score (all time): https://ibb.co/gZV5QVMG median score (since 2020): https://ibb.co/Gfv8T7k8
This is fascinating, I love this! What do you create these heat maps with? Did you use the BigQuery data or download from the site?
Earlier quoted context omitted.
This is fascinating, I love this! What do you create these heat maps with? Did you use the BigQuery data or download from the site?
thanks! i downloaded them and used python to make these
Totally cool if not, just super interesting!
Don't miss how this works. It's not a server-side application - this code runs entirely in your browser using SQLite compiled to WASM, but rather than fetching a full 22GB database it instead uses a clever hack that retrieves just "shards" of the SQLite database needed for the page you are viewing. I watched it in the browser network panel and saw it fetch: https://hackerbook.dosaygo.com/static-shards/shard_1636.sqli…
Thanks! I'm glad you enjoyed the sausage being made. There's a little easter egg if you click on the compact disc icon. And I just now added a 'me' view. Enter your username and it will show your comments/posts on any day. So you can scrub back through your 2006 - 2025 retrospective using the calendar buttons.
Earlier quoted context omitted.
Thanks! I'm glad you enjoyed the sausage being made. There's a little easter egg if you click on the compact disc icon. And I just now added a 'me' view. Enter your username and it will show your comments/posts on any day. So you can scrub back through your 2006 - 2025 retrospective using the calendar buttons.
I almost got tricked into trying to figure out what was Easter eggy about August 9 2015 :-) There's a clarifying tooltip on the link, but it is mostly obscured by the image's "Archive" title attribute.
edit: Fixed! Also I just pushed a new version with a Dec 29th Data Dump, so ... updates - yay!