LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > 2007 LinuxQuestions.org Members Choice Awards
User Name
Password
2007 LinuxQuestions.org Members Choice Awards This forum is for the 2007 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite products of 2007. This is your chance to be heard! Voting ends February 21st.

Notices


View Poll Results: Database of the Year
MySQL 436 54.36%
PostgreSQL 174 21.70%
Firebird 77 9.60%
sqlite 53 6.61%
Oracle 28 3.49%
Sybase 4 0.50%
DB2 5 0.62%
Berkley DB 4 0.50%
InnoDB 1 0.12%
EnterpriseDB 20 2.49%
Voters: 802. You may not vote on this poll

Reply
  Search this Thread
Old 01-16-2008, 06:57 AM   #46
sophkos
LQ Newbie
 
Registered: Jan 2008
Distribution: Fedora 7
Posts: 16

Rep: Reputation: 0

I like MySQL
 
Old 01-16-2008, 08:05 AM   #47
fikret
LQ Newbie
 
Registered: Jan 2005
Posts: 28

Rep: Reputation: 15
Sun Microsystems Announces Agreement to Acquire MySQL, Developer of the World’s Most Popular Open Source Database. More information here:

http://www.sun.com/aboutsun/pr/2008-...20080116.1.xml
 
Old 01-16-2008, 08:28 AM   #48
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 13,602

Original Poster
Rep: Reputation: 4083Reputation: 4083Reputation: 4083Reputation: 4083Reputation: 4083Reputation: 4083Reputation: 4083Reputation: 4083Reputation: 4083Reputation: 4083Reputation: 4083
jainforall, read my last post in this thread.

--jeremy
 
Old 01-17-2008, 05:55 PM   #49
Tinkster
Moderator
 
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928
http://www.developer.com/design/arti...0925_3721761_1

YES! :}



Cheers,
Tink
 
Old 01-20-2008, 10:01 PM   #50
Tinkster
Moderator
 
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928
And a very nice write-up on the good old Postgres (PostgreSQL) vs MySQL debate ...

http://people.planetpostgresql.org/g...Sabino-Mullane


Cheers,
Tink
 
Old 01-21-2008, 11:29 AM   #51
lord-fu
Member
 
Registered: Apr 2005
Location: Ohio
Distribution: Slackware && freeBSD
Posts: 676

Rep: Reputation: 30
I voted for MySQL, never got wrapped up in debates, but if MySQL doesn't suit the job I have no problem using the tool that does.
 
Old 01-22-2008, 07:44 AM   #52
rodstar
LQ Newbie
 
Registered: Dec 2007
Posts: 6

Rep: Reputation: 0
Good answer!!!
 
Old 01-26-2008, 11:11 PM   #53
DBabo
Member
 
Registered: Feb 2003
Distribution: Fedora {latest}
Posts: 568

Rep: Reputation: 40
i'm a bit late with this , but :
What are the definitions of "The Database of the Year" - parameters, features do gets compared...
I probably missing the description of this somewhere. Please point out.
Thank you.
 
Old 01-27-2008, 01:11 AM   #54
Tinkster
Moderator
 
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928
I guess which ever you prefer for which ever reason ;}

PostgreSQL all the way.


Cheers,
Tink
 
Old 01-27-2008, 11:29 AM   #55
DBabo
Member
 
Registered: Feb 2003
Distribution: Fedora {latest}
Posts: 568

Rep: Reputation: 40
Quote:
Originally Posted by Tinkster View Post
I guess which ever you prefer for which ever reason ;}

PostgreSQL all the way.

Cheers,
Tink
well, if so then highly modern approach of calculator ( say in my cell phone ) and good old notepad on my desk.

P.S. I personally think that these polls are very uninformative and sorta useless.
"useless", because people express their likes wo any base. LQ can run, with the same success and usefulness to community the "Best color of Year".
 
Old 01-27-2008, 11:45 AM   #56
Tinkster
Moderator
 
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928
Quote:
Originally Posted by DBabo View Post
well, if so then highly modern approach of calculator ( say in my cell phone ) and good old notepad on my desk.
You're mistaking databases with spread-sheets.

Quote:
Originally Posted by DBabo View Post
P.S. I personally think that these polls are very uninformative and sorta useless.
"useless", because people express their likes wo any base. LQ can run, with the same success and usefulness to community the "Best color of Year".
Except that that wouldn't have ANYTHING to do with Linux or
OpenSource, which would indeed be quite weird on primarily
technically focused forum.

