Recent Changes

2020-12-24

• 07:58 UTC (new) (history) 2020-12-24 Christmas 2020 . . . . mbork – As usual, the time has come for Christmas wishes to all my readers. Frankly, I have no idea how many of you there are, since I do not track you in any way. But I know that there do exist people who read my blog, and to them I say thank you, and God bless you. (According to my now several-years-long tradition, I will offer a decade of Rosary for you as my Christmas gift!) And please notice this: Jesus, our Lord and Savior, is just so reliable. There may be the epidemic, lockdown, there might even be war, famine or whatever – but He will come to save us. I find it extremely reassuring. Also, this time I’d like to say a bit more than just wishes.

2020-12-21

• 19:12 UTC (new) (history) 2020-12-21 Pretty printing json and jsonb columns in PostgreSQL . . . . mbork – And for today I have yet another short PostgreSQL tip. I use a database which has quite a few tables with jsonb – and also json – type fields. (I know, I know. No new json columns, but legacy etc.) Since they often contain quite a few things, pretty printing them is something I tend to do fairly often. Happily, PostgreSQL has a function to do that. Less happily, it only works with jsonb columns, and has a long, awkward name: jsonb_pretty. But it’s no longer a problem for me, since it is easy to create a shorthand.

2020-12-14

• 08:41 UTC (new) (history) 2020-12-14 My volume control in AwesomeWM . . . . mbork – Embrace yourselves, since a heresy is coming! I sometimes am outside Emacs (gasp!), and getting to it is a bit uncomfortable.

2020-12-07

• 22:02 UTC (new) (history) 2020-12-07 Temporary PostgreSQL tables . . . . mbork – Today I have yet another small PostgreSQL tip. Sometimes you want just to experiment a bit, or maybe move some data around a bit, and then you may have the idea “ok, so I’ll just create this table, do something with it, and then drop it”. Well – you don’t have to drop it.

More...