LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > 2004 LinuxQuestions.org Members Choice Awards
User Name
Password
2004 LinuxQuestions.org Members Choice Awards This forum is for the 2004 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite products of 2004. This is your chance to be heard! Voting closes on February 3rd.

Notices

View Poll Results: Database of the Year
MySQL 511 53.51%
PostgreSQL 149 15.60%
Firebird 216 22.62%
Oracle 23 2.41%
Sybase 4 0.42%
DB2 2 0.21%
Berkley DB 3 0.31%
Informix 1 0.10%
MaxDB 0 0%
sqlite 46 4.82%
Voters: 955. You may not vote on this poll

 
 
Search this Thread
Old 01-09-2005, 09:07 AM   #46
Zakirium
LQ Newbie
 
Registered: Jan 2005
Location: US
Distribution: SuSE 9.2 Professional
Posts: 28

Rep: Reputation: 15

MySQL is the easiest I have used for beginners and has more than enough features for advanced users.

****************
Zakirium.com Your source for software, scripts, IT Knowledge, and more!

Last edited by Zakirium; 01-09-2005 at 09:11 AM.
 
Old 01-09-2005, 09:35 AM   #47
hitesh_linux
Member
 
Registered: Dec 2001
Location: /root
Distribution: FreeBSD,NETBSD,redhat
Posts: 472

Rep: Reputation: 30
My choice is MySQL ."Evergreen DB"

/Hitesh
 
Old 01-09-2005, 11:57 AM   #48
nice_indian
Member
 
Registered: Oct 2004
Location: India
Distribution: redhat 9
Posts: 32

Rep: Reputation: 15
MySQL is what i prefer for my projects.
 
Old 01-09-2005, 02:26 PM   #49
PSHLOS_007
LQ Newbie
 
Registered: Dec 2004
Location: Greece
Distribution: Slackware 10.1 - 2.6.11.2
Posts: 29

Rep: Reputation: 15
MySQL!
 
Old 01-10-2005, 04:03 AM   #50
tauseef
LQ Newbie
 
Registered: Nov 2003
Location: Pakistan
Distribution: Mandrake
Posts: 15

Rep: Reputation: 0
MySQL being compared with DB2 , postgres and Firebird ???
It is more like comparing dBase with SQL Server on MS Windows !!!
Or it is rather more like comparing Word Processors with Spread Sheets ...

MySQL can be compared with relational databases only when it is full relational-database (i.e release version of MySQL-5 may be compared with true RDBMS)

There should actually be two catagories for databases...
A) Relational,
B) Simple Flat-File

And then my choice for relational databse would be Firebird (Like it was last year)

And MySQL for simple flat-file databases
 
Old 01-10-2005, 06:21 AM   #51
coolestuk
LQ Newbie
 
Registered: Sep 2003
Posts: 6

Rep: Reputation: 0
I've no idea where someone gets the idea that MySQL is easier. I evaluated MySQL and Firebird with no prior knowledge of either, and Firebird was so clearly easier to use AND had more advanced options.

The only reasons to use MySQL are a) you want a full-text indexing, b) you are using it in a hosting environment where they have set it up for you and won't allow you to use something like Firebird.

Incidentally, there was an interesting post recently on the Ingres site, where an experienced Ingres user was lamenting how much faster Firebird was than Ingres:

http://opensource.ca.com/projects/in.../650886925835?
 
Old 01-10-2005, 11:05 PM   #52
mrcheeks
Senior Member
 
Registered: Mar 2004
Location: far enough
Distribution: OS X 10.6.7
Posts: 1,690

Rep: Reputation: 50
Postgres might be the best, followed by the big oracle which lots of guys seems to get rid of with maximum pain....

MySQL.com has done a lot of promotion for its product. It is the most popular i think but might be the less featurefull database i ever used. One can make a product that only support oracle or hsqldb or firebird, what's the point?

If we were voting for the IDE of the year kdevelop vs kedit or gedit vs ajunta, would you choose kedit or gedit in terms of features and not speed like MySQL???
 
Old 01-11-2005, 03:25 AM   #53
mhsabado
LQ Newbie
 
Registered: Nov 2003
Posts: 13

Rep: Reputation: 0
What's the best alternative OpenSource DB if you're planning to switch from Oracle? Maybe this would give you some idea...

http://www.newsforge.com/article.pl?...17247&from=rss
 
Old 01-13-2005, 03:52 AM   #54
vlcinsky
LQ Newbie
 
Registered: Jan 2005
Location: Czech Republic, Ostrava
Distribution: RH, Debian
Posts: 2

Rep: Reputation: 0
We started with Interbase/Firebird - great solution for smaller applications with strong integrity checking. Runs great on Windows as well as Linux.
FB is great solution for embeded use on applications.

We use PostgreSQL for large applications, it is stable and faster then FB.
With release of version for Windows it becomes much better for developers, because they can develop applications without need to have a Linux box (if they preffer to develop on MS Windows).
Module PostGIS gives PostgeSQL another value in GIS application, we apprecieate it a lot.

I vote for PostgeSQL

Jan Vlcinsky
 
Old 01-13-2005, 08:55 AM   #55
concord704
LQ Newbie
 
Registered: Jan 2005
Posts: 1

Rep: Reputation: 0
#1 Firebird
 
Old 01-13-2005, 09:25 AM   #56
JThaddeus
Newbie
 
Registered: Jan 2005
Location: Warrenton, VA
Distribution: SuSE 9.2
Posts: 3

Rep: Reputation: 0
I've been using Firebird for two years now with no problems. I ported over 32K of Oracle Embedded SQL to Firebird with little effort and our product runs fine with it.
 
Old 01-13-2005, 10:29 AM   #57
insyte
Member
 
Registered: Jul 2004
Distribution: Slackware Current
Posts: 307

Rep: Reputation: 30
MySQL
 
Old 01-13-2005, 01:12 PM   #58
dclayton
LQ Newbie
 
Registered: Jan 2005
Location: Puyallup, Washington, USA
Distribution: Mandrake 10.1
Posts: 4

Rep: Reputation: 0
MySQL works fine on my XOOPS powered website. Linux, Apache, MySQL and PHP content management system is easy to use. For a simple database frontend I am still looking. MySQL is so fast and robust on my website. No heavy loads here but it runs the whole website with no glitches between power glitches or upgrades.
 
Old 01-13-2005, 09:02 PM   #59
fabricioaraujo
LQ Newbie
 
Registered: Jan 2005
Posts: 1

Rep: Reputation: 0
Firebird #1
 
Old 01-16-2005, 11:20 AM   #60
fikret
LQ Newbie
 
Registered: Jan 2005
Posts: 28

Rep: Reputation: 15
Firebird- Relational Database for the New Millennium
 
  


 


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
1 year from now... ghostwalker Linux - General 18 01-13-2006 08:38 PM
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:26 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