Recent Changes

2022-09-26

• 15:56 UTC (new) (history) 2022-09-26 Knex, PostgreSQL and bytea columns . . . . mbork – Today I have yet another PostgreSQL-related tip. Some time ago I needed to put contents of some binary file into a bytea column, using Node and Knex.js. I couldn’t find any tutorials, so I decided to try to do the simplest thing and see if it breaks. To my astonishment, it didn’t – it Just Worked™!

2022-09-17

• 14:10 UTC (new) (history) 2022-09-17 Safe killing with Emacs . . . . mbork – Some time ago Samuel Wales had a very interesting question on the Emacs mailing list. He sometimes kills some portion of text to yank it elsewhere, but gets distracted and forgets about the yanking. This way, the text is lost. He basically wants to make the “kill-yank” cycle atomic so that you never end up in the intermediate step where the information is lost.

2022-09-12

• 18:35 UTC (new) (history) 2022-09-12 Shifting dates or timestamps in PostgreSQL . . . . mbork – For today I only have a short and simple PostgreSQL tip. Recently, for the purpose of testing, I needed a user created more than a day ago. Instead of manually typing a timestamp, I created a user now and did this

2022-09-05

• 18:53 UTC (new) (history) 2022-09-05 Comments in srt files . . . . mbork – As I mentioned several times here, I do quite a lot of editing of srt subtitle files for videos. Sometimes I have problems when I translate subtitles into Polish, and then I usually ask native speakers about some obscure idiom or even more obscure (at least for me) cultural reference. In such cases, I figured I’d really like it if I could put comments into srt files to remember these places.

More...