am i the only one ...... ?

[SteveBrett]

who uses postgres as a linux db ?

i've been programming in php for about 2 months now using a postgres db on debian for an in-house calendar system but only rarely see other postgres users ?

why the obsession with mysql ? no transactions ? bit more speed but turning off file locking speeds up postgres enoormously ....

 

[sophisticate]

Because MySQL has a better name. Makes people feel like they're a part of something big. "Yes, this is *my* SQL".


MySQL used to be significantly faster than Postgres in reads (at least in my benchmarks), so for quick and dirty sites that just pulled information out of the db (simple shopping carts, for instance), mysql seemed to be the way to go. For anything else, Postgres's transaction/locking facilities were invaluable.

With recent releases, however, I don't see much of a difference. They're both excellent databases.

brendanc@icehouse.net

 

[SteveBrett]

hmmmmm.

i see your point- i suppose for business use where transactions are important then postgresql is the way to go - the app i wrote does actually do a lot of reads - takes about 10 seconds to do 2100 reads along with a significant amount of parsing and dumping of html tables etc.
i also found that one of the reasons that postgresql was slower in benchmarking was for every write to the db the file system is checked - this can be turned off and the speed increases are dramatic ...

 

[SteveBrett]

http://www.phpbuilder.com/columns/tim20000705.php3?page=1

excellent review of MySql and Posgtres compared.

 

[vcherubini]

In one of the webtechniques magazines there is an entire article on why PHP, Apache, and mySQL are the best language/server/database to use for e-commerce.

Go to

http://www.webtechniques.com

and check out the back orders and see if you can find the article.


-Vic vic cherubini
malice365@hotmail.com

http://www.epicsoftware.com

====
Knows: Perl, HTML, JavScript, C/C++, PHP, Flash, Director
====

 

[rycamor]

I agree with sophisticate; each is a great product, although with different strengths.

However, even though MySQL 3.23 is technically still in pre-release mode, it should really be considered as production-ready. With this version, MySQL now CAN support transactions if you choose to compile it that way. Also, they are working on row-level locking, and all of the other great SQL ideals. They simply made different choices about what to support first in development, which made them an easier choice for most web-based applications.

 

[SteveBrett]

ok - thanks ...

i'm kind of used to postgres now and it does seem to be a more 'complete' rdbms .. but i'm sure the argument will rage on elsewhere.

i still think of mysql as the access of linux db's though ...