Every so often someone needs solution to getting first (or couple of first) values for given column. Or last. For some cases (when there is not many groups) you can use recursive queries. But it's not always the best choice. Let's try ...

Couple of people asked, on irc, about how to generate unique, short, ids for rows. Since I wrote code for this for explain.depesz.com, I figured that instead of pointing to sources, and letting everyone to extract the functions, I will, instead, ...

Otto Bretz reported bug in OmniPITR. The bug was that when using -dr (remote destinations for backups) - you couldn't use --skip-xlogs. Obvious overlook on my side. Fix was trivial, and so 1.3.2 version was born.

July 31st, 2012 by depesz | Tags: , , , , , | 8 comments »

Some time ago I was looking (warning: post in polish) for someone to teach me proper parsing. One of really great polish Perl programmers - Dozzie - reached out, and helped me. By the way - thanks a lot, Dozzie. Based on ...

( wersja polska poniżej ) I (not-so) recently started to learn Python. To have some playground that I can work on, I decided to write simple website that will let me track scores of a card game that I play with ...

Every now and then somebody asks how to make diff of database schemata. Usual background is like: we have production database, and development database, and we want to see what is different on development to be able to change production in ...