8 messages in com.mysql.lists.javaRe: mysql gets rubbished
FromSent OnAttachments
Frank Daly08 Mar 2001 00:55 
Frazer Dixon08 Mar 2001 01:45 
Ron Pool08 Mar 2001 06:09 
Pete Carapetyan08 Mar 2001 06:51 
David Halsted08 Mar 2001 18:30 
Sohaila Roberts09 Mar 2001 07:02 
Carfield Yim09 Mar 2001 10:14 
Dror Matalon09 Mar 2001 10:55 
Subject:Re: mysql gets rubbished
From:David Halsted (hals@tcimet.net)
Date:03/08/2001 06:30:47 PM
List:com.mysql.lists.java

I couldn't agree more. Companies would save huge amounts of money if they took intelligent advantage of open source options where appropriate. For what it matters, I asked Monty Widenius about stored procedures at the MySQL session in Monterey last year. He made a point that I've since used in discussions with others -- stored procedures are essentially a mechanism to prevent programmers who don't understand the database from messing up, or providing other kinds of security. If the programmers actually understand the structure (so Monty) they don't really need foreign keys or triggers either.

I guess I've concluded that small projects, projects without terribly complex data structures and projects in organizations with clued programmers should take MySQL very seriously as an option. In such situations, the benefits far outweigh the risks, even in production situations. The replication now available, for example, allows active-passive failover without a lot of effort. Even if only a few projects within an organization are appropriate for MySQL, the money saved can be quite substantial. You have to be careful about negative claims, too. Epicentric, a portal-software company, claims that MySQL is a security risk if used in production installations of their product, but if you look closely at the claim you see that the problem actually lies with the way in which Epicentric chooses to handle the deletion of user accounts.

At the risk of attracting flamebate, I would concur with others who have stated that 95% of the work that databases do is not mission critical, ACID comliant work. Especially if databases are used as much as they should be for proper programming architecture.

Consider even a mission critical site such as an ecommerce site. Most of the database work there involves guiding the customer through a set of choices, which, in most cases does not have to be perfectly ACID. Even in this situation, separating the financial transactions off into a separate Oracle database takes care of the problem.

Ron Pool wrote:

On Thu, 8 Mar 2001, Frank Daly wrote:

This is pretty damming.

http://openacs.org/philosophy/why-not-mysql.html

anyone got any views, news on this.

I recall reading that article last year. That was before transactions, etc were added to MySQL. If you read through the comments that follow the article you'll see mention of the new features that have been added to MySQL.

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java@lists.mysql.com instead.

-- Pete Carapetyan http://datafundamentals.com Java Development Services

Open standards technology for commercial profitability

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java@lists.mysql.com instead.