ads' corner

Daddy elephant, mommy elephant and a herd of childs

For FOSDEM, I ordered a new set of blue plush elephants. The parcel arrived today and this time I not only got the usual 18cm stuffed toys, I also got 2 which are 60cm height. Anyone interested? ;-)


FOSDEM 2008 and election for EU user group

As announced back in December, the PostgreSQL Group has a developer room at FOSDEM 2008 in Brussels, together with the BSD team.


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.


table size, database size

I have seen this question more than once in the past: “How much storage space do I need for my table?”

PostgreSQL can give you this information.


FOSDEM 2008

Together with BSD we will have a Developer Room at FOSDEM 2008.


stop psql on first error

Because I always forget how to stop psql on the first error:

1
\set ON_ERROR_STOP

You can include this at the top of your script/file, psql will stop right after the first error and will not try to continue any other commands in the chain.


Performance issues

Last year, tweakers.net did some performance tests with MySQL and PostgreSQL and they found out that MySQL did not scale very well with many concurrent connections.


Finally back home

After a long trip I finally arrived back home. Because the way from Italy back to Germany is very long, I made a stop in Munich and met some old friends. From the moment Stefan and I had entered Austria until I was in Munich, it was heavily raining. After having sunshine and 30 or more degree in Italy this was really sobering.


Weekly PostgreSQL newsletter

We just finised and mailed the PWN … this time David and I was posting to our list at exactly the same time ;-)


PGDay.it ended

PGDay.it is over, it was a really impressive conference with a lot of good talks. The people from the Prato Linux User Group did a really good job. I met many people which I only knew from mail or irc, had some interesting discussions and of course we had fun ;-)