Recent Changes

2022-10-03

• 21:07 UTC (new) (history) 2022-10-03 Converting words and sentences to identifiers . . . . mbork – Preview: Some time ago I had a need to “convert” a phrase, or even a whole sentence, into an identifier. By “converting to an identifier” I mean lower-casing the whole thing and changing non-letter characters into underscores. For example, “Hello, world!” should become hello_world. I came up with some simple code to do that – but it turned out that there were some pitfalls I did not expect.

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

More...