Re: A "decent database", was Updating the SQL key value

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
.

Relevant Pages