| OverviewPostgreSQL is the world¿s most advanced open-source database.
PostgreSQL is the most comprehensive, in-depth, and easy-to-read
guide to this award-winning database. This book starts with a
thorough overview of SQL, a description of all PostgreSQL data
types, and a complete explanation of PostgreSQL commands. If you are a developer or an administrator, you¿ll
love the chapter that explores PostgreSQL performance. The authors
explain how PostgreSQL stores data on disk (and in memory) and how
to measure and influence the effectiveness of
PostgreSQL¿s caching mechanisms. You¿ll also
learn how PostgreSQL generates and evaluates execution plans. The
authors explain all of the query operators that can appear in the
results of an EXPLAIN command, describing the performance
implications of each operator as well as the conditions which will
cause PostgreSQL to use that operator. PostgreSQL is also a complete guide for the developer.
Whether you¿re developing with C, C++, ODBC, Embedded
SQL, Java, Tcl/Tk, Perl, Python or PHP, you¿ll find a
comprehensive description of the PostgreSQL API for your language
of choice. Easy to follow exercises will walk you through the
development of working applications that fully demonstrate the
features offered by each API. You will also find a chapter that
describes the PL/pgSQL server-side procedural language, learning
how to build triggers, functions, and stored-procedures. The
authors have even included a chapter that walks you through the
process of extending the PostgreSQL server with custom-written C
functions and new data types. The accompanying web site,
www.conjectrix.com, contains downloadable versions of all of the
sample code and a wealth of PostgreSQL-related resources. The last section of PostgreSQL was written for the
PostgreSQL administrator. You will learn how to install PostgreSQL
on Windows, Linux, and Unix systems, from source code or from
pre-compiled installers. The authors have described all of the
PostgreSQL configuration options (compile-time, startup, and
on-the-fly). The chapter on PostgreSQL security describes all of
the authentication protocols that you can choose from and describes
how to secure your database, both internally and externally. If you
have to support a multi-national environment, you will find the
chapter on internationalization and localization to be
invaluable. You won¿t find a more complete guide to PostgreSQL
anywhere. The authors have made PostgreSQL approachable by leading
the reader from basic concepts to advanced features. Whether
you¿re a database beginner or an advanced user, you will
find this book a valuable addition to your library. Editorial ReviewsProduct DescriptionPostgreSQL is the world's most advanced open-source database. PostgreSQL is the most comprehensive, in-depth, and easy-to-read guide to this award-winning database. This book starts with a thorough overview of SQL, a description of all PostgreSQL data types, and a complete explanation of PostgreSQL commands. If you are a developer or an administrator, you'll love the chapter that explores PostgreSQL performance. The authors explain how PostgreSQL stores data on disk (and in memory) and how to measure and influence the effectiveness of PostgreSQL's caching mechanisms. You'll also learn how PostgreSQL generates and evaluates execution plans. The authors explain all of the query operators that can appear in the results of an EXPLAIN command, describing the performance implications of each operator as well as the conditions which will cause PostgreSQL to use that operator. PostgreSQL is also a complete guide for the developer. Whether you're developing with C, C++, ODBC, Embedded SQL, Java, Tcl/Tk, Perl, Python or PHP, you'll find a comprehensive description of the PostgreSQL API for your language of choice. Easy to follow exercises will walk you through the development of working applications that fully demonstrate the features offered by each API. You will also find a chapter that describes the PL/pgSQL server-side procedural language, learning how to build triggers, functions, and stored-procedures. The authors have even included a chapter that walks you through the process of extending the PostgreSQL server with custom-written C functions and new data types.You will learn how to install PostgreSQL on Windows, Linux, and Unix systems, from source code or from pre-compiled installers. The authors have described all of the PostgreSQL configuration options (compile-time, startup, and on-the-fly). The chapter on PostgreSQL security describes all of the authentication protocols that you can choose from and describes how to secure your database, both internally and externally. If you have to support a multi-national environment, you will find the chapter on internationalization and localization to be invaluable. You won't find a more complete guide to PostgreSQL anywhere. The authors have made PostgreSQL approachable by leading the reader from basic concepts to advanced features. Whether you're a database beginner or an advanced user, you will find this book a valuable addition to your library. |
Top Sellers in This Category | Browse Similar Topics | | Top Level Categories:Sub-Categories: | | | |
Reader Reviews From Amazon (Ranked by 'Helpfulness') Average Customer Rating: based on 20 reviews. PostgreSQL (Douglas & Douglas) 2e, 2009-02-06 Reviewer rating: Over 1000 pages of information updated to include version 8.0 of PgSOL. I still Bruce Momjian's 2001 "PostgreSQL: Introdugcion and Concepts" because it is smaller and easier to use, but where old methods no longer work I use this new work. | well worth the money, 2008-12-07 Reviewer rating: This is probably not a book for a beginner, but if one has an experience with database or just programming experience and wants to get into Postgres fast - this book delivers. It was very good for me, anyway. Recommended. | PostgreSQL (2nd Ed) worth having, 2008-03-09 Reviewer rating: As a developer with many years IT experience in control systems and only a little in databases and none with Postgres, I found this book to be extremely helpful. It covered a huge amount of topics with examples and put them together in a way that made it more efficient than googling!
It helped that I knew what topics I needed in looking for answers but the chapters were self explantory in the topics they covered which I believe would allow a beginner to make quick progress in learning Postgres.
Cavaet: If you are after a book to learn SQL and database design (normal forms) you will be disappointed, this book is not for you.
| Comprehensive introduction to PostgreSQL, 2008-01-28 Reviewer rating: I am a database application developer with MS SQL Server, Oracle, Sybase and many other RDBMSs experience.
This book allowed me to start working on PostgreSQL immediately.
Pro: comprehensive, good examples, good supplement to the documentation.
Cons: is not deep enough for me (does not explain format of a transaction log file or WAL file, for example), but, I guess, I should read the PostgreSQL code for this.
If you are new to databases you would need to read some other books first.
| Excellent resource for any PostgreSQL admin, 2007-08-12 Reviewer rating: PostgreSQL 2nd Edition is a phenomenal book if you're a programmer, and a great book if you're a non-programming admin. As someone whose programming ability reaches only ever so slightly beyond bash scripting and WSH, the parts of this book that were really worthwhile to me were those devoted to the administration of PostgreSQL. Backing up, recovering, and performance tuning were excellent resources, especially to someone who had never set up or administered a database. Speaking of which, the very beginning of the book, covering what exactly a database is, terminology, and setting up and creating schema were invaluable. To have all the information in PostgreSQL 2nd Edition consolidated in this one book makes it a must-have for any admin's bookshelf. The only reason it didn't get 5 stars from me was because I'm not a programmer, and I couldn't take away every single ounce this great resource had to offer. |
Some information above was provided using data from Amazon.com. View at Amazon > |
| |
|
|
