Postgresql: Introduction and Concepts (英語) ペーパーバック – 2000/11/1
Bruce Momjian is a founding member of the PostgreSQL Global Development Team. He is currently a senior consultant with Wilson Technology Associates in Newtown Square, Pennsylvania, designing and developing relational database applications for some of the largest law firms nationwide.
- 出版社 : Addison-Wesley (2000/11/1)
- 発売日 : 2000/11/1
- 言語 : 英語
- ペーパーバック : 461ページ
- ISBN-10 : 0201703319
- ISBN-13 : 978-0201703313
- 寸法 : 17.78 x 2.54 x 22.23 cm
- Amazon 売れ筋ランキング: - 2,701,163位洋書 (の売れ筋ランキングを見る洋書)
The book's title says "Introduction and Concepts", letting you know this isn't an advanced treatise on Postgres. The first half of the book handily summarizes SQL and then dives into hands-on PostgreSQL, run interactively via the psql interactive utility. This is a nice way to give readers direct experience with Postgres, but it is also automatically limiting because readers never learn how to use Postgres in the context of an application. There is a chapter on programming interfaces, but it covers ten languages in ten pages, which isn't enough to impart any practical Postgres programming skills.
The second half of the book is a verbatim replica of the SQL Commands reference from the official Postgres user's guide. It's handy to have in the book, but it's hard to give the author any credit for simply pouring this stuff into his book unchanged. I would have liked to see some useful annotations from the author, reflecting his obviously considerable experience with Postgres.
I gave the book four stars in part because the author is breaking new ground by carving out a niche with publishers for future PostgreSQL books. I'm hoping a second edition of his book comes soon, replacing (or augmenting) those 250 pages of reference material with concrete programming examples in a variety of languages and interesting comments on usage. In the meantime, this book is a very nice primer for our new employees who have to come up to speed on PostgreSQL quickly.
I wish they were more specific about field max sizes - oracle for example is very clera and very constrained (4k limits on inmserts to varchar fields for example). These limits appear to be arbritarily large as we have tested without overrunning them.
ALso we have of course the source files for postgres, so questions like that can be answered with some familiarity with the code. Postgres isn't Oracle and it certainly wont scale like Oracle, but for web projects witha few thousand records and a few dozen simultaneous users it, and this book, are perfect.
1. Nearly half of the book is Appendices. Maybe OK if you don't want to read the free docs on the computer screen.
2. Written like an encyclopedia. Ever try reading one of those? The lack of user exercises is particularly irritating.
Get the Wrox book instead of this one and you will be richer and happier ...