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. |
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/ |
Quote:
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. |
Postgres is the only database which suits for all my commercial and internal projects.
|
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). |
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 |
Quote:
|
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. |
I can't believe Postgres is beating MySQL. Who won last year?
|
Quote:
|
Quote:
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. |
I think im implementing Postgres on my system, does it have an equal to mySql's PHPmyAdmin?? I need Web based?
|
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.
|
Quote:
|
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. |