Some have said PostgreSQL, because it is scalable, and a few benchmarks have kicked MySQL in the teeth, and others are saying MySQL because its more widely supported, there are a few scripts i am looking at which i will run on a home server, which require SQL and php, and although they all say they can use PostgreSQL, it seems like they really want you to use MySQL.

Is it a case of personal taste (in this case im leaning towards MySQL) go with what can grow (PostgreSQL) or go with what is supported(MySQL).

Whats the specs of the home server?
Whats your net upload speed?

Since it is a home website it's probably not going to be catering to alot of people at once, I don't see to much of a problem with just going with MySQL. Performance increase is kinda moot if it's just going to be doing small-ish things.

p4 3.4
2GB pc 4400
60gb sys disc
650gb raid0

20mbit dn / 768K up (yes i know its crap)

Mainly going to be a few friends and family looking at various things i will put up there, test sites and such maybe 10 at most

I'd go for MySQL in that case, That PC has more then enough power.

yeh, you have more than the lowest specks for mysql,and it prefer it to post

ste

I would go with MySQL. That is what I use for testing my site.

I use both extensively, but given the lack of traffic you'll be getting, and how small the overall application will be (like "testing some things"), MySQL is more than sufficient. PostgreSQL shines in larger applications. There are several things that PG natively offers that MySQL doesn't have, but if you ever wanted to move this to a webhost, then you'll have a much, much easier time finding one that supports MySQL than with PG.

Thanks all

I use MySQL for several years in a small webhosting server and it has been enough for me, so I agree with all people here in this thread