LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
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

View Poll Results: Database of the Year
MySQL 660 62.98%
PostgreSQL 168 16.03%
Firebird 83 7.92%
Oracle 44 4.20%
Sybase 4 0.38%
DB2 16 1.53%
Berkley DB 10 0.95%
sqlite 59 5.63%
InnoDB 1 0.10%
EnterpriseDB 3 0.29%
Voters: 1048. You may not vote on this poll

Reply
 
Search this Thread
Old 02-19-2006, 05:55 AM   #46
darthtux
Senior Member
 
Registered: Dec 2001
Location: 35.7480 N, 95.3690 W
Distribution: Debian, Gentoo, Red Hat, Solaris
Posts: 2,070

Rep: Reputation: 45

MySQL baby !!
 
Old 02-19-2006, 07:06 AM   #47
LibraLog
LQ Newbie
 
Registered: Nov 2003
Posts: 1

Rep: Reputation: 0
Firebird all the way!
 
Old 02-19-2006, 01:06 PM   #48
fikret
LQ Newbie
 
Registered: Jan 2005
Posts: 28

Rep: Reputation: 15
Today it became generally known that MySQL has aquired a company called Netfrastructure. This company offers a product which is a reimplementation of the Firebird database architecture, combined with a web-based application server front end. It was designed by Jim Starkey in the late nineties and combines a database, a custom java virtual machine and a web server. Jim Starkey is also the principal author of Datatrieve, Rdb/ELN and InterBase, which became Firebird after being open-sourced in 2000.

Since the aquisition of InnoDB, by Oracle, MySQL has been in a difficult position: InnoDB was the centre piece of its 5.0 release. It has been discussed extensively in the Firebird community that MySQL should make a strategic move and use Firebird as its enterprise level relational/transactional engine.

MySQL chose this path — in a round-about sort of way — by making the aquisition of Netfrastructure and hiring Jim Starky, owner of Netfrastructure. Jim had recently been contributing to the Firebird project, under contract by one of the project’s sponsoring companies.

This move by MySQL validates that Firebird has the most mature and featured full open source code base and seems to indicate that the MySQL database product will be moving in similar paths from now on. MySQL also stands a lot to gain from the fact that the Firebird project has about 50 developers working on this architecture and helping to drive it into the future. The Firebird project gains from a well-known name and large sales force introducing its technology to customers world-wide.

Market researcher Evans reported early in 2005 that MySQL was used by 40% of developers, immediately followed by Firebird with 39%. The acquisition means that the Firebird architecture will be the most popular on the planet with a very large margin.

A lot of work will probably need to go into getting MySQL and the technology behind Netfrastructure to work together. A lot of testing will also be needed since, due to the low number of deployments of Netfrastructure, its finesses remain largely unproven.

It will be interesting to see how MySQL clients will react to this move and the eventual downgrade of InnoDB support. Will they wait until MySQL completes the Netfrastructure port, or will they choose to move to Firebird directly?
 
Old 02-19-2006, 11:55 PM   #49
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
Interesting sales pitch ... are you a MySQL employee? :}
 
Old 02-20-2006, 09:39 AM   #50
fikret
LQ Newbie
 
Registered: Jan 2005
Posts: 28

Rep: Reputation: 15
No, I am a member of Firebird Foundation Committee ;-)
Take a look at http://www.fyracle.org
 
Old 02-22-2006, 11:13 AM   #51
decibel
LQ Newbie
 
Registered: Nov 2003
Posts: 25

Rep: Reputation: 15
Quote:
Originally Posted by cpuobsessed
I have seen MySQL used more.
And I've seen Windows used more than Linux. Does that make it the OS of the year?
 
Old 02-22-2006, 11:20 AM   #52
decibel
LQ Newbie
 
Registered: Nov 2003
Posts: 25

Rep: Reputation: 15
Quote:
Originally Posted by jens
I'm using SQL myself, but I'm starting to get very worried about the license...
Is their any difference with PostgreSQL. If not what databases should I start using to avoid all this license stuff. For me this is a very important issue(I don't mind using something less good if it's completely free). This one would also be my database of the year
If you're worried about licenses then you won't be able to beat PostgreSQL except with SQLite (which is targeting a different use, namely embedded databases). Unlike most 15 page OSS licenses, the BSD license that PostgreSQL uses is small enough to include right here:
--
PostgreSQL Database Management System
(formerly known as Postgres, then as Postgres95)

