Posted by bill on 04/04/07 13:51

Erwin Moller wrote:
> 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
>
Thank you all !

bill

[Back to original message]