Carpo Posted January 19, 2008 Share Posted January 19, 2008 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). Link to comment Share on other sites More sharing options...
NiceCarpet Posted January 19, 2008 Share Posted January 19, 2008 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. Link to comment Share on other sites More sharing options...
Carpo Posted January 19, 2008 Author Share Posted January 19, 2008 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 Link to comment Share on other sites More sharing options...
NiceCarpet Posted January 20, 2008 Share Posted January 20, 2008 I'd go for MySQL in that case, That PC has more then enough power. Link to comment Share on other sites More sharing options...
Stephen Veteran Posted January 20, 2008 Veteran Share Posted January 20, 2008 yeh, you have more than the lowest specks for mysql,and it prefer it to post ste Link to comment Share on other sites More sharing options...
Iian K Posted January 20, 2008 Share Posted January 20, 2008 I would go with MySQL. That is what I use for testing my site. Link to comment Share on other sites More sharing options...
Mathachew Veteran Posted January 20, 2008 Veteran Share Posted January 20, 2008 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. Link to comment Share on other sites More sharing options...
Carpo Posted January 20, 2008 Author Share Posted January 20, 2008 Thanks all :) Link to comment Share on other sites More sharing options...
DJ_Alex Posted January 20, 2008 Share Posted January 20, 2008 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 :) Link to comment Share on other sites More sharing options...
Recommended Posts