2004 LinuxQuestions.org Members Choice AwardsThis 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
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.
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.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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)
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:
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???
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'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.
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.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.