ads' corner

New PostgreSQL pg_docbot is live

Last night a long-running project of mine went live: pg_docbot v2.

For years, Jan Wieck provided a helper bot (rtfm_please) in the #postgresql IRC channel in the freenode network. Because of protocol changes in the freenode network, this bot was no longer functional. Together with some others we decided to write a quick and dirty new bot. As it is with dirty hacks, not everything was optimal: after timeouts the bot was not able to reconnect - more exactly the POE framework did not even recognize the timeout. Also extending the bot and adding new functionality was complicated. For a while I collected all these problems in my personal bugtracker and about two years ago I started a full rewrite.

Making life easy for new (and old) PWN translators

I released version 3.0 of the pwn-translation script. Although the version number is already 3.0, this is the first public available version.

Unterlagen für Tutorial beim Perl-Workshop in Frankfurt/Main

Die Unterlagen für das Tutorial beim Perl-Workshop 2009 in Frankfurt/Main am 25.02.2009 sind unter:

PostgreSQL and the Perl Workshop 2009 in Frankfurt (Main)

There will be a workshop “optimize PostgreSQL, combine Perl and PostgreSQL” at the Perl Workshop 2009 on February 25 in Frankfurt/Main in Germany.

Single line input for psql copy command

I have the following problem:

A database server and another client machine. I have to execute several \copy commands in psql on the client machine to retrieve data and store the output in CSV files. The PostgreSQL COPY command is not an option because it stores the results on the database server, not the client machine. All \copy commands are executed from several files containing SQL commands, which are concated together by a Makefile and feeded into psql. So far so good.

new screen_away version for irssi finally online

After exact 364 days the irssi folks published my last version which includes SILC support.