PostgreSQL: Introduction and Concepts (英語) ペーパーバック – 2000/12/4
Kindle 端末は必要ありません。無料 Kindle アプリのいずれかをダウンロードすると、スマートフォン、タブレットPCで Kindle 本をお読みいただけます。
The open source PostgreSQL database is soaring in popularity, as thousands of database and web professionals discover its powerful features, transaction support, performance, and industrial-strength scalability. In this book, a founding member of the PostgreSQL development team introduces everything you need to know to succeed with PostgreSQL, from basic SQL commands through database administration and optimization. PostgreSQL assumes no previous database expertise: it establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's advanced, innovative capabilities. Bruce Momjian walks readers step-by-step from their first database queries through the complex queries needed to solve real-world problems. He presents proper query syntax, then explores the value and use of each key SQL commands in working applications. Learn to manipulate and update databases, customize queries, work with SQL aggregates, use joins, combine SELECTs with subqueries, work with triggers and transactions, import and export data, use PostgreSQL query tools, and more. Discover PostgreSQL techniques for server-side programming and multi-user control, and master PostgreSQL's interfaces to C, C++, ODBC, JDBC, Perl, and Tcl/TK. You'll also find detailed coverage of PostgreSQL administration, including backups, troubleshooting, and access configuration.
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.
1件中1 - 1件目のレビューを表示
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 ...