PostgreSQL 9.1 in the Coverity Scan 2011: Open Source Integrity Report

PostgreSQL: the amazing blue elephant

PostgreSQL is one of my favorite Open Source projects for so many reasons:

  • It was one of the first Open Source projects that I knew (I’m a proud user since its version 8.0)
  • The PostgreSQL is simply amazing: the core developers, sysadmins, all guys work together to build and promote the best Open Source Database Management system
  • It was the main topic of my thesis in 2009, building a Open Source application to migrate Oracle 10g databases to PostgreSQL 8.3 using Python and Qt (It was a amazing time)
  • And now, I’m working everyday with PostgreSQL, acting like Sr. Software Engineer focused on helping to our customers to build high availability PostgreSQL environments on Unix/Linux platforms. It’s a awesome position that I enjoy everyday.

PostgreSQL 9.1

The last stable release of PostgreSQL is the 9.1.3; due to security update from yesterday announced by Selena Deckelmann in the mailing list. This release is one the best releases ever because, it brings a lot of good features, many of them only present in closed-source Databases systems like Oracle and IBM DB2. Some of these features, I will try to explain them here quickly:

  • Allows synchronous replication
  • Added support for foreign tables
  • Added per-column collation support
  • Added extensions which simplify packaging of aditions to PostgreSQL
  • Added support for unlogged tables using the UNLOGGED option in CREATE TABLE
  • Several updates on the PL/Python server-side language
  • Added a SECURITY LABEL command and support for SELinux permissions control
  • and a lot more

PostgreSQL is improved everyday, and many companies and organization trusts on it for its security features, stability, performance and extensibility. Hi5, InMobi, NTT, Skype, Research in Motion, Cisco, Vmware, Disqus, Urban AirShip

PostgreSQL 9.1 in the Coverity Scan 2011: Open Source Integrity Report

Coverity Scan is the largest public-private sector research project in the world focused on open source integrity, originally initiated in 2006 with the U.S Department of Homeland Security. Coverity has worked with over 300 of the most widely adopted open source projects over the past 6 years — including Linux, PHP, Apache HTTPd Server, Android and Firefox to automatically scan, or test, their software code during development.

The numbers of PostgreSQL 9.1 are simply amazing:

Lines of code scanned Defect Density (as of 12/31/11) Number of outstanding defects (as of 12/31/11) Number of defects fixed in 2011 Number of outstanding defects (as of 1/1/11) 1,105,634 0.21 233 78 247

Final Thoughts

I let to you to think about this amazing report. King regards

Happy Hacking !!!

  • Marcos Ortiz Valmaseda
  • Sr. Software Engineer (UCI)
  • Linkedin’s profile
  • @marcosluis2186


Marcos Ortiz

Marcos Ortiz