PostgreSQL: The Other Open-Source Database - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

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
2021 State of ITOps and SecOps Report
2021 State of ITOps and SecOps Report
This new report from InformationWeek explores what we've learned over the past year, critical trends around ITOps and SecOps, and where leaders are focusing their time and efforts to support a growing digital economy. Download it today!
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

Commentary
Why IT Leaders Should Make Cloud Training a Top Priority
John Edwards, Technology Journalist & Author,  4/14/2021
Slideshows
10 Things Your Artificial Intelligence Initiative Needs to Succeed
Lisa Morgan, Freelance Writer,  4/20/2021
Commentary
Lessons I've Learned From My Career in Technology
Guest Commentary, Guest Commentary,  5/4/2021
Register for InformationWeek Newsletters
Video
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
White Papers
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.
Sponsored Video
Flash Poll