Re: Survey: MySQL vs PostgreSQL for PHP
| From: | Glenn Sieb | Date: | Fri, 05 Jul 2002 21:27:45 +0000 |
| Subject: | Re: Survey: MySQL vs PostgreSQL for PHP | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-105749@lists.php.net to get a copy of this message | ||
Has anyone read: PHP and PostgreSQL Advanced Web Programming by Ewald Geschwinde and Hans-Juergen Schoenig yet? I'd been waiting for this book to come out... but would like to know if it's actually worth the $ first.
Back to the question at hand...
Personally I like PostgreSQL for a few reasons:
Scalability
Ease of use
SECURITY (yeah--well what can I say.. I work for a security company LOL--but seriously, Postgres has more security that MySQL does... and more flexible...)
Variety of data types (for instance a CIDR block and IP data type...)
Stored procedures
Cleanup built in (vacuum)
Unions
Full Joins
Constraints
But that's just me. :)
Glenn
---
Glenn E. Sieb
System Administrator
Lumeta Corporation
+1 732 357-3514 (V)
+1 732 564-0731 (Fax)