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 |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
 |
GNU/Linux Basic Guide
This 255-page guide will provide you with the keys to understand the philosophy of free software, teach you how to use and handle it, and give you the tools required to move easily in the world of GNU/Linux. Many users and administrators will be taking their first steps with this GNU/Linux Basic guide and it will show you how to approach and solve the problems you encounter.
Click Here to receive this Complete Guide absolutely free. |
|
|
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% |
 |
|
01-28-2006, 03:13 PM
|
#1
|
root 
Registered: Jun 2000
Distribution: Debian, Red Hat, Slackware, Fedora, Ubuntu
Posts: 9,514
|
Database of the Year
Always a highly debated topic.
--jeremy
|
|
|
|
01-29-2006, 07:12 PM
|
#2
|
|
Senior Member
Registered: Nov 2003
Location: Knoxville, TN
Distribution: Kubuntu 9.04
Posts: 1,168
Rep:
|
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. 
|
|
|
|
01-30-2006, 03:55 AM
|
#3
|
|
Member
Registered: Sep 2004
Location: Lelystad, NL
Distribution: Debian Etch
Posts: 123
Rep:
|
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
|
|
|
|
01-30-2006, 09:17 AM
|
#4
|
|
LQ Newbie
Registered: Jan 2005
Posts: 28
Rep:
|
Firebird rules!
|
|
|
|
01-30-2006, 12:41 PM
|
#5
|
|
Member
Registered: Nov 2003
Location: Lebanon
Distribution: RHEL 5/CentOS 5/Debian Lenny/(K)Ubuntu Is Dead/Mandriva 10.1
Posts: 664
Rep:
|
Ive used Oracle and MySQL.....the latter one being my number one choice for one man application developments...
|
|
|
|
01-30-2006, 12:46 PM
|
#6
|
|
Member
Registered: May 2005
Location: Greece
Distribution: antiX using fluxbox, icewm, i3 and wmii
Posts: 275
Rep:
|
MySQL as I haven't learnt anything else yet.
|
|
|
|
01-30-2006, 01:05 PM
|
#7
|
|
Moderator
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,902
|
PostgreSQL, the most complete FOSS database out there :}
|
|
|
|
01-31-2006, 02:23 AM
|
#8
|
|
Member
Registered: Jan 2006
Distribution: Ubuntu
Posts: 52
Rep:
|
I have seen MySQL used more.
|
|
|
|
01-31-2006, 04:04 PM
|
#9
|
|
Member
Registered: Aug 2003
Location: Canada/US
Distribution: Ubuntu, Arch
Posts: 84
Rep:
|
firebird is excellent
|
|
|
|
02-01-2006, 02:15 AM
|
#10
|
|
LQ Newbie
Registered: Mar 2003
Location: Belgium
Distribution: Redhat 8.0
Posts: 7
Rep:
|
Just for the sake of it : sqlite. Simple, small and very much adapting standards.
|
|
|
|
02-01-2006, 03:34 AM
|
#11
|
|
Guru
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298
Rep:
|
My vote goes to PostgreSQL because its feature rich when compared to most opensource DBMSs.
|
|
|
|
02-01-2006, 06:00 AM
|
#12
|
|
Member
Registered: Dec 2004
Location: Colombo, Sri Lanka
Distribution: Arch Linux, Gentoo Linux, Ubuntu, Debian
Posts: 116
Rep:
|
MySQL rockz;-)
|
|
|
|
02-01-2006, 09:14 AM
|
#13
|
|
LQ Newbie
Registered: Nov 2005
Posts: 4
Rep:
|
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.
|
|
|
|
02-01-2006, 09:54 AM
|
#14
|
|
LQ Newbie
Registered: Jan 2006
Posts: 3
Rep:
|
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.
|
|
|
|
02-01-2006, 10:50 AM
|
#15
|
|
LQ Newbie
Registered: Feb 2006
Posts: 2
Rep:
|
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
|
|
|
|
| Thread Tools |
Search this Thread |
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -5. The time now is 04:11 AM.
|
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|