PostgreSQL. 2nd Edition

Description

Book Description
The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems.

From the Back Cover

PostgreSQL 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, conjectrix, 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. –This text refers to the Paperback edition.

http://novian.web.ugm.ac.id/jump.php?id=2843

Disclaimer:
Contents of this page are indexed from the Internet. All actions are under your responsability. Email us to report illegal contents or external links and we'll remove them immediately.

Please check the description for download links if any or do a search to find alternative books.

Can't Download?
Please search mirrors if you can't find download links for "PostgreSQL. 2nd Edition" in "Description" and someone else may update the links. Check the comments when back to find any updates.

Search Mirrors
Maybe some mirror pages will be helpful, search this book at top of this page or click here to find more info.

1. Ebooks list page : 380
2. PostgreSQL.2nd.Edition
3. PostgreSQL (2nd Edition)
4. PostgreSQL (2nd Edition)
5. PostgreSQL 2nd Edition
6. PostgreSQL 2nd Edition
7. PostgreSQL 2nd Edition Jul 2005
8. Sams.PostgreSQL.2nd.Edition.Jul.2005.chm
9. [share_ebook] PostgreSQL (2nd Edition) (Developer’s Library)
10. Beginning Databases with PostgreSQL: From Novice to Professional, Second Edition
11. Beginning Databases with PostgreSQL From Novice to Professional 2nd Edition
12. Beginning.Databases.with.PostgreSQL.From.Novice.to.Professional.2nd.Edition
13. Beginning Databases with PostgreSQL: From Novice to Professional, Second Edition
14. Beginning Databases with PostgreSQL From Novice to Professional 2nd Edition Apr 2005 INTERNAL
15. Apress.Beginning.Databases.with.PostgreSQL.From.Novice.to.Professional.2nd.Edition.Apr.2005.INTERNAL.pdf
16. Beginning Databases with PostgreSQL: From Novice to Professional, Second Edition