2003 LinuxQuestions.org Members Choice AwardsThis forum is for the 2003 LinuxQuestions.org Members Choice Awards.
You can now vote for your favorite products of 2003. This is your chance to be heard!
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.
Originally posted by permanentE After reading all the comments here I'll never use Firebird. Their user community seems like they are all a**holes.
I think I'll stick with postgresql.
Please don't judge the whole community by the unfriendly comments of a few members. I've been exposed to different user communities the past year and I can say that the Firebird community is one of the friendliest, most supportive groups there is. When I was starting to use Firebird, I didn't even have to ask questions; just reading the docs and the volume of information exchange at the community everyday made me feel like I'm not a newbie anymore.
As for Firebird, it's heaven sent for my development requirements. Been using it for almost 2 years now and have already done 3 corporate projects using it. Great power, low maintenance, I'm never going to look back at MySQL (my first consideration).
I agree with sesummers, it's not our loss if you decide not to use Firebird; especially if you based your decision only on a few unfriendly comments of some Firebird users and not really looked at what Firebird can really do.
I (pgsql user) just traverse firebird site to see what sort of bird it is. IMHO this site is useless for any who searches clear info about its tech features. I want to compare firebird vs pgsql and understand high firebird rate in this vote.
Originally posted by sigor I (pgsql user) just traverse firebird site to see what sort of bird it is. IMHO this site is useless for any who searches clear info about its tech features. I want to compare firebird vs pgsql and understand high firebird rate in this vote.
Jeremy and others offended by one of the Firebird users
I think that on behalf of Firebird community I ask for forgiveness.
Well remember that not all members of a community are either good or bad.
I see a number of questions from MySQL users when Firebird was leading. And I suggested that we should have databases for two distinct catagories Web and Client-Server. (Or you can add Local database catagory aswell for likes of X-Base/Paradox etc)
Though I voted for Firebird, I don't think it compares with Oracle or DB/2 in terms of features and scalability. It is small beast that gets the job done fast and efficiently and reduces TCO for my customers.
I think MySQL is more suitable for web and local database applications. And it is in the market for much longer than Firebird. Even I was wondering why Firebird is taking such a big lead.
Now for Firebird community...
Folks, getting 2nd place in such a short time is remarkable ! if the community of Firebird keeps growing like this, nothing can stop it from winning first place next year (MySQL has yet to go a long way before it can compete with Firebird in terms of features).
Originally posted by tauseef Jeremy and others offended by one of the Firebird users
Now for Firebird community...
Folks, getting 2nd place in such a short time is remarkable ! if the community of Firebird keeps growing like this, nothing can stop it from winning first place next year
Honestly, I'm surprised gap is so small. I'm waited MySQL will overcome any other twice - firstly, as you mentioned, it is presented on market long ago, secondly, I believed amount of developers of small and having only one reqirement - reactivity on selects - Web applications is much more than amount of complicated ERP and so on developers. Seems I was wrong or my beloved Firebird is more wide spreaded than I supposed.
Actually no matter how much I like Firebird, I can not deny the fact that MySQL is being used by atleast 10 times more developers than Firebird. And it is no sureprise. MySQL is free, fast and it comes with all linux distros as standard. So any developer can use it and develop an application or Website without worring about deployment. Also it has many years head-start over firebird.
If features were only criteria for popularity then Postgress would win over MySQL any time. It is the ease of use and simplicity of MySQL that gets it the honors.
Firebird is now catchingup. It is cross-platform,free and simple like mySQL with atleast 6/7 times smaller footprint and features of a true RDBMS that are compareable with many commercial RDBMS. So it is no wonder that it is catching-up.
What most web-developers try is to put business-logic in middle-tier or scripting languages. If you try stored procedures with a rich extendable stored-procedural language of firebird, you will be surprised to see the difference.
For example for a travel-related project the best result I could get from a middle tier on a very complex database was 20 seconds. But when I moved the same logic down to a stored procedure my response times reduced to under 1 second !!!!
But for simple select statements (with relatively small result-sets) MySQL beats Firebird any time.
The choice is yours and it also depends on the type of application you are building.
This is not true, Mysql does not have many years head start over firebird.
Lets not forget that Firebird is a fork of Interbase and that has been in the market for 20 years, since 1984 to be exact.
In reality it is MySQL that is many years behind FB.
<Also it has many years head-start over firebird.>
True, Firebird is a fork of Interbase, but it has from the very start of its incarnation, is going on its own route. And now Interbase 7 and Firebird 1.5 are going on different routes and have a number of incompatibilities, and the gap is becoming wider and wider.
Even Interbase is not able to catchup to the increasing adoption of Firebird world wide.
Technically MySQL will have to prove a lot in upcoming version 5 before it can even be compared with DB/2, Oracle and even Firebird.
In terms of popularity MySQL is number one (No doubt about it). But other open source databases are catching up in terms of popularity as well. The poll this year (and last year aswell) are a proof of it.
Are all these free? I would guess that I have some sort of database application on my Mandrake 9.2 disks. What should I look for? On the install, I checked the database box but I don't know how to install or start the program. I want to build a database for my business. I own a copy of MSAccess and have created databases with it, but I would like to try something else. Do I need to know SQL?
Last edited by Whatshisface; 02-05-2004 at 09:37 PM.
Remember. MySQL is free for non-commmercial applicatoins. But you need to have a liscenced copy for commercial deployment.
Firebird and (I think) Postgress are absolutely free for any kind of use and deployment.
As for MSAccess. It is not just database. It is also development environment. You can connect to any of the above databases from within MSAccess using ODBC or ADO. And enjoy the same ease of MS-Access. Remember MS-Access database has quite a few short-commings. There fore Microsoft encourages you to use MSDE( stripped down SQL-Server) engine that comes with MSAccess. But you can use other databases aswell.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.