View Review Details
| Book: |
|
SQL in a Nutshell |
| Subject: |
|
Good coverage of Oracle/SQL Server |
| Date: |
|
2006-03-24 10:45:19 |
| From: |
|
loquin
|
|
|
And, the coverage of PostgreSQL and MySQL was good for the versions listed, BUT, both the open source datbases have had MAJOR releases before this book was published.
PostgreSQL is now at version 8.1+, and MySQL is at version 5.
MySQL is now more ANSI compliant in its SQL implementation, and narrowed the feature gap between it and PostgreSQL. (it now supports limited stored procedures and trigger functionality.) PostgreSQL is now released in a native Win32 version, and has database roles, two-phase commits, savepoints, point-in-time recovery, ALTER TABLE supports column's data type, and CSV support in the COPY command.
So, if you want to compare proprietary databases, it's a great book. If you also need to work with open source databases, just be sure to run their older releases.
|
|
| |
