LinuxQuestions.org
Register a domain and help support LQ
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 01-28-2006, 03:13 PM   #1
jeremy
root
 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 10,425

Rep: Reputation: 2628Reputation: 2628Reputation: 2628Reputation: 2628Reputation: 2628Reputation: 2628Reputation: 2628Reputation: 2628Reputation: 2628Reputation: 2628Reputation: 2628
Database of the Year


Always a highly debated topic.

--jeremy
 
Old 01-29-2006, 07:12 PM   #2
Crito
Senior Member
 
Registered: Nov 2003
Location: Knoxville, TN
Distribution: Kubuntu 9.04
Posts: 1,168

Rep: Reputation: 53
Hmm, why not best open source database? Well, luckily PostgreSQL can handle pretty much anything the big dawg commercial db's can. So guess it doesn't really matter anyway.
 
Old 01-30-2006, 03:55 AM   #3
Ruben2
Member
 
Registered: Sep 2004
Location: Lelystad, NL
Distribution: Debian Etch
Posts: 123

Rep: Reputation: 15
I use MySQL more than PostgreSQL, because I just started to learn Postgres (and it's quite complex :S) Though I hardly know it I still think Postgres is better than MySQL
 
Old 01-30-2006, 09:17 AM   #4
fikret
LQ Newbie
 
Registered: Jan 2005
Posts: 28

Rep: Reputation: 15
Firebird rules!
 
Old 01-30-2006, 12:41 PM   #5
ALInux
Member
 
Registered: Nov 2003
Location: Lebanon
Distribution: RHEL 5/CentOS 5/Debian Lenny/(K)Ubuntu Is Dead/Mandriva 10.1
Posts: 668
Blog Entries: 7

Rep: Reputation: 31
Ive used Oracle and MySQL.....the latter one being my number one choice for one man application developments...
 
Old 01-30-2006, 12:46 PM   #6
anticapitalista
Member
 
Registered: May 2005
Location: Greece
Distribution: antiX using herbstluftwm, i3, wmii, fluxbox, icewm and jwm.
Posts: 291

Rep: Reputation: 67
MySQL as I haven't learnt anything else yet.
 
Old 01-30-2006, 01:05 PM   #7
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,986
Blog Entries: 11

Rep: Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880Reputation: 880
PostgreSQL, the most complete FOSS database out there :}
 
Old 01-31-2006, 02:23 AM   #8
cpuobsessed
Member
 
Registered: Jan 2006
Distribution: Fedora, Ubuntu, Slackware
Posts: 53

Rep: Reputation: 15
I have seen MySQL used more.
 
Old 01-31-2006, 04:04 PM   #9
wrj
Member
 
Registered: Aug 2003
Location: Canada/US
Distribution: Ubuntu, Arch
Posts: 84

Rep: Reputation: 15
firebird is excellent
 
Old 02-01-2006, 02:15 AM   #10
infochen
LQ Newbie
 
Registered: Mar 2003
Location: Belgium
Distribution: Redhat 8.0
Posts: 7
Blog Entries: 1

Rep: Reputation: 0
Just for the sake of it : sqlite. Simple, small and very much adapting standards.
 
Old 02-01-2006, 03:34 AM   #11
reddazz
Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 73
My vote goes to PostgreSQL because its feature rich when compared to most opensource DBMSs.
 
Old 02-01-2006, 06:00 AM   #12
kesara
Member
 
Registered: Dec 2004
Location: Colombo, Sri Lanka
Distribution: Arch Linux, Gentoo Linux, Ubuntu, Debian
Posts: 116

Rep: Reputation: 15
MySQL rockz;-)
 
Old 02-01-2006, 09:14 AM   #13
karsteb
LQ Newbie
 
Registered: Nov 2005
Posts: 4

Rep: Reputation: 0
Sybase since 12.x is very fine for performance (row level locking) and unbeatable on administration.

MySQL looks promising for performance and I use it a lot for websites, but it still has a few very dangerous bugs in database naming and some bugs in the credential parts of the client admin tools, incremental backup is nonexistant and some table naming annoyances during restore.

Never been much of an Oracle buff - always something wrong, difficult or limiting.

On stability and performance still nothing really beats DB2.

But still guys - nothing really combines performance, usability, rapid design, support for many databases and management like Microsoft SQL Server. No problem getting DB's into 4'th normal form with the built-in orthogonal layout. Too bad it does not run under Linux.
 
Old 02-01-2006, 09:54 AM   #14
NateCK
LQ Newbie
 
Registered: Jan 2006
Posts: 3

Rep: Reputation: 0
I'll put on in for PGSQL

After using both PostgreSQL and MySQL for a while, I'd have to say that PostgreSQL is superior. MySQL is easier to administer, and is great if all you want to do is dump data into some tables and then take them out. PostgreSQL is the place to go when you want to do some real database hacking. I don't actually find it that "complex", other than the complexity inherent in a SQL database. The only tricky thing is the permissions management since you don't have that nice table-driven (and non-standard) system that MySQL provides.
 
Old 02-01-2006, 10:50 AM   #15
mutschaedi
LQ Newbie
 
Registered: Feb 2006
Posts: 2

Rep: Reputation: 0
odaba2

odbms for realy complex data

anyway the topic is very general

my favourite database this year will get something that stores my webtraffic

peace
 
  


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 12:39 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