Post ASmhiMeK5quZKSDILA by acdha@thepit.social
(DIR) More posts by acdha@thepit.social
(DIR) Post #ASmfzEDOVOoKBWX0E4 by simon@fedi.simonwillison.net
2023-02-17T22:16:29Z
0 likes, 1 repeats
My blog post on Wednesday about Bing sat on the Hacker News homepage all day AND got tweeted by Elon - a bunch of people asked me what the traffic looked likeSo I've written about the numbers here: https://simonwillison.net/2023/Feb/17/analytics/And made them available in a Datasette instance too: https://i-will-not-harm-you-unless-you-harm-me-first.vercel.app/
(DIR) Post #ASmgkUrQR1mpQ9nLPM by simon@fedi.simonwillison.net
2023-02-17T22:23:15Z
0 likes, 0 repeats
My favourite view onto all of this activity is this chart showing the percentage of pages served by the Cloudflare cacheI've long been a fan of whole-page caching as protection against surprising traffic spikes, and this was by far the biggest example of that I've ever encountered with any of the sites I host myselfhttps://i-will-not-harm-you-unless-you-harm-me-first.vercel.app/cloudflare?sql=select+timeslot%2C+requests%2C+cachedRequests%2C+100.0+*+cachedRequests+%2F+requests+as+pctCached+from+timeslots+order+by+timeslot+limit+101#g.mark=line&g.x_column=timeslot&g.x_type=ordinal&g.y_column=pctCached&g.y_type=quantitative
(DIR) Post #ASmhNm906pgCJnkGMi by grantmc@techhub.social
2023-02-17T22:26:59Z
0 likes, 0 repeats
@simon Wild. I cannot imagine the spike of adrenaline after realizing he Tweeted your blog post.
(DIR) Post #ASmhbCYdDSXe0E8TpI by sboots@mastodon.sboots.ca
2023-02-17T22:29:54Z
0 likes, 0 repeats
@simon Simon this is awesome!! Thanks for sharing the behind-the-scenes numbers! š
(DIR) Post #ASmhiMeK5quZKSDILA by acdha@thepit.social
2023-02-17T22:37:32Z
0 likes, 0 repeats
@simon cache rules everything around you?
(DIR) Post #ASmhmGkNynYMBKuYO8 by sboots@mastodon.sboots.ca
2023-02-17T22:30:40Z
0 likes, 0 repeats
@simon This also validated my decision to switch from Google Analytics to Plausible last fall. š
(DIR) Post #ASmk1dIqbEr8ODU4dU by peterbutler@mas.to
2023-02-17T23:01:17Z
0 likes, 0 repeats
@simon What does the ātime on pageā refer to? Is that total for the 959K visitors? Canāt be, but 42 minutes surely canāt be average engagement time either...
(DIR) Post #ASmkYYnEO8t1xUOerA by simon@fedi.simonwillison.net
2023-02-17T23:07:27Z
0 likes, 0 repeats
@peterbutler I've been wondering about that myself! That number makes no sense to me
(DIR) Post #ASmksI4YGUQVtMuG9I by simon@fedi.simonwillison.net
2023-02-17T23:10:53Z
0 likes, 0 repeats
Here's the jq script I used to convert the GraphQL analytics output from Cloudflare into a flat JSON array of objects that I could then import into a SQLite database using sqlite-utils:https://github.com/simonw/i-will-not-harm-you-unless-you-harm-me-first/blob/main/build-dbs.shI got ChatGPT to write the initial jq expression for me, because jq's syntax firmly refuses to stay in my head
(DIR) Post #ASmlmtsWtEOHMWHDii by olivierlacan@ruby.social
2023-02-17T23:21:23Z
0 likes, 0 repeats
@simon I really appreciate how much you share helpful learnings, tools, and solutions you come across. It's truly lovely to have someone like you in this opens source and web community. Thank you.
(DIR) Post #ASmopjX473uU0OHOk4 by philt3r@mastodon.social
2023-02-17T23:55:17Z
0 likes, 0 repeats
@simon What is that tool for analytics? Can you self host it?
(DIR) Post #ASmpWN4RV626nHDsCu by simon@fedi.simonwillison.net
2023-02-18T00:03:09Z
0 likes, 0 repeats
@philt3r Yeah, Plausible is open-source and self-hostable: https://github.com/plausible/analyticsI use their SaaS product
(DIR) Post #ASmxdZ6xvnMBnWLPVY by jimfl@hachyderm.io
2023-02-18T01:34:05Z
0 likes, 0 repeats
@simon jq has the quality that solving problems with it is so satisfying, yet the solutions are just not very satisfying somehow.
(DIR) Post #ASmyqBTbDU9MDKVo2K by bat@fosstodon.org
2023-02-18T01:47:47Z
0 likes, 0 repeats
@simon Very slightly better than JavaScript. Python is missing Array.prototype.flat() and optional chaining (?.)
(DIR) Post #ASniyWXbNXGpkjIasS by offlinehq@hachyderm.io
2023-02-18T10:24:30Z
0 likes, 0 repeats
@simon good to know, ChatGPT might be devops best friend
(DIR) Post #ASp1DPN4JLHIBzZxa4 by maks@fluttercommunity.social
2023-02-19T01:23:38Z
0 likes, 0 repeats
@simon glad to know I'm not the only one who finds jq's query syntax about as intuitive as an english speaker learning Finnish.
(DIR) Post #ASp4ZGuIlC5iAvEy2q by billseipel@fosstodon.org
2023-02-19T02:01:13Z
0 likes, 0 repeats
@simon I use chatGPT for small tasks like this. It will even author complete models based on a list you provide. Great time saver.
(DIR) Post #ASq4MXIYhWPwPBTQOW by Corvan@chaos.social
2023-02-19T13:33:31Z
0 likes, 0 repeats
@simon you don't have to do cat, jq can take a file argument after the script, but that is mere cosmetics. Good work!
(DIR) Post #AStlNTJTskDFq2TepE by bgeron@hachyderm.io
2023-02-21T08:19:38Z
0 likes, 0 repeats
@simon I find nushell more intuitive than jq.