PostgreSQL is a database-users' database, CEO Davidson says. It just has to address the publicity gap it faces with MySQL.
MySQL may be winning the popularity contest for open-source databases right now, but PostgreSQL backers claim their database has more going for it.
While MySQL is developed by MySQL AB, PostgreSQL is truly open-source in that anyone can contribute to its source code, says Geoff Davidson, CEO of PostgreSQL Inc. His company provides support, consulting, training, and custom-development services for PostgreSQL users, but unlike MySQL AB doesn't sell commercial database licenses.
PostgreSQL is "a serious database-users' database" that competes head-to-head with the likes of Oracle and IBM DB2, Davidson says. It has capabilities MySQL lacks, including stored procedures, triggers, and views. But it still lacks some items most commercial databases have, such as encryption and row-level locking, according to a report from the Aberdeen Group. Version 7.5, due out around October, will offer a point-in-time recovery feature.
Netezza Corp. adopted PostgreSQL as the core of the database it developed in 2000-2001 to run inside its Netezza Performance Server 8000 data warehouse system. That allowed developers to focus on other tasks and shortened the startup's time-to-market by a year or more, says co-founder and CEO Jit Saxena.
With so much going for PostgreSQL, why has MySQL taken the lead in the open-source database race? MySQL has a friendlier user interface, Davidson says. "And we"ve got a publicity gap."
IT's Reputation: What the Data SaysInformationWeek's IT Perception Survey seeks to quantify how IT thinks it's doing versus how the business really views IT's performance in delivering services - and, more important, powering innovation. Our results suggest IT leaders should worry less about whether they're getting enough resources and more about the relationships they have with business unit peers.
What The Business Really Thinks Of IT: 3 Hard TruthsThey say perception is reality. If so, many in-house IT departments have reason to worry. InformationWeek's IT Perception Survey seeks to quantify how IT thinks it's doing versus how the business views IT's performance in delivering services - and, more important, powering innovation. The news isn't great.
InformationWeek Must Reads Oct. 21, 2014InformationWeek's new Must Reads is a compendium of our best recent coverage of digital strategy. Learn why you should learn to embrace DevOps, how to avoid roadblocks for digital projects, what the five steps to API management are, and more.