Posted by Erwin Moller on 04/03/07 16:24

Toby A Inkster wrote:

> bill wrote:
>
>> what is a decent database to use with PHP, and why ?
>
> Of the SQL databases which I've used, I'd put them roughly in this order
> of quality:
>
> 1. Oracle
> =2. PostgreSQL
> =2. Microsoft SQL Server
> 4. MySQL (5.x)
> 5. Firebird
> 6. SQLite
> 7. Microsoft Access
>
> There are plenty of other SQL databases out there of course, but I've not
> used them much. Overall, I tend to recommend PostgreSQL because it's free
> whereas MS SQL Server and Oracle are both fairly expensive. (They do each
> offer a cut-down "express" edition, though this is more suited for a
> development environment than full production use.) Also, in my experience
> the PHP MS SQL driver can be a bit flaky at times whereas the PostgreSQL
> driver seems very reliable.
>
> Nowadays, the gap between PostgreSQL and MySQL is much smaller than it
> used to be, but PostgreSQL still offers several advantages over MySQL:
>
> - Good support for foreign keys
>
> - Good support for triggers
>
> - Fuller support for transactions
>
> - More accurate support for SQL standard syntax (e.g. "||"
> is the concatenate operator, not an alias for "OR"; double
> quotes are used to quote identifiers)
>
> - Server-side functions in a variety of languages (e.g. Python,
> Perl, Tcl)
>
> - Boolean data type
>

:-)
I soooo second that opinion.
Go Postgres, and never look back.
It even works on W$ OS (W2000 and up) nowadays.

Regards,
Erwin Moller

[Back to original message]