postgreSQL

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.

Alfresco Software released a press release on the results of a survey by them intended to help determine "how companies evaluate and deploy open source and proprietary software stacks in the enterprise". There is some very interesting numbers summarized in the press release that should be of interest to not only using those Alfresco products, but to almost anyone using enterprise software. Some of the more interesting numbers and statistics pulled from the study:

• Operating system: “Users evaluate on a Windows laptop and deploy on Linux” – 41% of evaluations were on Windows, dropping to 26% for deployments, whereas 51% of deployments were on Linux.
• Linux: “Ubuntu and Red Hat pull away, SUSE remains flat by comparison in the US” – Ubuntu 24%, Red Hat Enterprise Linux 21%.
• Windows: “Users stick with XP and 2003, Vista lags at 2%” – XP 63%, Windows 2003 28%.
• Databases: “Sun still shines on MySQL” – MySQL 60%, Oracle 14%, MS SQL Server 13%.

I especially find it interesting that while open source MySQL is the dominate database used on the enterprise, two propriety database systems (Oracle and MS SQL) follow. I wonder where PostGresSQL falls on the list? But wait, there are two points I want to make about this study.

"PostgreSQL developers expect that the new version will drive such migrations /from Oracle, IBM DB2, or Microsoft SQL/ because of the improved performance, features and administration capabilities. They anticipate an overall performance gain of between 10 percent and 20 percent for most applications.

PostgreSQL 8.2 is also taking aim at the open source MySQL database."

Complete Story