Your Daily Source for Apache News and Information  
Breaking News Preferences Contribute Triggers Link Us Search About
Apache Today [Your Apache News Source] To

Apache HTTPD Links
The Apache FAQ
PHP Server Side Scripting
Apache Module Registry
The Jakarta Project
The Apache Software Foundation
Apache-Perl Integration Project
Apache Project
Apache-Related Projects
Apache XML Project
The Java Apache Project

Internet News
Internet Investing
Internet Technology
Windows Internet Tech.
Linux/Open Source
Web Developer
ISP Resources
ASP Resources
Wireless Internet
Internet Resources
Internet Lists
Career Resources

Advertising Info
Corporate Info
PHPBuilder: Open Source Databases: As The Tables Turn
Nov 23, 2000, 12 :41 UTC (0 Talkback[s]) (1206 reads) (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...."

"I've worked with Postgres quite a bit in the past and had occasional but serious problems with reliability under some circumstances ( 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 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) 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)

  Current Newswire:
Everything Solaris: Apache: Handling Traffic

LinuxEasyInstaller 2.0 final release

Apache 2.0.32 beta is available

Everything Solaris: Apache: The Basics

Apache Jakarta James Mailserver v2.0a2 Released

PostgreSQL v7.2 Final Release

Daemon News: Multiple webservers behind one IP address

Zend Technologies launches Zend Studio 2.0

NuSphere first to enable development of PHP web services

Covalent Technologies raises $18 million in venture capital

No talkbacks posted.
Enter your comments below.
Your Name: Your Email Address:

Subject: CC: [will also send this talkback to an E-Mail address]

See our talkback-policy for or guidelines on talkback content.

About Triggers Media Kit Security Triggers Login

All times are recorded in UTC.
Linux is a trademark of Linus Torvalds.
Powered by Linux 2.4, Apache 1.3, and PHP 4
Copyright 2002 INT Media Group, Incorporated All Rights Reserved.
Legal Notices,  Licensing, Reprints, & Permissions,  Privacy Policy.