---

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

Get the Free Newsletter!

Subscribe to Developer Insider for top news, trends, & analysis