Realistically ... what would YOU like to see compared?
Speed? Standard Compliance? Data Integrity? Extensibility?
Number of supported embeddable languages for functions?
And if we introduced a list of let's say 15 distinct qualities
and added some weighting to those... how many people would
take the time? And: should people who only ever used one
RDBMS be allowed to vote, since they have nothing to compare
it against, really? I think the poll makes sense in the
terms of expressing the preferences of the people coming
here, whatever they base their decisions on. If you expect
a "good reason" for the poll - what's your take on the
elections in the states? ;D (Please DON'T answer this one
here, take it to General if you feel the urge).

And as for the uselessness: people get an option to state WHY
they prefer which system. Alas, some of our members (most notably
the ones who signed up for the sole purpose of voting for firebird)
make that a "I vote for firebird" w/o any explanation ...



Cheers,
Tink
 
Old 01-27-2008, 05:45 PM   #57
DBabo
Member
 
Registered: Feb 2003
Distribution: Fedora {latest}
Posts: 568

Rep: Reputation: 40
Quote:
Originally Posted by Tinkster View Post
You're mistaking databases with spread-sheets.
not exactly http://www.webopedia.com/TERM/d/database.html :
"A collection of information organized in such a way that a computer program can quickly select desired pieces of data. You can think of a database as an electronic filing system."
Replace the term "computer system" with "human being". Say that i'm very meticulous about making frequent updates to the TOC and index, and I'm making a frequent copies on the copy machine, AND send those copies to other offices across a country. And you will see that I'm one damn sophisticated modern DBMS


Quote:
...
Except that that wouldn't have ANYTHING to do with Linux or
OpenSource, which would indeed be quite weird on primarily
technically focused forum.
quite on contrary - open source - please be my guest to take said notepad and make it better - organize better, make a nicer TOC. I have no problem with that, if you promise to share your procedures and end result product. Cant have more open approach than this, can you?
And if you would like to implement it on some specific computer OS - I certainly won't object either.

Jokes aside - but the example of the calculator ( or doing math on paper with pen and pencil, to make it more open source ) doesn't brake boundaries of this poll.

And that's exactly what made me ask the original question.

You made a very good entry and now we have details to the poll:
It ( the DB solution ) should satisfy following conditions:
1. Has to be available for Linux
2. Be Open Source
let's continue...

Quote:
Realistically ... what would YOU like to see compared?
Speed? Standard Compliance? Data Integrity? Extensibility?
Number of supported embeddable languages for functions?
And if we introduced a list of let's say 15 distinct qualities and added some weighting to those... how many people would take the time? And: should people who only ever used one RDBMS be allowed to vote, since they have nothing to compare it against, really? I think the poll makes sense in the
terms of expressing the preferences of the people coming
here, whatever they base their decisions on. If you expect
a "good reason" for the poll - what's your take on the
elections in the states? ;D (Please DON'T answer this one
here, take it to General if you feel the urge).
Very-very valid comments indeed.

I would like to see compared quite a few options and features. BUT i liked your idea of making members select those features from the list and then compare DB solutions against that list.
I think such poll will have more respect inside and outside our community and might help the decision makers.

Let's examine following 2 statements and see which one would gain our attention:
1. LQ community selected product AZXSDC of the Year, because we had 10.000 members voted for it. We didn't select any parameters and no features were compared.

2. LQ community selected product AZXSDC of the Year, based on the vote of 10.000 members. Each product was weighted by the following, initially selected by members, categories:
a. user's experience
aa. easy to install ;
ab. easy to learn to work with
ac. etc
b. DB admin perspective
ba. amount of sleepless nights required to get the thing to work proplery
bb. security
bc. performance
bd. etc
c. business perspective
ca. TCO
cb. time to implement the project
cc. etc
d. <smth else >


I personally look in for answers to my technical questions. Or advise basedon the experience.
Posts that express just an emotion ( "oh, i like this and that because it's has totally like cool blah that totally rocks" ) is just that they "totally" not useful.

Please don't get me wrong, i'm not against the polls per se. I would rather see the value of and respect to/of LQ to continue to rise vs. becoming "yet another forum to filter emotions".

