SQLite: use GLOB instead of LIKE to hit the PK index

Thanks to a fix by @mtelvers to Opam Repository CI, I learnt the difference between using LIKE and GLOB for fields with a primary key index.

The TL;DR is that LIKE is case-insensitive by default and cannot make use of an index where as GLOB which is case-sensitive would.

Programming as Theory Building by Peter Naur

As a part of my continuing endeavor to make sense of what programming (at work and outside of it) means to me in the age of LLM assisted or agentic programming, I decided to spend some time carefully reading the paper Programming as Theory Building by Peter Naur.

I’m aware of the ideas presented in this paper at a high level, thanks to discussions with Shon over the past year or so. But, I figured it’s time to read the paper thoroughly and reflect on it more carefully. I’ve read through the first two sections of it, and hope to continue over the course of this week.

The UV index is not the warm sensation of sunlight on bare skin

I enjoyed reading this post on why the warm sensation from being the Sun isn’t exactly what causes sunburn. I guess it calls for a mandatory watching/listening of Wear Sunscreen.

John Wiegley’s org-mode magic setup

I discovered this chat Sacha and Karthik had with John Wiegley and I was totally blown away! I spent a bunch of time (with Claude) trying to improve my own org-mode setup, picking some nice things from his setup.

Some of the highlights, reminders, take-aways for me were:

• Capture should be quick. Review stage could add finer tagging, etc.
• John has written/uses packages like org-review, org-hash, org-drafts, etc. which seem to be crystallisation of some useful wisdom/ideas from his extensive use of org-mode.
• TIL: use org-capture with M-0 prefix to use a capture template in at point, instead of the location associated with the capture template.
• John heavily uses AI (local and cloud-provided) to generate bunch of “boring” things like org-mode titles for TODOs/NOTEs, etc.
• Voice transcription is also something both him and Sacha seem to be using a lot. I’ve not found myself a good way to set this up. John also mentioned that he tends to be more descriptive when using the voice interface, which helps when acting on the captured entries in future. (Especially with the LLMs that he uses).
• TIL: C-c C-o opens links in an entry. Karthik has a completing-read version of it that might be useful to check out.

Restaurant: Tuoi Moi

We went to Tuoi Moi last night. It is a small cozy place in Humayunpur. The food was lovely, too. We especially loved the chilli oil and even bought some to use at home.

Enola Holmes 3

We (wife and I) watched Enola Holmes 3 on OTT. We enjoyed Millie Bobby Brown’s “‘Tis I” in the previous editions of the movie and looks like some of the other characters also picked it up this time around!