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

Notices

View Poll Results: Database of the Year
MySQL 405 36.45%
Postgres 269 24.21%
Oracle 25 2.25%
DB2 2 0.18%
Sybase 3 0.27%
Berkley DB 4 0.36%
Firebird 403 36.27%
Voters: 1111. You may not vote on this poll

 
 
Search this Thread
Old 12-01-2003, 01:14 PM   #121
mrhyde
Member
 
Registered: Jul 2003
Location: Europe
Posts: 198

Rep: Reputation: 30

I am an Oracle 9i DBA, but my personal choice is PostgreSQL.
 
Old 12-01-2003, 02:01 PM   #122
czarek
LQ Newbie
 
Registered: Apr 2003
Location: Warsaw, Poland
Distribution: Mandrake
Posts: 1

Rep: Reputation: 0
MySql

I do not know if MySql is the best, but for me it is: simple, fast and stupidity proof.
 
Old 12-01-2003, 02:46 PM   #123
Scott Marlowe
LQ Newbie
 
Registered: Jan 2003
Location: Denver, CO
Posts: 8

Rep: Reputation: 0
Re: MySql

Quote:
Originally posted by czarek
I do not know if MySql is the best, but for me it is: simple,
Check!
Quote:
fast
Check!
Quote:
and stupidity proof.
And the buzzer sounds...

Sorry, but MySQL is anything but stupidity or idiot proof.

I like it, and in ansi sql mode it's pretty good, but there are some bothersome quirks which can bite you if you aren't looking out for them, which means it isn't stupidity proof.

Insert the number 8192029039302939 into an int4 field, and MySQL silently inserts 2147483647 for you. Insert the date "green eggs and ham" and it silently inserts '0000-00-00'. Both of these are fixed in the ANSI SQL compliance mode (ask yourself, should a database have ANSI SQL compliance as an option that is off by default?) But not the biggest one, the fact that when you tell MySQL to create a table of type innodb in a database that doesn't support them, it silently creates said table with MyISAM format, and allows you to declare foreign key relations that simply don't exist, since they're on the wrong type of table, all with no errors? And there's no way to change this behaviour, the ansi switch doesn't affect it.

MySQL is, however, fast and simple, and for some tasks, it's not just a good choice but the best choice. Idiot proof takes a database like Interbase / Firebird. Postgresql certainly isn't idiot proof, but it's closer than MySQL.
 
Old 12-01-2003, 02:58 PM   #124
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,965
Blog Entries: 11

Rep: Reputation: 865Reputation: 865Reputation: 865Reputation: 865Reputation: 865Reputation: 865Reputation: 865
Re: Re: MySql

Quote:
Originally posted by Scott Marlowe
Idiot proof takes a database like Interbase / Firebird.
If firebird is idiot proof I should apply for
a job as a door-stopper :}

I must be sub-IHC standard ;) since I fail
to even install it.


Cheers,
Tink
 
Old 12-01-2003, 03:28 PM   #125
Scott Marlowe
LQ Newbie
 
Registered: Jan 2003
Location: Denver, CO
Posts: 8

Rep: Reputation: 0
Re: Re: Re: MySql

Quote:
Originally posted by Tinkster
If firebird is idiot proof I should apply for
a job as a door-stopper :}

I must be sub-IHC standard since I fail
to even install it.
Sorry, didn't mean to impugn your abilities there, Tinkster. What I meant is that for the typical user Ibase is idiot proof, and needs no maintenance and won't much up your data.

Getting it running is a pain, unless you can get it pre-installed via RPMs or something in your OS.

It has gotten easier with the 1.5 release, have you tried that?
 
Old 12-01-2003, 07:25 PM   #126
mhsabado
LQ Newbie
 
Registered: Nov 2003
Posts: 13

Rep: Reputation: 0
-----------------------------------------------------------
Originally posted by Tinkster
If firebird is idiot proof I should apply for
a job as a door-stopper :}

I must be sub-IHC standard since I fail
to even install it.
---------------------------------------------------------

The installation options stated in the firebird documentation is legal. It's just that the OS you're using is not LSB compliant (Slackware). I was able to install it without even reading the manual aside from the fact that I did it just the first time I heard of firebird (just for curiousity)
 
Old 12-04-2003, 07:56 PM   #127
kevinbe71
LQ Newbie
 
Registered: Dec 2003
Location: Chicago
Distribution: Mandrake
Posts: 1

Rep: Reputation: 0
Thumbs up Often Overlooked, Excellent DB

