8 messages in com.mysql.lists.javaRe: mysql gets rubbished| From | Sent On | Attachments |
|---|---|---|
| Frank Daly | 08 Mar 2001 00:55 | |
| Frazer Dixon | 08 Mar 2001 01:45 | |
| Ron Pool | 08 Mar 2001 06:09 | |
| Pete Carapetyan | 08 Mar 2001 06:51 | |
| David Halsted | 08 Mar 2001 18:30 | |
| Sohaila Roberts | 09 Mar 2001 07:02 | |
| Carfield Yim | 09 Mar 2001 10:14 | |
| Dror Matalon | 09 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.
Dave Halsted
----- Original Message ----- From: Pete Carapetyan <pe...@datafundamentals.com> To: Ron Pool <am...@nysaes.cornell.edu> Cc: <ja...@lists.mysql.com> Sent: Thursday, March 08, 2001 9:52 AM Subject: Re: mysql gets rubbished
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.
-- Ron Pool Internet: am...@cornell.edu Computer Services, NYSAES; Food Research Lab; West North St.; Geneva, NY 14456
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java...@lists.mysql.com
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
--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java...@lists.mysql.com
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.




