Recent Changes

2024-09-16

• 15:01 UTC (new) (history) 2024-09-16 Irregular recurring TODOs in Org mode, part II . . . . mbork – So, it’s been over a year since the previous part of my attempt to introduce “irregular, but recurring TODOs” into my workflow. This is something I really need, but it’s complicated enough that my inner procrastinator kept putting it off, unfortunately. Let’s start differently now.

2024-09-09

• 19:18 UTC (new) (history) 2024-09-09 Moving Virtualbox machines to another directory . . . . mbork – A few days ago I had a slightly atypical need. For some reason, I needed to move a Virtualbox machine to another directory.

2024-09-02

• 19:02 UTC (new) (history) 2024-09-02 Rounding all timestamps in an srt file . . . . mbork – Preview: This is another time I’m going to revisit subtitling in Emacs. This time I’m going to fix yet another minor annoyance. The srt files contain timestamps with millisecond resolution, which doesn’t make sense at all – when I edit subtitles for a video with 50fps, I don’t really need such precision. Instead, it makes sense for every timestamp to be rounded to the nearest 20 millisecond. I decided to write a simple piece of Elisp to do the rounding for me.

2024-08-26

• 16:24 UTC (new) (history) 2024-08-26 Deleting table rows based on data from other tables . . . . mbork – Today I have a short tip about PostgreSQL. Some time ago I needed to delete from a table all rows satisfying a certain condition involving another table. It turns out that it is not possible to use join in a delete statement – but there is a way around it (in fact, even two).

More...