Marcin Borkowski: Recent Changes

Updates in the last 30 days

2023-05-29

18:39 UTC (new) (history) 2023-05-29 A PostgreSQL query to set the serial counter . . . . mbork – Some time ago I encountered an unpleasant bug I made in a certain PostgreSQL query.

2023-05-20

05:27 UTC (new) (history) 2023-05-20 How to filter rows with duplicate ids in a csv . . . . mbork – Some time ago I encountered an interesting problem. I had a CSV file (imported from a database), and I wanted to see only rows for which a certain column was duplicated.

2023-05-13

11:46 UTC (new) (history) 2023-05-13 Dieting with Org mode . . . . mbork – Some time ago I started to weigh myself every day. Some people argue that this is a bad idea and you should weigh yourself once per week to avoid worrying about random fluctuations. I disagree – the way not to worry about random fluctuations is to look at moving averages instead, Hacker's Diet-style. Note: I do not necessarily endorse Hacker’s Diet as a whole, but the moving average approach is certainly a good one. For the sake of simplicity, I am going to use simple (unweighted) moving averages over one week. I want to keep my weight data in an Org mode table (obviously).

2023-05-06

08:21 UTC (diff) (history) Comments on 2023-05-06 Juggling playlists in EMMS . . . . mbork – Thanks, I had no idea that exists! I'll check it out.
06:12 UTC (new) (history) 2023-05-06 Juggling playlists in EMMS . . . . mbork – It’s been several times now that I described my productivity system here. While I like it a lot, it still has room for improvement. Some time ago I mentioned it to a colleague and shared one frustration I have with it. When I fail to do even one thing on my carefully prepared plan for a day (which happens once in a while, of course), sometimes I lose motivation and skip more subsequent items. This leads to spending less time on things I want to do and more time on procrastination that day. It happens seldom enough not to be a real issue (and it doesn’t mean I fail to do anything – just less than usual or hoped for), but it is a bit frustrating. He suggested a pretty clever (and obvious in hindsight) way to deal with this. His idea is to have a separate music playlist „for work” and train my brain to associate that particular music with focused work. That way I would have another nudge to do particular kind of stuff.