PostgreSQL (2nd Edition)

PostgreSQL: The comprehensive guide to building, programming, and administering PostgreSQL databases, Second Edition
By Korry Douglas

# Paperback: 1032 pages
# Publisher: Sams; 2 edition (August 5, 2005)
# Language: English
# ISBN-10: 0672327562
# ISBN-13: 978-0672327568

Product 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 simple-to-read, code-based approach that makes it simple to know 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 simple-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 like the chapter that explores PostgreSQL performance. The authors clarify 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 clarify all of the query operators that can appear in the results of an CLARIFY 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. Simple 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-glide). 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.

About the Author
Korry Douglas is the Director of Research and Development for Appx Software. Over the last two decades he has worked on the design and implementation of an umber of high-level languages and development environments, and his work with a variety of database products (Oracle, Sybase, SQL Server, PostgreSQL, MySQL and mSQL) given him a unique understanding of the commonalities of, and differences between, databases.

PostgreSQL (2nd Edition) (Paperback)
by Korry Douglas
ISBN: 0672327562
Publisher: Sams

Price: USD 38.49
54 used & new available from USD 6.43

| 4 | 21

Popularity: 3% [?]

Download Links:

(1 votes, average: 4.00 out of 5)

 Loading ...

Related eBooks - Up | Down

Sams Teach Yourself WordPress in 10 Minu...

Sams Teach Yourself WordPress in 10 Minutes Author: Chuck Tomasi, Kreg Steppe Publisher: Sams; 1 edition Publication Date: 2010-03-28 ISBN-10: 0672331209 ISBN-13: 9780672331206 Paperback: 240 Pages Sams Teach Yourself WordPress in 10 Minutes Chuck Tomasi Kreg Steppe Sams Teach Yourself WordPress in 10 Minutes gives you ...
Download

(1 votes, average: 5.00 out of 5)

 Loading ...

Tags:Minutes, Sams, Teach, wordpress, Yourself; 31 downloads ; Comments: One Response

Sams Teach Yourself PHP, MySQL and Apach...

Sams Teach Yourself PHP, MySQL and Apache All in One Author: Julie C. Meloni Publisher: Sams; 3 edition Publication Date: 2006-07-10 ISBN-10: 0672328739 ISBN-13: 9780672328732 Paperback: 624 Pages A new edition of this title is available, ISBN-10: 067232976X ISBN-13: 9780672329760 You own your own ...
Download

(1 votes, average: 5.00 out of 5)

 Loading ...

Tags:Apache, MySQL, Sams, Teach, Yourself; 34 downloads ; Comments: 5 Responses

Sams Teach Yourself Web Publishing with ...

Sams Teach Yourself Web Publishing with HTML and CSS in One Hour a Day Author: Laura Lemay, Rafe Colburn Publisher: Sams; 5 edition Publication Date: 2006-06-18 ISBN-10: 0672328860 ISBN-13: 9780672328862 Paperback: 816 Pages Sams Teach Yourself Web Publishing with HTML and CSS in ...
Download

(No Ratings Yet)

 Loading ...

Tags:Hour, html, Publishing, Sams, Teach, Yourself; 22 downloads ; Comments: 5 Responses

Sams Teach Yourself Flash MX ActionScrip...

Sams Teach Yourself Flash MX ActionScript in 24 Hours Author: Gary Rosenzweig Publisher: Sams Publication Date: 2002-05-12 ISBN-10: 0672323850 ISBN-13: 9780672323850 Paperback: 384 Pages Macromedia Flash delivers sound, interactivity, graphics, and animations across multiple browsers and platforms. It enables developers to create interactive ...
Download

(No Ratings Yet)

 Loading ...

Tags:ActionScript, Flash, Hours, Sams, Teach, Yourself; 10 downloads ; Comments: 5 Responses

Sams Teach Yourself Wikipedia in 10 Minu...

Sams Teach Yourself Wikipedia in 10 Minutes Author: Michael Miller Publisher: Sams; 1 edition Publication Date: 2009-10-08 ISBN-10: 0672331233 ISBN-13: 9780672331237 Paperback: 208 Pages Sams Teach Yourself Wikipedia in 10 Minutes gives you straightforward, practical answers when you need fast results. By working through ...
Download

(1 votes, average: 5.00 out of 5)

 Loading ...

Tags:Sams, Teach, Wikipedia, Yourself; 15 downloads ; Comments: No Responses

Sams Teach Yourself YouTube in 10 Minute...

Sams Teach Yourself YouTube in 10 Minutes Author: Michael Miller Publisher: Sams; 1 edition Publication Date: 2009-08-27 ISBN-10: 0672330865 ISBN-13: 9780672330865 Paperback: 208 Pages Sams Teach Yourself YouTube in 10 Minutes Sams Teach Yourself YouTube in 10 Minutes offers straightforward, practical answers when you need ...
Download

(No Ratings Yet)

 Loading ...

Tags:Sams, Teach, Yourself, YouTube; 9 downloads ; Comments: One Response

Sams Teach Yourself Drupal in 24 Hours...

Sams Teach Yourself Drupal in 24 Hours Author: Jesse Feiler Publisher: Sams; 1 edition Publication Date: 2009-11-19 ISBN-10: 0672331268 ISBN-13: 9780672331268 Paperback: 456 Pages In just 24 sessions of one hour or less, learn how to build powerful, easy-to-maintain websites with Drupal–fast! Using this ...
Download

(1 votes, average: 5.00 out of 5)

 Loading ...

Tags:Drupal, Sams; 18 downloads ; Comments: 4 Responses

Sams Teach Yourself Flickr in 10 Minutes...

Sams Teach Yourself Flickr in 10 Minutes Author: Steve Holzner Publisher: Sams; 1 edition Publication Date: 2009-10-16 ISBN-10: 0672330954 ISBN-13: 9780672330957 Paperback: 224 Pages Sams Teach Yourself Flickr® in 10 Minutes offers straightforward, practical answers when you need fast results. By working through 10-minute ...
Download

(No Ratings Yet)

 Loading ...

Tags:Flickr, Minutes, Sams, Teach, Yourself; 4 downloads ; Comments: No Responses