ads' corner

This month’s #PGSQLPhriday is hosted by Lætita Avrot, and she asks about triggers.

History time. Shortly after I started using PostgreSQL, I had a need to track changes in tables. Back then - this was the early version 7.x days - there was no such option available. I set out to write a tool for it. The logical choice to do that was to pick triggers to implement this. Today the world is different, PostgreSQL gained replication, and along with this, one can hook tools into the replication and stream all the changes. Back then there was no replication.

My kid got a new project: find fire stations. Google Maps is not really helpful here, obviously. And searching in the OpenStreetMap web interface is also a lot of work. But Overpass Turbo is able to find all the places.

When you open the Overpass Turbo page, it starts in Rome, Italy, at the Colloseum. That’s nice, but likely not the place you are looking for. Either scroll to the area you are interested in, or use the search function.

The left side of Overpass Turbo is the input field. You draft queries in a specific language, named Overpass QL (QL). Once you hit the Run button, the right side of the window either shows you the map, or the data output.

As requested here are the pictures from sunday after PGDay.

The Italians decided that we will have lunch in a good restaurant outside of Prato. At 11am, Gabriele joined the hungry crowd in the hotel, 10 Italian minutes later we also had enough car space available for all people ;-) So we drove to Montepiano and there’s the wonderful Ristorante Margherita:

For you:

There will be a keysigning party at PGDay.(it|eu) in Prato/Italy. The event is the last track on Friday in the evening, probably around 16:50-17:30 (that’s 4:50-5:30 pm).

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.

Seen in an Italian restaurant:

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

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