ads' corner

Run your own Dynamic DNS server

Dyn, the company behind the widely known dynamic DNS service DynDNS, will shut down it’s free service effectively May 7th, 2014. Of course there are plenty of other free or freemium services out there, but history will repeat itself and these services will vanish over time, or change their business modell.

A while ago I spent an afternoon to implement my own dynamic DNS service.

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.

PostgreSQL @ CeBIT 2010

The PostgreSQL User Group Germany were given the opportunity to have a booth at CeBIT 2010 and present the project. CeBIT is a very big IT-related exhibition and takes place in Hannover, Germany.

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.

BOOLEAN datatype with PHP-compatible output

If you use pure PHP (no database abstraction layer) with PostgreSQL, you may run into the problem that your BOOLEAN columns are not recognized by PHP but the value is instead returned as a string.

MUA changed

Finally, after (I think) 13 years, I switched my mail user agent from pine to mutt. Not that I like the latter more, it has other problems and/or ways of handling mails which I don’t like. But the (non-existent) pgp support in pine drove me crazy. After configuring a while around, more than 300 .muttrc config lines and some Perl scripts to create send-hooks from nicely configured roles later, I have almost the same behaviour like before.