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-10-2006, 11:53 AM   #31
thick_guy_9
Member
 
Registered: Jan 2004
Location: Singapore
Distribution: VMS, RHEL, Slackware & FreeBSD
Posts: 99

Rep: Reputation: 15

Oracle: Oracle Express is crippleware. Only 1 DB. Std and Ent versions need a lot of baby-sitting. Run only on RHEL and SLES. Use it at work
Sybase: Good candidate. Express Edition is free for 1 proc and 2GB RAM and 5GB of data. Run only on RHEL and SLES. Used it in past.
DB2: Express Edition free for 2 procs (can be dual-core), 4GB RAM and unlimited data, unlimited database instances. RHEL, SLES & UBUNTU (& DEBIAN). Never used this.
Firebird: Extremly good DB. But has no breakthrough improvement for this year. Used it's cousin(guess).
PostGRESQL: These guys have a RHEL fixation and release the latest RPMs for RedHat only. The reason they are unpopular is probably because theyr PR is patheric. Why keep releasing for RHEL, when people will use RHEL to run Oracle or Sybase or DB2? Need to aggresively offer packages for various platforms like mySQL.
mySQL: With rel 5 they probably deserve my vote. Packages released for RPM, non-RPM, Windows and solaris x86. GPL and non-GPL versions. Good docs. Lots of books. Lots of help on web. never used it.


VOTE goes to:.............................................DB2.
 
Old 02-10-2006, 02:15 PM   #32
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 thick_guy_9
Oracle: Oracle Express is crippleware. Only 1 DB. Std and Ent versions need a lot of baby-sitting. Run only on RHEL and SLES. Use it at work
Not quite true. Certified on those two, but it can be installed and run
on Slack, Debian, ... (admittedly non-trivial)


Quote:
Originally Posted by thick_guy_9
PostGRESQL: These guys have a RHEL fixation and release the latest RPMs for RedHat only. The reason they are unpopular is probably because theyr PR is patheric. Why keep releasing for RHEL, when people will use RHEL to run Oracle or Sybase or DB2? Need to aggresively offer packages for various platforms like mySQL.
Eh? The preferred method is tar-balls for Posix platforms, the
fact that there are contributed packages for some distros has
nothing to do with the postgres team as such (even though Tom
Lane, one of the most active PG developers, happens to be a full-
time employee of RedHat they don't favour RH at all).
MySQL doesn't offer packages for Slackware, just to name one,
Pat rolls it, same with Debian to the best of my knowledge.



Cheers,
Tink
 
Old 02-11-2006, 06:37 AM   #33
fikret
LQ Newbie
 
Registered: Jan 2005
Posts: 28

Rep: Reputation: 15
Benchmarks with Sqlite, Posgtresql, Mysql and Firebird.
Draw your own conclusions
http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
 
Old 02-13-2006, 08:23 AM   #34
Crito
Senior Member
 
Registered: Nov 2003
Location: Knoxville, TN
Distribution: Kubuntu 9.04
Posts: 1,168

Rep: Reputation: 53
I would like to point out that MS SQL Server and Sybase were essentially the SAME product up until version 4.21 or so. So anyone looking to migrate T-SQL (Transact-SQL) specific functions/procedures from Windows to Linux would find that the easiest way to go. Of couse, sticking with ANSI standard SQL would be even better.

[begin rant]
So why didn't I chose Sybase. Well, for the same reason I'm abandoning MS SQL Server: they both abandonded SQL. Sybase now pushes J-SQL, which is essentially a bastardization of SQL and Java. Micorsoft, not to be out done in the bastadrization department, has done the same with dot-net and SQL. I want pure SQL. Last thing I need is more spaghetti code writting in Java and mono. Keep that cr@p on the web servers where it belongs.

And object oriented database designs, like LDAP uses unfortunately, might be great for lazy OOP programmers but they're just plain stupid when it comes to manipulating data in any meaningful manner.
[end rant]

I feel better now.

Last edited by Crito; 02-13-2006 at 08:24 AM.
 
Old 02-13-2006, 11:49 AM   #35
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 fikret
Benchmarks with Sqlite, Posgtresql, Mysql and Firebird.
Draw your own conclusions
http://www.sqlite.org/cvstrac/wiki?p=SpeedComparison
http://www.mail-archive.com/sqlite-u.../msg12945.html

And why on earth would I want to compare how a database
handles 1000 consecutive transactions from one client rather
than concurrency? For all I care that test has only proven that
its author has no back-ground in databases what so ever.


Cheers,
Tink

Last edited by Tinkster; 02-13-2006 at 12:02 PM. Reason: typo
 
Old 02-16-2006, 02:07 AM   #36
danex50
LQ Newbie
 
Registered: Feb 2004
Location: UK
Posts: 22

Rep: Reputation: 15
Firebird. It does a great job with stored procedures, and this is very handy.
 
Old 02-16-2006, 08:21 AM   #37
glebovitz
LQ Newbie
 
Registered: Jan 2006
Posts: 12

Rep: Reputation: 0
mysql is great

It beats the competition on the function vs price curve :-)
 
Old 02-16-2006, 09:40 AM   #38
fikret
LQ Newbie
 
Registered: Jan 2005
Posts: 28

Rep: Reputation: 15
Quote:
Originally Posted by glebovitz
It beats the competition on the function vs price curve :-)
Realy? Last time I checked, you MUST pay for commercial license ;-)
See previous page of this discussion.
 
Old 02-16-2006, 09:56 AM   #39
matt_morgan
LQ Newbie
 
Registered: Nov 2004
Distribution: fedora core 3; mandrake 10
Posts: 2

Rep: Reputation: 0
Sybase, for the heck of it

I just did a Sybase ASE 15 install; it was my first experience with Sybase, for a client who was familiar with prior versions.

The free version of ASE for Linux is limited to only 5GB disk and 2GB ram, or something like that, which is too bad. But it's fast and pretty simple, and the online docs are incredible, and they have cool gui admin tools that I can run in ssh X-forwarding. There's a lot to like.

But mostly I only use MySQL, I have to admit, and at my last job we loved PostgreSQL. How can you pick? They all fill their niches nicely.
 
Old 02-16-2006, 11:18 AM   #40
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 danex50
Firebird. It does a great job with stored procedures, and this is very handy.
So does PostgreSQL ;}


Cheers,
Tink
 
Old 02-16-2006, 11:20 AM   #41
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 glebovitz
It beats the competition on the function vs price curve :-)
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
 
Old 02-16-2006, 01:19 PM   #42
interndan
Member
 
Registered: Aug 2004
Location: near Marion, Ill
Distribution: Slackware 13.37
Posts: 238

Rep: Reputation: 17
Where is Kexi??
edit:

most of the systems we use at work are MySQL based, however for personal use Kexi is hard to beat for small light weight file based DBs.

Last edited by interndan; 02-16-2006 at 01:24 PM.
 
Old 02-16-2006, 07:26 PM   #43
backpacker
Member
 
Registered: Jun 2005
Distribution: Fedora 11
Posts: 68

Rep: Reputation: 15
I vote MySQL database.

It have benefited to me and my company so much!!
 
Old 02-16-2006, 07:27 PM   #44
zhengya_1976
LQ Newbie
 
Registered: Jan 2006
Posts: 2

Rep: Reputation: 0
database

support mysql
 
Old 02-16-2006, 08:49 PM   #45
verminthrax
LQ Newbie
 
Registered: Dec 2005
Posts: 1

Rep: Reputation: 0
MySQL Over the Top

MySQL! v5!
 
  


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 07:45 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