Last edited by DBabo; 01-27-2008 at 05:48 PM.
 
Old 01-28-2008, 10:54 PM   #58
Mega Man X
LQ Guru
 
Registered: Apr 2003
Location: ~
Distribution: Ubuntu, FreeBSD, Solaris, DSL
Posts: 5,339

Rep: Reputation: 65
PostgreSQL or sqlite, depending what I am doing. I dislike MySQL and I think that poor excuse for a database is just lucky to be as popular as it is...
 
Old 01-28-2008, 11:23 PM   #59
Tinkster
Moderator
 
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928
Quote:
Originally Posted by DBabo View Post


:) quite on contrary - open source - please be my guest to take said notepad and make it better - organize better, make a nicer TOC. I have no problem with that, if you promise to share your procedures and end result product. Cant have more open approach than this, can you?
And if you would like to implement it on some specific computer OS - I certainly won't object either.
Actually my response was on your "poll on favourite colour" ...
and that still has nothing to do with OpenSource.

Quote:
Originally Posted by DBabo View Post
You made a very good entry and now we have details to the poll:
It ( the DB solution ) should satisfy following conditions:
1. Has to be available for Linux
2. Be Open Source
let's continue...



Very-very valid comments indeed.

I would like to see compared quite a few options and features. BUT i liked your idea of making members select those features from the list and then compare DB solutions against that list.
I think such poll will have more respect inside and outside our community and might help the decision makers.

Let's examine following 2 statements and see which one would gain our attention:
1. LQ community selected product AZXSDC of the Year, because we had 10.000 members voted for it. We didn't select any parameters and no features were compared.

2. LQ community selected product AZXSDC of the Year, based on the vote of 10.000 members. Each product was weighted by the following, initially selected by members, categories:
a. user's experience
aa. easy to install ;
ab. easy to learn to work with
ac. etc
b. DB admin perspective
ba. amount of sleepless nights required to get the thing to work proplery
bb. security
bc. performance
bd. etc
c. business perspective
ca. TCO
cb. time to implement the project
cc. etc
d. <smth else >


I personally look in for answers to my technical questions. Or advise basedon the experience.
Posts that express just an emotion ( "oh, i like this and that because it's has totally like cool blah that totally rocks" :) ) is just that they "totally" not useful.

Please don't get me wrong, i'm not against the polls per se. I would rather see the value of and respect to/of LQ to continue to rise vs. becoming "yet another forum to filter emotions".
You just got my response in the wrong spirit. I meant it (because
of the complexity of the task at hand and the effort involved) as a
COUNTER-EXAMPLE to attempting what you're suggesting. Never
mind, I'll just hope it won't happen - because I wouldn't be taking
the time to complete one of those ;}



Cheers,
Tink

Last edited by Tinkster; 01-28-2008 at 11:25 PM.
 
Old 01-29-2008, 07:01 AM   #60
jobinau
LQ Newbie
 
Registered: Jun 2007
Posts: 5

Rep: Reputation: 0
1. Mysql is a open source product from a company. not driven by a community. I mean the core decisions are taken by a small set of people.
for example the company got the liberty to say "We stopped further developemnts".
This is not the freedom as expected from a Free software. But i agree that the code quality and design is one of the best in industry

2. Postgres got all advantages like community driven and best in features. one of the Advanced database systems in Open source world. for atleast in small to medium deployments it can replace Oracle like "Industry leaders". but it got a big disadvantage also. it is not thread based. each user connection creates separate process. You know new advancements in Operating systems (including Linux) gives tremendous performance advantages to thread based systems.

3. Firebird came up with "SuperServer" that is capable of taking advantage of new thread capabilities and this project also a community driven. but still lagging in good SMP support which is requied for massive applications. SMP support is promised by the development team for version 3 (still we need to wait). and another dark area is the quality of code.

looking at all these things Postgres is ready for large deployment. but Firebird is more promising

Last edited by jobinau; 01-29-2008 at 07:02 AM.
 
  


Reply

Tags
postgres, postgresql



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
Database of the Year jeremy 2006 LinuxQuestions.org Members Choice Awards 57 02-20-2007 11:42 AM

LinuxQuestions.org > Forums > 2007 LinuxQuestions.org Members Choice Awards

All times are GMT -5. The time now is 12:22 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
Open Source Consulting | Domain Registration