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

"I've worked with Postgres quite a bit in the past and had occasional but serious problems with reliability under some circumstances (Geocrawler.com runs on Postgres and had a tendency to melt down every few months, losing some data in its 10GB database). So I began evaluation of Postgres 7.1 with some trepidation. My benchmarks in July showed PG 7.0 to be clearly slower than MySQL and I outlined several limitations that I found annoying. Still, Postgres has dozens of advanced features that MySQL lacks (triggers, foreign keys, rules, subselects, views...) and was well worth investigating."

Complete Story

Related Stories:
PHPBuilder: PHPLIB and multiple databases(Nov 13, 2000)
OSFAQ: How to create a database driven website (PHP/MYSQL)(Nov 05, 2000)
PR: NuSphere to Contribute Row-Level Locking to MySQL Database(Oct 30, 2000)
LinuxProgramming: Oracle Shows Microsoft How a 600-pound Gorilla Ought to Behave(Aug 10, 2000)
IW: AbriaSoft Partners With O'Reilly And Associates To Release Its First Packaged MySQL Distribution(Aug 08, 2000)
PHPBuilder: Database Normalization And Design Techniques(Aug 07, 2000)
MySQL.com: MySQL Goes GPL [& VA Linux Invests](Jun 28, 2000)
BW: VA Linux Forms Strategic Alliance With MySQL; MySQL Becomes Completely Open Source(Jun 28, 2000)
BW: Progress Software Helps Free MySQL With GPL License(Jun 28, 2000)
geeks404.com: Setting Up an Internet Database: Preparations(Jun 08, 2000)
PHPBuilder: Building Dynamic Pages With Search Engines in Mind (May 28, 2000)
PHP 4.0 -- Dynamic Content for the World Wide Web Warrior(May 25, 2000)