9.2.2 PostgreSQLThis is NOT the latest copy of this book; click here for the latest version.
PostgreSQL is the world's most advanced open-source DBMS, and is quite fast. It supports all of the features described earlier, such as stored procedures, triggers, and views, but it is not as fast as MySQL as a result. From version 7.4 onwards, there is native Windows support (previously there was not), so Postgres (as it is most commonly referred to) is cross-platform like MySQL.
The Postgres developers have a strong belief in developing standards-compliant software, so they keep fairly stringently to agreed database definitions. The lack of a proper Windows port has left Postgres in MySQL's dust when it comes to speed of adoption, however once users tend to hit the ceiling of MySQL's ability and need functionality that just is not going to be available for at least a year yet, people often migrate over to Postgres. Luckily PHP makes this transition easy.
9.2.2.1 Advantages
-
Free
-
Cross-platform
-
Feature-complete
9.2.2.2 Disadvantages
-
Not the fastest
-
Poor Windows support
|
Want to see this stuff in print? PHP in a Nutshell takes the core topics covered here, adds in thousands of edits from the editorial team and myself, and combines them to make an unbeatable reference for PHP programmers at all levels.
My latest book has hundreds more tips on how to use PHP, Apache, and MySQL, plus Perl, Python, shell scripts, performance tuning, and more!
|
