Recent Changes

2022-02-28

• 18:56 UTC (new) (history) 2022-02-28 A clever trick with psql copy and multiline select statements . . . . mbork – For today, I have another PostgreSQL tip, which I admit is extremely niche, but useful nevertheless. As I mentioned a few times, I’m a big fan of psql. One of the nice things it has to offer is the \copy command. It is a very thin wrapper around SQL’s copy command, with an important change: it generates files on the local filesystem, and they are owned by the user who runs psql, not the postgres user (under whom the PostgreSQL server operates). However, \copy does not accept multiline queries, which is a pain if you have a long, nicely formatted query and you just want to feed it to \copy to get a result e.g. as a csv file.

2022-02-21

• 04:46 UTC (new) (history) 2022-02-21 Graph plotting in TikZ – a caveat . . . . mbork – Yet another TeX tip today – I found I wrote this over 6 years ago and never published. So, here it is. When I need to plot function graphs, the excellent TikZ package is usually my go-to solution. While I really do like TikZ, I have to say it had a nasty surprise for me.

2022-02-12

• 10:28 UTC (new) (history) 2022-02-12 tomato.el update . . . . mbork – Last year I wrote about my pomodoro-like setup with Org-mode. Since then I tweaked that a little bit and decided to share the updated code.

2022-02-07

• 08:03 UTC (new) (history) 2022-02-07 An inclined plane in tikz . . . . mbork – Look, a TeX post again! It’s been another while since I last wrote anything TeX-y here. No wonder, I hardly ever use TeX anymore – but I still do use it from time to time! A few days ago I needed to draw a diagram of an inclined plane. Interestingly, there are people who did exactly that using TikZ before (obviously), but two examples I found used the heavy artillery of trigonometry.

More...