Quote:
Originally posted by dfcarr
Huh? That is one heck of a claim, and very, very hard to believe.
Interbase is a superb database engine and Firebird the open-source version of it.
 
Old 12-07-2003, 04:25 AM   #128
conceptx
Member
 
Registered: Dec 2003
Distribution: Slackware 10, Windows XP Pro
Posts: 33

Rep: Reputation: 15
I don't do much Dbase managment I have only tried MySQL classes and it is what I will vote for till I have tested the others ...

Ta
 
Old 12-07-2003, 09:15 PM   #129
n.weeks
LQ Newbie
 
Registered: Nov 2003
Distribution: FreeBSD
Posts: 3

Rep: Reputation: 0
Installation problems???

It seems weird that people are having trouble installing Firebird.

`cd /usr/ports/databases/firebird`
`make install`

And you're done.
Ports tree takes care of downloading source, patching, configuring, compiling, and installing for you.

Literally. Two commands.
Don't reinvent the wheel if you don't have to...
 
Old 12-08-2003, 01:26 PM   #130
darkfame
Member
 
Registered: Nov 2003
Location: Norway
Distribution: Debian Sarge
Posts: 38

Rep: Reputation: 15
Nothing beats mySQL imo.
 
Old 12-08-2003, 01:54 PM   #131
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
Re: Re: MySql

[QUOTE]Originally posted by Scott Marlowe
Sorry, but MySQL is anything but stupidity or idiot proof.

I like it, and in ansi sql mode it's pretty good, but there are some bothersome quirks which can bite you if you aren't looking out for them, which means it isn't stupidity proof.
Insert the number 8192029039302939 into an int4 field, and MySQL silently inserts 2147483647 for you.

Rubbish mySQL is not that stupid.

When I try your example I get 8192029039302939 is not a valid integer value for field 'test'
also have you never heard of default values for fields?

There is no way I can accept MySQL is that bad.
 
Old 12-08-2003, 03:27 PM   #132
coruja
LQ Newbie
 
Registered: Dec 2003
Posts: 1

Rep: Reputation: 0
Firebird!

For those who haven't tried it yet...

Simple, stable, fast, fully featured.
The best in my opinion.
 
Old 12-08-2003, 04:10 PM   #133
n.weeks
LQ Newbie
 
Registered: Nov 2003
Distribution: FreeBSD
Posts: 3

Rep: Reputation: 0
I started out with MySQL. It was brilliant!
Fast, handled great scads of data.

Then I needed Ref. Integ., Triggers, Stored Procedures, and admin-free running.
Sure, I knew it was coming to MySQL eventually, but do you use a quad-turbo Daewoo to pull a six-berth caravan?
No. You use something that was designed for the job, from the ground up.

MySQL has it's place. It should stay there, as it does it very well.

Need more features for your app? Use the right tool for the job. Use Firebird.
 
Old 12-11-2003, 02:45 PM   #134
Scott Marlowe
LQ Newbie
 
Registered: Jan 2003
Location: Denver, CO
Posts: 8

Rep: Reputation: 0
Re: Re: Re: MySql

Quote:
Originally posted by buttersoft
Rubbish mySQL is not that stupid.

When I try your example I get 8192029039302939 is not a valid integer value for field 'test'
also have you never heard of default values for fields?

There is no way I can accept MySQL is that bad. [/B]
Here's an exact cut and paste from MySQL 3.23.41 on my computer as I sit in front of it right now:

mysql> create table test (i1 int4);
Query OK, 0 rows affected (0.00 sec)

mysql> insert into test values (8192029039302939);
Query OK, 1 row affected (0.00 sec)

mysql> select * from test;
+------------+
| i1 |
+------------+
| 2147483647 |
+------------+
1 row in set (0.00 sec)

Maybe you've got the --ansi switch turned on on yours, but by default, 99% of all MySQL databases are running without it, and turning it on breaks a fair number of applications that use it.

Maybe you should do some research next time before calling rubbish.

and yes, I've heard of default values. What's your point? (besides the one under your hat mayhaps.)
 
Old 12-11-2003, 03:31 PM   #135
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
Ok more research next time. I did try it out and it would not let me do the update.

So I have more to learn, apologies then.
 
  


 


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
1 year from now... ghostwalker Linux - General 18 01-13-2006 08:38 PM
Snort database: Closing connection to database "" Homer Glemkin Linux - Security 2 07-14-2005 06:58 PM


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

Main Menu
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