PHPBuilder: Open Source Databases: As The Tables Turn

"My July Article comparing PostgreSQL and MySQL caused a stir that really surprised me. Of course, users of both databases called the tests rigged one way or the other, even though I noted that both databases had their strong points under various circumstances."

"All that aside, we've been running into some rather grim and serious MySQL problems on SourceForge - most of which are directly related to MySQL's table-level locking mechanism. To give us some breathing room, we've been running a Beta version of MySQL with pretty good success."

"Those problems and other MySQL limitations have caused me to evaluate database alternatives, first Interbase (apparently a dead end), then PostgreSQL."

"It didn't take long to rule out Interbase after discovering that it lacked replication, full text indexing, and had serious community and corporate issues around its "Open Sourceness."

"Postgres also lacks replication and full text indexing (MySQL's latest betas include both features), however the postgres people issued a press release about replication (currently vaporware) and it will be coming soon."

Complete Story

Related Stories:

• Upside: Those nagging open source details [Notes from the Open Source Database Summit] (Nov 01, 2000)
• Apache Today: NuSphere to Contribute Row-Level Locking to MySQL Database(Oct 30, 2000)
• O'Reilly Network: Getting Started with SQL(Oct 29, 2000)
• O'Reilly Network: What's the Big Deal about SQL?(Oct 29, 2000)
• In Context: Follow the Money; Cathedral Investments in the Bazaar(Oct 20, 2000)
• Enterprise Linux Today: Leading PostgreSQL developers join Great Bridge(Oct 11, 2000)
• Enterprise Linux Today: SAP Drives Open-Source Database Development(Oct 05, 2000)
• IW: AbriaSoft Releases Abria SQL Standard, First Ever Box Packaged Distribution Of MySQL...(Aug 23, 2000)
• CNET News.com: First CEO exits open-source software start-up [Great Bridge](Aug 17, 2000)
• BW: Open Source Database [PostgreSQL] Routs Competition in New Benchmark Tests(Aug 15, 2000)
• PHPBuilder: MySQL and PostgreSQL Compared(Jul 10, 2000)
• O'Reilly Network: How PostgreSQL Rose to Fame(Jun 17, 2000)
• Security Portal: SQL: Friend and Foe(Apr 20, 2000)