LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > 2003 LinuxQuestions.org Members Choice Awards
User Name
Password
2003 LinuxQuestions.org Members Choice Awards This 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

View Poll Results: Database of the Year
MySQL 405 36.45%
Postgres 269 24.21%
Oracle 25 2.25%
DB2 2 0.18%
Sybase 3 0.27%
Berkley DB 4 0.36%
Firebird 403 36.27%
Voters: 1111. You may not vote on this poll

 
 
Search this Thread
Old 11-17-2003, 04:24 PM   #16
josephhh
LQ Newbie
 
Registered: Nov 2003
Location: Australia
Distribution: Debian
Posts: 2

Rep: Reputation: 0

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.

See http://www.postgresql.org/presskit/en/presskit74.html for details.
 
Old 11-17-2003, 04:29 PM   #17
rich dougherty
LQ Newbie
 
Registered: Nov 2003
Posts: 1

Rep: Reputation: 0
It's hard to narrow it down to a single database. Perhaps we should use the Debian voting system. :-)

http://seehuhn.de/comp/vote.html

Rich
--
Rich Dougherty
http://www.rd.gen.nz/
 
Old 11-17-2003, 04:34 PM   #18
smazerski
LQ Newbie
 
Registered: Jan 2003
Posts: 1

Rep: Reputation: 0
Quote:
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.
 
Old 11-17-2003, 11:10 PM   #19
bhuvanbk
LQ Newbie
 
Registered: Nov 2003
Location: India
Posts: 1

Rep: Reputation: 0
Postgres is the only database which suits for all my commercial and internal projects.
 
Old 11-17-2003, 11:28 PM   #20
cuerty
LQ Newbie
 
Registered: Jul 2003
Distribution: Gentoo for me, Slackware for servers
Posts: 27

Rep: Reputation: 15
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).
 
Old 11-18-2003, 12:28 AM   #21
quadrumanous
LQ Newbie
 
Registered: Nov 2003
Posts: 4

Rep: Reputation: 0
SAP Db?

Hi,

why is SAP Db missing on the list? (http://www.sapdb.org/7.4/sap_db_gnu.htm)

It's pretty good en VERY fast. Whit nice finished admin tools.

Regards,

Jean
 
Old 11-18-2003, 12:28 AM   #22
paszwurd
LQ Newbie
 
Registered: Nov 2003
Posts: 1

Rep: Reputation: 0
Quote:
Originally posted by Superduck
Please consider adding sqlite
Yeah. Should be there. I'd still keep my vote for postgres tho ...
 
Old 11-18-2003, 12:33 AM   #23
quadrumanous
LQ Newbie
 
Registered: Nov 2003
Posts: 4

Rep: Reputation: 0
Postgres Vs SAP Db

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.
 
Old 11-18-2003, 10:15 AM   #24
Crashed_Again
Senior Member
 
Registered: Dec 2002
Location: Atlantic City, NJ
Distribution: Ubuntu & Arch
Posts: 3,503

Rep: Reputation: 57
I can't believe Postgres is beating MySQL. Who won last year?
 
Old 11-18-2003, 10:31 AM   #25
gboutwel
Member
 
Registered: May 2001
Location: Norton, KS
Distribution: Mandrake, Xandros, and Debian 3.0 (Woody) as a proxy
Posts: 103

Rep: Reputation: 15
Quote:
Originally posted by jeremy
Firebird has been added.
Awesome. TY. No prizes guesing which I voted for!
 
Old 11-18-2003, 11:58 AM   #26
z_darius
LQ Newbie
 
Registered: Nov 2003
Location: Canada
Distribution: Mandrake, e-smith
Posts: 27

Rep: Reputation: 15
Quote:
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.
 
Old 11-18-2003, 01:15 PM   #27
sopiaz57
Member
 
Registered: Apr 2003
Distribution: RH 8
Posts: 246

Rep: Reputation: 30
I think im implementing Postgres on my system, does it have an equal to mySql's PHPmyAdmin?? I need Web based?
 
Old 11-18-2003, 01:26 PM   #28
quadrumanous
LQ Newbie
 
Registered: Nov 2003
Posts: 4

Rep: Reputation: 0
It's called phppgadmin and you can find it on http://sourceforge.net/projects/phppgadmin, other tools you can find on http://gborg.postgresql.org/ . I use the pgadmin III now, which workt pretty well.
 
Old 11-18-2003, 01:27 PM   #29
Alicia
LQ Newbie
 
Registered: Nov 2003
Posts: 2

Rep: Reputation: 0
Quote:
Originally posted by sopiaz57
I think im implementing Postgres on my system, does it have an equal to mySql's PHPmyAdmin?? I need Web based?
Why don't you try Firebird. It's small, full featured and YES, it does have PHP support and at least 2 browser based admin tools are available for it.
 
Old 11-18-2003, 01:29 PM   #30
sopiaz57
Member
 
Registered: Apr 2003
Distribution: RH 8
Posts: 246

Rep: Reputation: 30
are any of these web based, phppgadmin seems to be a non web based client
 
  


 


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 06:47 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