≡ Menu

Postgresql

MySQL vs PostgreSQL

WikiVS has published detailed comparison between MySQL and PostgreSQL. From the pages:

MySQL vs PostgreSQL is a decision many must make when approaching open-source relational databases management systems. Both are time-proven solutions that compete strongly with propriety database software. MySQL has long been assumed to be the faster but featureless of the two database systems, while PostgreSQL was assumed to be a more densely featured database system often described as an open-source version of Oracle. MySQL has been popular among various software projects because of its speed and ease of use, while PostgreSQL has had a close following from developers who come from an Oracle or SQL Server background.

=> MySQL vs PostgreSQL from the open comparison website.

Download of the day: phpBB version 3 ( phpBB Gold )

phpBB final version 3 has been released and available for download. phpBB is a popular Internet forum package written in the PHP programming language.

New Features in phpBB3

* Modular design for the Admin Control Panel, Moderator Control Panel, and User Control Panel.
* Support for multiple database management systems, including MySQL, Microsoft SQL Server, Oracle, PostgreSQL, SQLite, and Firebird.
* Support for unlimited levels of subforums.
* Ability to create custom-defined BBCode.
* Ability to create custom profile fields.
* Greatly expanded permissions system.

From the announcement email:

The project has changed considerably since work on its second major release began. With a raft of new features requested by users and new ideas introduced by its developers, phpBB3 is more able than ever to support the new "social networking" trend. Security too has been a top priority with particular attention paid to reduce or eliminate the problems of the past. Indeed unusually for a project of this nature an independent security audit was performed to better ensure a safer future for its users.

So with great pride phpBB wishes to thank all of its developers, designers, team members and of course its community - please enjoy phpBB3.

Download phpBB version 3

=> Visit official web site to download phpBB stable version 3 (2.15 MiB)

Solaris 10 update 8/07 has been released and available for download. From the announcement page:
The latest update of the Solaris OS helps customers alleviate common enterprise problems such as virtualization, resource management, and system performance. Solaris delivers built-in investment protection and new technologies that are even better suited to data intensive environments where price and performance are driving factors:

New updated features

=> Solaris Containers for Linux Applications and integrated support for Logical Domains
=> Update to the performance-optimized and cost-effective PostgreSQL open-source database software.
=> Ability to run multiple independent network stacks on one system
=> Networking and DTrace technology enhancements

Best of all, it's free to download and use. The only thing customers pay for are the support and services, which range in scope and price to suit the needs of individual developers and companies of all sizes.

Download Sun Solaris 10 UNIX CD / DVD ISO

=> Visit official site to download Solaris ISO images.

Howto Setup PostgreSQL in the OpenSolaris OS

This article describes key features of PostgreSQL 8.2, which have been available in OpenSolaris since build 66. You know the PostgreSQL logo is an elephant: Find out why the PostgreSQL 8.2 features in OpenSolaris are huge.

PostgreSQL in the OpenSolaris OS