Portions Copyright (c) 1996-2005, The PostgreSQL Global Development Group

Portions Copyright (c) 1994, The Regents of the University of California

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
--

So in a nutshell, you can do anything you want so long as you maintain the copyright notice and don't sue the university.

SQLite doesn't even have a license; it's public domain.
 
Old 02-22-2006, 11:24 AM   #53
decibel
LQ Newbie
 
Registered: Nov 2003
Posts: 25

Rep: Reputation: 15
Quote:
Originally Posted by fikret
Realy? Last time I checked, you MUST pay for commercial license ;-)
See previous page of this discussion.
Not to mention PostgerSQL still has more functionality...
 
Old 02-22-2006, 11:27 AM   #54
decibel
LQ Newbie
 
Registered: Nov 2003
Posts: 25

Rep: Reputation: 15
Quote:
Originally Posted by Tinkster
Huh?

PostgreSQL, Firebird .. both are free, too, and beat MySQL
hands down in features and SQL standard compliance.
But I suppose if you divide 0 by 5 or by 50, you'll still get
the same result, eh? ;}


Cheers,
Tink
And in MySQL if you divide 5 by 0 you probably still get the same result! ;P

Oh good lord... here I thought I was just being funny...

mysql> select 5/0;
+------+
| 5/0 |
+------+
| NULL |
+------+

Of course a real database will give you an error...

postgresql=# select 5/0;
ERROR: division by zero
postgresql=#
 
Old 02-22-2006, 11:45 AM   #55
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
Quote:
Originally Posted by decibel
And in MySQL if you divide 5 by 0 you probably still get the same result! ;P

Oh good lord... here I thought I was just being funny...

mysql> select 5/0;
+------+
| 5/0 |
+------+
| NULL |
+------+

Of course a real database will give you an error...

postgresql=# select 5/0;
ERROR: division by zero
postgresql=#
LOL ... thanks mate, you just made my day! :)


Cheers,
Tink
 
Old 02-23-2006, 04:58 AM   #56
msramachandran
LQ Newbie
 
Registered: Aug 2003
Location: Tamil Nadu
Posts: 4

Rep: Reputation: 0
MySQL is really good and is easy to use. I tried learning PGSQL for 4 months but couldn't even start with it( Damm Complex ).
 
Old 02-23-2006, 10:15 AM   #57
fikret
LQ Newbie
 
Registered: Jan 2005
Posts: 28

Rep: Reputation: 15
Quote:
Originally Posted by decibel
And in MySQL if you divide 5 by 0 you probably still get the same result! ;P

Oh good lord... here I thought I was just being funny...

mysql> select 5/0;
+------+
| 5/0 |
+------+
| NULL |
+------+

Of course a real database will give you an error...

postgresql=# select 5/0;
ERROR: division by zero
postgresql=#
Similar error from Firebird ;-)
 
Old 02-23-2006, 12:28 PM   #58
decibel
LQ Newbie
 
Registered: Nov 2003
Posts: 25

Rep: Reputation: 15
Quote:
Originally Posted by msramachandran
MySQL is really good and is easy to use. I tried learning PGSQL for 4 months but couldn't even start with it( Damm Complex ).
I'm curious... what problems were you having?
 
Old 02-23-2006, 12:53 PM   #59
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
The same he'd have learning SQL99?

/me ducks



Cheers,
Tink
 
Old 02-23-2006, 01:01 PM   #60
decibel
LQ Newbie
 
Registered: Nov 2003
Posts: 25

Rep: Reputation: 15
Quote:
Originally Posted by Tinkster
The same he'd have learning SQL99?

/me ducks

Cheers,
Tink
Maybe, but I am genuinely curious. I've heard people complain that PostgreSQL is 'too complex', which I've just never understood. But maybe there's some tweaks that can be made to improve upon that...
 
  


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 06:58 PM


All times are GMT -5. The time now is 11:26 AM.

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