LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   2003 LinuxQuestions.org Members Choice Awards (https://www.linuxquestions.org/questions/2003-linuxquestions-org-members-choice-awards-37/)
-   -   Database of the Year (https://www.linuxquestions.org/questions/2003-linuxquestions-org-members-choice-awards-37/database-of-the-year-116360/)

josephhh 11-17-2003 04:24 PM

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.

rich dougherty 11-17-2003 04:29 PM

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/

smazerski 11-17-2003 04:34 PM

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.

bhuvanbk 11-17-2003 11:10 PM

Postgres is the only database which suits for all my commercial and internal projects.

cuerty 11-17-2003 11:28 PM

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 :p

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).

quadrumanous 11-18-2003 12:28 AM

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

paszwurd 11-18-2003 12:28 AM

Quote:

Originally posted by Superduck
Please consider adding sqlite
Yeah. Should be there. I'd still keep my vote for postgres tho ...

quadrumanous 11-18-2003 12:33 AM

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.

Crashed_Again 11-18-2003 10:15 AM

I can't believe Postgres is beating MySQL. Who won last year?

gboutwel 11-18-2003 10:31 AM

Quote:

Originally posted by jeremy
Firebird has been added.
Awesome. TY. No prizes guesing which I voted for! ;)

z_darius 11-18-2003 11:58 AM

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.

sopiaz57 11-18-2003 01:15 PM

I think im implementing Postgres on my system, does it have an equal to mySql's PHPmyAdmin?? I need Web based?

quadrumanous 11-18-2003 01:26 PM

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.

Alicia 11-18-2003 01:27 PM

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.

sopiaz57 11-18-2003 01:29 PM

are any of these web based, phppgadmin seems to be a non web based client


All times are GMT -5. The time now is 12:11 AM.