Marcin Borkowski: Recent Changes

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

2024-08-05

11:37 UTC (new) (history) 2024-08-05 Case-insensitive where in clause . . . . mbork – Sometimes you need to compare strings case-insensitively. Assume that you want to find a user with an email bob@builder.com in your database, but you don’t know if he didn’t type his email in upper case (BOB@BUILDER.COM), or maybe capitalized (Bob@Builder.com), etc. [...] Now assume that you want to find the ids of all people with emails bob@builder.com, pat@postman.com and sam@fireman.com, still case-insensitively. There is no where in ilike operator in PostgreSQL, so what do we do?

2024-07-29

19:30 UTC (new) (history) 2024-07-27 How to make Emacs not scroll from the current position . . . . mbork – Emacs – like most or all other editors – scrolls the buffer when the point moves out of the “visible portion” of text. This is of course exactly what you want – 99% of the time. Sometimes, however, I precisely set things up so that a particular set of lines is visible, and I really don’t want to accidentally mess it up (for example with isearch). I went through the Emacs manual to see if there is some mode or something to do that, and it seems that there’s not. (Though there are quite a few ways to customize scrolling, see the relevant chapters of the manual.) Being me, I decided to code it myself.

2024-07-22

19:11 UTC (new) (history) 2024-07-22 New things in new Emacs . . . . mbork – Some time ago I wrote about a few new things in Emacs 29. Well, even though Emacs 30 is not out yet, I use Emacs compiled from source on the master branch, and while I do not compile a new version very often, I still have a version newer than what my distro offers. So, I went through the NEWS.30 in my Emacs Git repo, and – as usual – found a few gems.

2024-07-13

06:14 UTC (new) (history) 2024-07-13 Dedicated windows . . . . mbork – There are some features of Emacs which you can read about in the manual and go “huh? what is that about? who’d ever need it?”, and then later turn out to need exactly them. Recently I learned that dedicated windows are just like that.