Marcin Borkowski: Recent Changes

Updates since 2024-08-07 10:44 UTC up to 2024-09-06 10:44 UTC

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.

2024-08-12

08:47 UTC (new) (history) 2024-08-12 How to require confirmation before launching an Emacs command . . . . mbork – Some Emacs commands are potentially destructive (like kill-emacs, which exits Emacs) and may require some kind of confirmation. The usual way of confirming that this is really what I want to do is y-or-n-p (and a few more functions from its family) and yes-or-no-p. Sometimes, however, there is a command which does not invoke y-or-n-p or any similar function, but for some reason I want it to ask for confirmation. An example is mu4e-compose-reply (bound to R in Mu4e) – I usually want mu4e-compose-wide-reply (bound to W), aka “reply to all”. I thought about advising mu4e-compose-reply, but then it occurred to me that Emacs already has a feature which ensures that I won’t invoke some command by accident: disabled commands.