database

The folks over at Geeklog have announced that their blogging application now supports PostgreSQL. Geeklog's move is similar to other open source projects that have recently diversified their support for more additional database management systems.

Dear Geeklog users, today we are proud to announce the public availability of Geeklog with beta PostgreSQL support. This is the culmination of a Google Summer of Code project to implement this feature. PostgreSQL support builds on the already impressive list of MySQL and MSSQL support. This continues to improve Geeklog’s interoperability, which now offers support for the most popular relational database management systems.

Support for Postgres currently is in beta and "should strictly be used on local and testing environments". Geeklog also supports MySQL and and MSSQL.

Work is currently underway to provide an extension so that SilverStripe can run on Microsoft SQL Server 2008.  The SilverStripe module allowing for this connection to the SQL Server is currently still being developed, but the alpha version according to Sigurd Magnusson does work.

Other than that, we're using the code with success internally, and know others in the community are too. We're mentioning this SQL Server milestone in the blog to let you know that the feature is well on its way, and to allow careful developers a chance to try it out, provide feedback, and files bugs before we mark it as a publicly stable module.

SilverStripe, as with many PHP-based content management systems, has historically only supported MySQL for it's database.  Besides MS SQL, SilverStripe also hopes to be able to run on additional databases such as PostgreSQL and SQLite.

Like a lot of people, I too wonder what will happen to the MySQL, Java, and hardware once Sun is integrated into Oracle.  I have opinions but those opinions alone aren't worth a hill of NetBeans.  Luckily, people like Gavin Clarke know what they're talking about.  Clarke has written an excellent article at The Register titled,  Sun and Oracle: end of a beautiful dream.

Oracle will take the decisions Sun could not, and that's what'll have people at Sun worried. And while change should be welcomed, there's no way this should be seen as a bright new dawn for Sun customers or those who've come to believe in its actions on open source or Java.

The first thing you can expect from a Oracle acquisition is due-diligence of the assets and a comparative analysis where Oracle has competing assets. Oracle will weigh up what's worth keeping and jettison the rest. The latter will be marked by end-of-lifing via support and maintenance, or releasing code to the community - where it will fade and die.

The article isn't as gloomy as the title or the above excerpt would imply. However, the article is pragmatic and leaves little room for dreamers.  Be sure to read the article!