Recent Changes

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).

2024-08-19

• 05:09 UTC (new) (history) 2024-08-19 Opening all links in an Org subtree . . . . mbork – A few days ago I had an extremely specific need. I had an Org mode subtree consisting entirely of a list of URLs, and I wanted to open them all in my browser.

More...