LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > LinuxQuestions.org > 2005 LinuxQuestions.org Members Choice Awards
User Name
Password
2005 LinuxQuestions.org Members Choice Awards This forum is for the 2005 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite products of 2005. This is your chance to be heard! Voting ends March 6th.

Notices



Poll: Database of the Year
Poll Options
Database of the Year

You must log in and have one post to vote in this poll. If you don't have an account, you can register here.
Results will be available after the polls close.

The nominees are:

MySQL
PostgreSQL
Firebird
Oracle
Sybase
DB2
Berkley DB
sqlite
InnoDB
EnterpriseDB

Reply
 
Search this Thread
Old 03-10-2006, 10:48 AM   #121
decibel
LQ Newbie
 
Registered: Nov 2003
Posts: 25

Rep: Reputation: 15

Quote:
Originally Posted by jcs32
Although slightly off-topic I would say we are both right, depending on the interpretation.

http://en.wikipedia.org/wiki/Division_by_zero

there especially "Under the standard rules for arithmetic on integers, rational numbers, real numbers and complex numbers, division by zero is undefined. Division by zero must be left undefined in any mathematical system that obeys the axioms of a field."
Hrm. A quick google (ansi sql divide by zero) shows that ANSI SQL92 apparently requires that division by zero is an error. Unfortunately, http://troels.arvin.dk/db/rdbms/ doesn't tell us what most databases do, though that google search tends to indicate that Sybase and MSSQL are the only two that give you an option here (which at least on MSSQL defaults to divide by zero is an error). Google shows that Oracle, DB2, Firebird and (I think) SQLite all consider 5/0 an error. So even if math folks have decided that division by zero is undefined, databases certainly feel it an error (actually computers in general deem it to be an error). So, yet another case where MySQL throws out the standards for no good reason. If they had wanted to allow this for people who it would make life easier on, the correct way would have been to provide an option to allow divide by zero = NULL, and have it default to off (ie: what MSSQL does). But MySQL has never seemed to be interested in doing things the right way.
 
Old 03-31-2006, 03:48 PM   #122
James Day
LQ Newbie
 
Registered: Mar 2006
Posts: 3

Rep: Reputation: 0
Quote:
Originally Posted by decibel
Quote:
Originally Posted by fikret
MySQL now have one of Database pioneers, Jim Starkey, who created Interbase (count Firebird here too) so their future looks bright, but only if they do what Jim says :-)
MySQL is NOT open, with their dual license... Firebird and PostgreSQL are!
That's an if that's unlikely to happen. They've had some clued folks over there for years, yet there's still all kinds of broken-ness.
I spent the week before last at a gathering of a hundred or so full time employee MySQL developers. That included much face to face architecture discussion with Jim and Ann and others. Jim is listening to MySQL people and MySQL people are listening to Jim. It was a fun week. Lots of really productive activity.

There's broken-ness. Nobody should bet their business on it remaining.
 
Old 01-25-2007, 10:50 AM   #123
cachemonet
Member
 
Registered: Jan 2006
Distribution: Various versions of Red Hat Fedora Core and Ubuntu
Posts: 40

Rep: Reputation: 15
Mysql. Its all I use because....well...........its all I know.
 
Old 01-25-2007, 11:00 AM   #124
decibel
LQ Newbie
 
Registered: Nov 2003
Posts: 25

Rep: Reputation: 15
Quote:
Originally Posted by cachemonet
Mysql. Its all I use because....well...........its all I know.
If the only car you knew was a Yugo, would you vote it car of the year over a Rolls Royce?
 
Old 01-26-2007, 01:59 PM   #125
James Day
LQ Newbie
 
Registered: Mar 2006
Posts: 3

Rep: Reputation: 0
I'd vote for the Yugo if I wanted to take over the world. The Rolls Royce manufacturing doesn't scale while I've used MySQL at Wikipedia in place that scaled from one shared box to top 10 web site in the world. All have interesting properties but MySQL is the open source one that's been proved in practice by lots of people. I've also used Sybase, Oracle and MS SQL Server in the past, but not for that level of performance demand. Nobody would argue that a Yugo is pretty but it is cost-effective when it comes to getting people moved from one place to another.
 
Old 01-28-2007, 03:14 AM   #126
decibel
LQ Newbie
 
Registered: Nov 2003
Posts: 25

Rep: Reputation: 15
Quote:
Originally Posted by James Day
I'd vote for the Yugo if I wanted to take over the world. The Rolls Royce manufacturing doesn't scale
Perhaps you should take note of which car manufacturer is still in existence.

Yes you can make MySQL scale... with a hell of a lot of work. Just like you can safely store data in it... with a hell of a lot of work.
 
  


Reply

Tags
members choice awards


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Snort database: Closing connection to database "" Homer Glemkin Linux - Security 2 07-14-2005 07:58 PM


All times are GMT -5. The time now is 07:53 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration