Linux Today: Linux News On Internet Time.

PHPBuilder: Open Source Databases: As The Tables Turn

Nov 13, 2000, 21:29 (0 Talkback[s])
(Other stories by Tim Perdue)

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