Hello all, and welcome to this week’s edition of the PostgreSQL Weekly News, openSUSE-style!
As accustomed, we’ll start with news picked from the mailing lists, then we’ll move on with news from the PostgreSQL Planet. Here we go…
-We start off this week with Mark Hills’ announcement of the release of pgnotifyd, which, if we listen to Mark, ” connects to a PostgreSQL database, listening for the named asynchronous notification. When notification is received it executes the given command.
It is typically a cleaner and more efficent alternative to polling a PostgreSQL database for changes (using a crontab(5) or similar.)
I’ve been using it successfully to synchronise passwords and mailing lists. This is an initial release in the hope others can benefit from it.”
You can find out more here : http://www.pogo.org.uk/~mark/pgnotifyd/ .
-Oleg Bartunov announced he posted pictures from PgCon 2010; you can watch here : http://www.flickr.com/photos/obartunov/sets/72157624042768831/ .
-Giuseppe Maxia announced OpenSQL camp 2010; I will try to copy the most relevant stuff from his announcement, in order not to make this article too big :
“OpenSQL Camp is a free conference of, by, and for the open-source database community of users and developers. The OpenSQLCamp 2010, European Edition (http://opensqlcamp.org/) will take part in parallel to the Free and Open Source Conference 2010 (http://froscon.org/) on Saturday 21st and Sunday 22nd August in St. Augustin, Germany, which is located close to Bonn and Cologne.[…] We would like to invite your project to participate in this event.
We’ve set up a call for participation (http://opensqlcamp.org/Events/2010/Call_for_Participation) – the deadline for submitting your proposal is July 11th.
We are seeking talks related to Open Source Databases of all kind, not just relational databases! Submission about tools and technologies related to OSS databases (e.g. connectors/APIs) are also welcome.
Some ideas and for submissions:
* A how to presentation, showing how to solve a common problem in the database field.
* An introduction/overview about a certain database project/product or related tool
* Providing “best practices” information for administrators
* A deeply technical and developer-centric session about some project’s internals or an API used to connect to a database.
We look forward to your contribution! Please don’t hesitate to contact us via IRC (#opensqlcamp on FreeNode) or our Discussion Group (http://groups.google.com/group/opensqlcamp) ”
-Bruce Momijan announced the timetable for the release of 9.0, which would be as follows : “Assuming we want a release Postgres 9.0 by mid-August, here is how the timetable would look:
Need RC release to be stable for 1-2 weeks before final
RC must be released by August 1
Beta must be stable for 2-3 weeks before RC
Stable beta must be released by early July
So, we have 5-6 weeks to get a stable beta. Looking at the open issues: http://wiki.postgresql.org/wiki/PostgreSQL_9.0_Open_Items#Resolved_Issues
it looks like we are doing OK, but we must continue progressing.”
-The ChronicDB release team announced version 2.2.2 ; ChronicDB is a live DB schema update system, allowing DBAs to minimize the downtime of their servers. More on their website, http://chronicdb.com/
-On the Planet , we have Christophe Pettus posting his slides from the Open Bridge 2010 conference, called Introduction to PostgreSQL, here : http://thebuild.com/presentations/intro-to-postgresql-osb2010.pdf.
-The PostgreSQL Weekly News this week offers some local events info, as well as, as usual, the submitted patches list. Check out the news here : http://www.postgresql.org/community/weeklynews/pwn20100531.
There you go, this was the news this week. Enjoy your weekend.