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.
The name of Postgres should be PostgreSQL.
Check out it's new 7.4 release, just some of it's performance improvements:
# Hash aggregation in memory to make data warehousing and OLAP queries up to 20 times faster;
# Improvements in subquery handling by the planner resulting in up to 400% speed increases in some complex queries;
Wow and thanks once again to the PostgreSQL Global Development Group.
Originally posted by shanness PostgreSQL rocks my planet, very fast, very advanced , very easy to use database, can't understand why it's not more popular than MySQL, I assume it's because many people haven't tried it?
I think because it's not in people's consciousness the way MySQL is. And for most
things MySQL seems to work well enough. It's only when you get into complex
database designs that MySQL's weaknesses become apparent, and your typical
PHP && MySQL web app could probably work just as well with a file-based data retrieval
system.
Distribution: Gentoo for me, Slackware for servers
Posts: 27
Rep:
Ummmm I vote for MySQL, but as my work is mostly over this things, I like to say a few words.
Database aren just as distros that you can choise your faivorite, there are diferences in these that ar as options in this poll, and that is for some reason. I can't make a php site using berkley as db engine, in fact, I can, but is wasting resources, and extremy slow (To code and to run). Also I can't run a OpenLDAP server using MySQL or the autentication could take hours
MySQL is great for applicacions, web sites, even for some other things (MTAS using MySQL to store information are a great option). But it dosn't make it 'the great'.
As I say, my vote was for MySQL, it grouw up a lot this year (Foreing Keys, Subquerys in 4.1 ALPHA).
Yeah, the license of Postgres is much more open for us to use it in commerciaal products we develop. SAP Db is good now, with the guys of MySQL are going to turn it into MaxDb with the MySQL license.
I was quite impressed by the performance of SAP Db, with I have to test Postgres 7.4 next week.
Originally posted by Crashed_Again I can't believe Postgres is beating MySQL. Who won last year?
Well, MySQL is just a glorified file system with an SQL interface. It is getting better but still a little to go before it can be called a true enterprise level RDMS.
Postgres could be OK but it's a little to cumbersome at this time.
Firebird is by far the most mature of the three, and available for more platforms than all the other ones put together. It's one of those "set and forget" systems. Rock solid, small footprint and unlike MySQL, it's 100% free for both personal and business use.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.