LinuxQuestions.org
Review your favorite Linux distribution.
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-01-2006, 11:06 AM   #16
Berhanie
Senior Member
 
Registered: Dec 2003
Location: phnom penh
Distribution: Fedora
Posts: 1,625

Rep: Reputation: 165Reputation: 165

If you like organization, excellent documentation, and compliance with standards, then PostgreSQL is the right choice.

If you prefer chaos; if you like having certain features unavailable to you unless you choose a certain database engine; if you like reading that the syntax accepted before version 3.x.y is not available afterward, or that you are allowed to use a subqueries only after version 4.1, but only if you don't do it on the same table; if you like reading errata to learn that certain operations cannot be performed on temporary tables, but that that feature is planned for versions starting with 5.2, MySQL is the thing for you.
 
Old 02-01-2006, 04:00 PM   #17
tizzef
Member
 
Registered: Jan 2005
Location: Nice, France
Distribution: Ubuntu,RHES, Mandriva, RHAS, AIX 4.3.3, 5.2 & 5.3, Debian,Solaris8/10
Posts: 119

Rep: Reputation: 20
MySQL is excellent
 
Old 02-01-2006, 04:17 PM   #18
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,978
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
I've seen MySQL and moved on :}
 
Old 02-01-2006, 04:40 PM   #19
cincindie
Member
 
Registered: Jul 2004
Location: Zinzinnati, OH
Distribution: RH, FC 1-6, F 7-17, Debian, LinuxPPC, Knoppix, Ubuntu, Yellow Dog
Posts: 175

Rep: Reputation: 31
PostgreSQL for sure.
 
Old 02-01-2006, 07:58 PM   #20
jens
Senior Member
 
Registered: May 2004
Location: Belgium
Distribution: Debian, Slackware, Fedora
Posts: 1,194

Rep: Reputation: 159Reputation: 159
Quote:
Originally Posted by Tinkster
PostgreSQL, the most complete FOSS database out there :}
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
 
Old 02-01-2006, 08:35 PM   #21
bogoda
Member
 
Registered: Jan 2006
Posts: 32
Blog Entries: 2

Rep: Reputation: 15
it very fast and very easy to handle.
 
Old 02-01-2006, 09:30 PM   #22
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,978
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
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
PostgreSQL 8.x includes most of SQL 99 plus a couple of its
own extensions. Just have a look at their web-site, and read
up on their features. Or tell me which features you're currently
using with whateverSQL, and I'll try to tell you whether PostgreSQL
can ...


Cheers,
Tink
 
Old 02-02-2006, 02:28 AM   #23
prasad514
LQ Newbie
 
Registered: Dec 2004
Location: india
Posts: 4

Rep: Reputation: 0
Progress

I use progress and it is really fantastic. It is just like
a programming language.
 
Old 02-02-2006, 05:02 AM   #24
fikret
LQ Newbie
 
Registered: Jan 2005
Posts: 28

Rep: Reputation: 15
Have you guys ever tried Firebird? It's superb!
 
Old 02-03-2006, 09:45 AM   #25
z_darius
LQ Newbie
 
Registered: Nov 2003
Location: Canada
Distribution: Mandrake, e-smith
Posts: 27

Rep: Reputation: 15
I can't afford MySQL licence for my commercial customers, and my customers can't afford to hire a database manager to manage Postgres.

I need solid performance, SQL compliance without spending lots of $$$. The choice is logical: Firebird!.
 
Old 02-04-2006, 09:05 AM   #26
segin
LQ Newbie
 
Registered: May 2005
Location: Gibsonton, FL
Distribution: Gentoo, Slackware
Posts: 24

Rep: Reputation: 15
Post

MySQL is what I use (if I use anything at all, which for the most part I don't. Did I confuse you enough there?)
 
Old 02-04-2006, 11:54 AM   #27
NateCK
LQ Newbie
 
Registered: Jan 2006
Posts: 3

Rep: Reputation: 0
Quote:
Originally Posted by z_darius
I can't afford MySQL licence for my commercial customers, and my customers can't afford to hire a database manager to manage Postgres.
It's not clear to me why you feel the need for a commercial license for MySQL, a GPL'ed application. Do you plan to make extensions or modifications that you don't want to release? That kind of work sounds quite expensive, too.
 
Old 02-07-2006, 07:44 AM   #28
vikramna
LQ Newbie
 
Registered: Jan 2006
Posts: 8

Rep: Reputation: 0
My SQL is always been my fav. There is a lot of support provided for that
 
Old 02-07-2006, 09:21 PM   #29
Present
Member
 
Registered: Jan 2004
Distribution: suse/slack/gentoo/lfs (not-in-that-order)
Posts: 281

Rep: Reputation: 30
Post seems to stick closer to the "GPL" theme than MySQL, so that makes it my fav, though they each have their advantages from a performance perspective.
 
Old 02-08-2006, 09:05 PM   #30
z_darius
LQ Newbie
 
Registered: Nov 2003
Location: Canada
Distribution: Mandrake, e-smith
Posts: 27

Rep: Reputation: 15
Quote:
Originally Posted by NateCK
It's not clear to me why you feel the need for a commercial license for MySQL, a GPL'ed application. Do you plan to make extensions or modifications that you don't want to release? That kind of work sounds quite expensive, too.
No, I have no plans or desire to extend or modify and RDBMS, but I want to use one for a commercial application. If I use MySQL I have to pay license fees. With Firebird I don't.

Quote from MySQL site:

#

If you include the MySQL server with an application that is not licensed under the GPL or GPL-compatible license, you need a commercial license for the MySQL server.
#

If you develop and distribute a commercial application and as part of utilizing your application, the end-user must download a copy of MySQL; for each derivative work, you (or, in some cases, your end-user) need a commercial license for the MySQL server and/or MySQL client libraries.
#

If you include one or more of the MySQL drivers in your non-GPL application (so that your application can run with MySQL), you need a commercial license for the driver(s) in question. The MySQL drivers currently include an ODBC driver, a JDBC driver and the C language library.
 
  


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 06:10 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