|
|
Posted by Toby A Inkster on 04/03/07 15:01
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
--
Toby A Inkster BSc (Hons) ARCS
Contact Me ~ http://tobyinkster.co.uk/contact
Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux
* = I'm getting there!
Navigation:
[Reply to this message]
|