PostgreSQL or MySQL on FreeBSD


Recommended Posts

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

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

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

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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.