Links for the Week of September 5

• http://http://http://@http://http://?http://#http://

  is a legitimate URL
• I figured out how to build sqlite fiddle with a sqlite extension and wrote up notes alongside code. I learned a lot about compiling C into WASM along the way, and SQLite remains a joy to work with - the aggregate C file is such a great idea.
• Along with help from a sql.js developer, I added custom aggregate function support to the library. With this, you can define custom aggregate functions in javascript, making it easy to extend SQLite without having to do tricks to compile in extensions.
• Ben Johnson continued his excellent series on the internals of SQLite and wrote about how SQLite parses queries
• Hugo Landau laments the loss of mildly dynamic websites. Amen!
• There is a proposal to bring levelled logging to the golang standard library. I'll be interested to see how it compares to zerolog et al. Like many others, I have written and abandoned my own levelled logging wrapper around the stdlib.
• Speaking of logging, I revisited this article about using canonical log lines, the practice of each service request emitting a single wide long line when it completes. I wish go logging libraries supported the pattern of accumulating log bits as it proceeded, then emitting them at the end, better.
• Raph Levien demonstrates and explains a new best technique for creating parallel curves of cubic Bézier paths. I worked a bit about that in the past here when making Sol LeWitt drawings and have been following Raph's work that helped me a ton since.
• I've been trying to work my way through the Polgár chess problems, and this little site that lets you play them online is handy
• connect-go looks like a neat RPC library, aiming for something similar to but simpler in important ways than gRPC. site here
• The go team released a tool to check for vulnerabilities in your dependencies
• Marc Brooker wrote a very interesting blog post suggesting we use cumulative density graphs instead of histograms for displaying metrics graphics. I look forward to giving this a try the next time I have some metrics to display
• Divam Gupta made a simple gui for Stable Diffusion that makes AI image generation a click and install process
• Jonathan Whitaker wrote a colab notebook to explain how stable diffusion works
• youtube-dl has a Javascript interpreter done in 870 lines of code. Lovely stuff
• The US Congress has an API!
• Health insurers published close to a trillion prices to comply with price transparency regulations and Alec Stein is looking for help in trying to make sense of them
• The passing of Richard Cook brought how.complexsystems.fail back to my attention. Excellent work and I'm sad to hear of his passing.

Music

• I enjoyed JID's tiny desk concert
• I hadn't listened to Charlie Parker in a long while and it was a pleasure to go back to it

TV

• My wife and I started House of Dragons but didn't enjoy it very much so we're quitting on it
• We started on Underground Railroad instead; we're not far enough in to make any judgement