Datasette sure is nifty

So uh yeah. See I was stumbling my way through using sqlite-utils to collect site content metadata. Finally figured that out but then made the mistake of looking at that data through Datasette.
Okay not really a mistake. Helped me find a few dozen front matter typos. Simon Willison makes cool stuff.
Activity Log
hackers.town: 2020-05-05 Tue 06:56
Nice to wake up to responses from “bob”’s representatives on birbsite.
#nobirb
at https://twitter.com/RealSubgenius/status/1257645818078617601


hackers.town: 2020-05-05 Tue 08:35
Dogs, just being dogs TBH.
Me: “Why you gotta be so annoying?”
Jumpy Dog: (wags tail, dry heaves)
hackers.town: 2020-05-05 Tue 09:19
Saw a guy in the grocery store maskless with a Jesus shirt buying a twenty dollar scratch ticket & I’m thinking buddy I’m no church goer but that ain’t how faith works?
hackers.town: 2020-05-05 Tue 09:57
Been exploring assorted FOSS repositories and realizing I have Strong Opinions about projects that don’t use the documentation features provided by their implementation language.
hackers.town: 2020-05-05 Tue 16:07
All set to blog about a Python site workflow thing when I thought “2.65 seconds is a bit sluggish” and ran Perl code which does nearly the same.
Perl code ran in 0.17s.
Chewing on this all afternoon.
Feeling compelled to match feature for feature & see if it stays fast.
Also pondering how much faster that Python code would be if I stripped some of the conveniences out.
A fun little puzzle with a few paths to look at.
hackers.town: 2020-05-05 Tue 17:40
Okay got the Python down to 0.75s on average (by replacing ruamel.yaml with pyyaml, and removing the convenience libs I wanted to write about).
Way more than Perl’s 0.17s, but tolerable compared to 2.65s.
Dinner, then back to the original post. It just needs a followup or two.
hackers.town: 2020-05-05 Tue 22:59
Ended up going back over a second with the Python but no longer as fussed about since the end result from the additions is pretty awesome.
hackers.town: 2020-05-05 Tue 23:07
@solder_on that blog post will end up singing the praises of both paths.
One is super quick if you know exactly what you want, the other is super shiny if you want to spend some time exploring.
hackers.town: 2020-05-05 Tue 23:54
@solder_on oh pfft if I only did what people asked me I’d still be bussing tables. The end is the same regardless of the means, so may as well brighten things up along the way.