PostgreSQL: The Other Open-Source Database - InformationWeek
IoT
IoT
Feature
News
7/20/2004
10:14 AM
Rick Whiting
Rick Whiting
Features
50%
50%

PostgreSQL: The Other Open-Source Database

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."

Return to main story: "Open Source, Open Questions"

Continue to the sidebars:
"Comeback: CA Goes Open Source With Ingres Database"
and "Growing Third-Party Vendor Support For MySQL"

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
Comments
Newest First  |  Oldest First  |  Threaded View
2017 State of IT Report
2017 State of IT Report
In today's technology-driven world, "innovation" has become a basic expectation. IT leaders are tasked with making technical magic, improving customer experience, and boosting the bottom line -- yet often without any increase to the IT budget. How are organizations striking the balance between new initiatives and cost control? Download our report to learn about the biggest challenges and how savvy IT executives are overcoming them.
Register for InformationWeek Newsletters
White Papers
Current Issue
Top IT Trends for 2018
As we enter a new year of technology planning, find out about the hot technologies organizations are using to advance their businesses and where the experts say IT is heading.
Video
Slideshows
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll