On Tue, Jun 02, 2009 at 04:36:28PM -0400, optoma...@rogers.com wrote:

> Everybody has given Angus really great advice in this previous thread
> and I have learned a lot too. I hope no one mines the fork but I am in
> the exact same situation as Angus. If anyone could spare a bit of time
> regarding application infrastructure I would really appreciate it.
> I know there are lots of databases out there and PostgreSQL is held in
> high regard but the overwhelming majority of examples seem to use MySQL.
> Considering that Oracle has bought Sun, do you think it is still wise to
> use it for new applications? Oracle does not have much "street cred" in
> open source circles, maybe they'll cause trouble later and MySQL was
> already forking was it not? I'd like to use the same DB for a few years.
> I am attracted to building an application from scratch but I will never
> get an object relational mapper to work without a framework. If I go the
> scratch route, I'd better get my database done right(as was advised in
> the previous thread!)and getting that right probably starts with
> choosing the right DB.

First, you don't need an ORM. I'll leave it at that.

Second, if you're doing something which will be supported on internal
servers, choose PostgreSQL. MySQL has deficiencies caused by its
development by programmers. PostgreSQL was developed by DBAs. And
frankly, the choice of storage engines in MySQL is crazy. Some are
incapable of handling transactions, for example. You have to do research
and figure out which one has the features you need. Another random
example of MySQL deficiency is that it does not natively support boolean
fields. And at least some of the engines don't support foreign keys,

MySQL has the popularity it does because 1) it has a *company* behind
it, which PostgreSQL does not; 2) it is relatively easy to administer;
3) at one time it was faster than PostreSQL; 4) inertia/momentum.

As for Oracle/Sun/MySQL, because MySQL is open source, there are already
forks of it. If Sun decides to get pissy, a new version of MySQL can be
cobbled together by the open source community in short order. No one
knows what Oracle will do with MySQL, ultimately, but I wouldn't let it
worry you too much.

Your choice of DB won't really matter that much. Any database should do
pretty much whatever you ask of it. You can't actually go wrong with any
database. Your choice of database will mostly affect two things: 1) how
much work you have to do that the database won't do for you, and 2)


Paul M. Foster

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to