ads' corner

Another PGUG shirt

Today Mr. Postman brought me a letter:


New PGUG shirt

Found a manufacturer here in my hometown who does stitchery and ordered a test shirt for me:


Talks for PGDay accepted

Just got two mails, the PGDay.it staff accepted both talks I had submitted. One talk will be about my table_log, the other about migrating web platforms from Mysql to PostgreSQL.


Linuxday 2007 visit in Berlin

I’m just back from my one-day trip to the Linuxday 2007, this year in Berlin. The German PG User Group was not present with a booth. My trip was (among other things) to decide, if we will have a booth next year.


Two talks for PGDay submitted

I’ve submitted two talks for PGDay, one about my tablelog extension for PostgreSQL, the other one about migrating web-based community platforms from MySQL to PostgreSQL.

Will see, if they will get accepted.


Free Software Magazine article about PGDay 2007

The Free Software Magazine has a nice article about the organisers and the organisation of the PGDay 2007 in Italy:


Got some lanyards

Just got a parcel with some of them:


This years april fool

Too pity, this news is only an april fool:


PostgreSQL booth at FOSDEM 2007

The PostgreSQL Usergroup Germany will have a booth at the FOSDEM 2007 in Brussels. Many of the usual suspects from the European Communities will be there.


Ringbuffer in SQL

On a student platform we show, on every page, a random user in the upper right corner. Because we have over 11.000 users, the database has to select all matching users and sort them by random(). Thats very expensive and one of the longest running queries in the current version. And because we are currently redeveloping the whole platform, I decided to try something different for the random user. The user must not be really random, it should be enough to just display a different user every time the page is displayed. My idea was to implement a ringbuffer in SQL and forward the pointer to the next user in the buffer if we need to search the next random user.