Shop Khloud Popcorn
Buy New
-17% $45.70
$3.99 delivery May 12 - 19
Ships from: World Deals, USA
Sold by: World Deals, USA
$45.70 with 17 percent savings
List Price: $54.99 Image
$3.99 delivery May 12 - 19. Details
Usually ships within 7 to 8 days
$$45.70 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$45.70
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Shipper / Seller
World Deals, USA
World Deals, USA
Shipper / Seller
World Deals, USA
Returns
30-day refund/replacement
30-day refund/replacement
Quick refund
Usually issued within 24 hours. See exceptions
Shipping fee
May apply, not eligible for free return. See details
Convenient dropoff
At any of our 50,000 US locations.
See return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
$7.09
May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less See less
FREE delivery April 30 - May 4. Details
In stock
$$45.70 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$45.70
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Ships from and sold by ThriftBooks-Atlanta.
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

  • PostgreSQL

Follow the author

Get new release updates & improved recommendations
Korry Douglas
Follow
Something went wrong. Please try your request again later.

PostgreSQL 2nd Edition

by Korry Douglas (Author)
4.0 out of 5 stars (21)
{"desktop_buybox_group_1":[{"displayPrice":"$45.70","priceAmount":45.70,"currencySymbol":"$","integerValue":"45","decimalSeparator":".","fractionalValue":"70","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"3wB0PGC4lh5TRlqVVds4EAGlCnO%2B8pPG4cm67Ug0f3THw2T0dU7K1l40ugctoiIVpgIBPABEIXNNE291Gc7n1DZezZpp0nyBq%2BWViCgtkOXOopfHyMWT8qM%2B4dpWv6qD1Aih%2BTPTd1A4wS0%2B2Rq52Ft4MveiMznEdNj0DscsF7f8BAL%2BmNW9bw%3D%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$7.09","priceAmount":7.09,"currencySymbol":"$","integerValue":"7","decimalSeparator":".","fractionalValue":"09","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"3wB0PGC4lh5TRlqVVds4EAGlCnO%2B8pPG3NaNXRy716CJx9FIOGjliI0VkZDndOpvlop%2B59ZBFn6YVnhcSl%2BW75Sd5DvubhIVkNPrTlkoQyh%2B1fpEmuvbyXqn%2BHmLm533b%2Fm0v%2FVbyj%2BF57CAclBujAI7CVYlgU6NerV3X5tGlQs%3D","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

Over the last few years PostgreSQL has emerged as a viable, even preferable, alternative to high-cost enterprise database systems such as Oracle. Large corporations or organizations using PostgreSQL include BASF (the world's leading chemical company), TiVo, USPS, and Verisign. PostgreSQL also won the 2004 Linux Journal Editors Choice Award for DMBS (database management systems). Like Paul DuBois' best-selling MySQL, Korry Douglas' PostgreSQL is the definitive, comprehensive reference on PostgreSQL for both programmers and database administrators. PostgreSQL, Second Edition leads the reader 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. The book is completely updated to cover new features and capabilities of the 8.0 version of PostgreSQL.
Read more
Previous slide of product details
  1. ISBN-10
    0672327562
  2. ISBN-13
    978-0672327568
  3. Edition
    2nd
  4. Publisher
    Sams Publishing
  5. Publication date
    July 26, 2005
  6. Language
    English
  7. Dimensions
    7.1 x 2.15 x 9.05 inches
  8. Print length
    1032 pages
Next slide of product details
Sponsored

Editorial Reviews

From the Back Cover

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.

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.

Product details

  • Publisher ‏ : ‎ Sams Publishing
  • Publication date ‏ : ‎ July 26, 2005
  • Edition ‏ : ‎ 2nd
  • Language ‏ : ‎ English
  • Print length ‏ : ‎ 1032 pages
  • ISBN-10 ‏ : ‎ 0672327562
  • ISBN-13 ‏ : ‎ 978-0672327568
  • Item Weight ‏ : ‎ 3.45 pounds
  • Dimensions ‏ : ‎ 7.1 x 2.15 x 9.05 inches
  • Best Sellers Rank: #3,479,705 in Books (See Top 100 in Books)
  • Customer Reviews:
    4.0 out of 5 stars (21)

About the author

Follow authors to get new release updates, plus improved recommendations.
Korry Douglas

Korry Douglas

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read book recommendations and more.

Sponsored

Customer reviews

4 out of 5 stars
21 global ratings
Sponsored

Top reviews from the United States

  • macro11
    5.0 out of 5 stars Comprehensive introduction to PostgreSQL
    Reviewed in the United States on January 28, 2008
    Format: PaperbackVerified Purchase
    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.
    2 people found this helpful
    Helpful
     Report
  • L. OQUIN
    4.0 out of 5 stars Very Useful, but...
    Reviewed in the United States on March 11, 2010
    Format: PaperbackVerified Purchase
    I've used this book for a couple of years, now, and have found it quite useful. It is quite comprehensive, covering many topics.

    This is not just a reference manual, however. If you are looking for "Just the Facts, Ma'am," You should probably download/print (or buy) the official documentation first. The structure of the book is also somewhat non-traditional. The book is separated into three major sections:

    I - General PostgreSQL Use
    II - Programming With PostgreSQL
    III - PostgreSQL Administration.

    Each of these sections is aimed at a sub-set of the potential readers (albeit, with a large bleed-over between the reader subsets.)

    The first section, an overview of SQL with PostgreSQL specifics, provides basic database and SQL information aimed at the new database user, as well as fairly comprehensive coverage of PostgreSQL specific features and language extensions for the new PostgreSQL (but not database) user. While it does a decent job supporting this dual sub-group, someone who is not database literate at all may find the material challenging, and may want to consider Matthew and Stones' "Beginning Databases with PostgreSQL: From Novice to Professional," first, which, IMO, does a better job as an introductory text. For the experienced database user who may be using PostgreSQL for the first time, Chapter 4 will be of interest, as it discusses PostgreSQL performance - How PostgreSQL executes queries, and what you can do to make them run more efficiently.

    Section Two is aimed squarely at the database developer - It is all about PostgreSQL Programming. This section first describes the programming options available to PostgreSQL developers (of which there are MANY,) how to extend PostgreSQL (if needed) by adding new functions, triggers, data types, and operators. Then, it discusses the various programming languages that can be used within the PostgreSQL server, as well as the data interfaces available for use.

    Finally, the third section discusses PostgreSQL administration, and is geared more towards the DBA.

    The main fault that I have with this book, at present, is that it has become somewhat dated - The second edition was originally released in 2005, and the release I own was printed in 2006. It covers PostgreSQL versions 7.4 and 8.0. While Version 8 was a major PostgreSQL release, the current release, as of March, 2010, is 8.4.2, and versions 8.1 through 8.4 have had several major features added, as well as numerous improvements made, since version 8.0 was released. The book is seriously in need of a new edition, which would include coverage of at least:

    Windowing Functions
    Common Table Expressions and Recursive Queries
    Default and variadic function parameters
    Parallel Restore
    Column Permissions
    Easier-to-use Warm Standby
    Support of SSL certificates for user authentication
    Full text search, as integrated into the core database system
    Support for the SQL/XML standard, including new operators and an XML data type
    Enumerated data types (ENUM)
    Arrays of composite types
    Universally Unique Identifier (UUID) data type
    Updatable cursors
    Two-phase commits
    A new role system (replacing users/groups)

    In spite of this edition beginning to show it's age, it is still an extremely useful addition to the PostgreSQL user's library, and I can recommend it highly.
    3 people found this helpful
    Helpful
     Report
  • Brian Edwards
    5.0 out of 5 stars Excellent book for beginners
    Reviewed in the United States on February 27, 2006
    Format: PaperbackVerified Purchase
    This is a great way to get started with postgreSQL or for learning databases in general. Each sentence actually makes sense and doesn't require referencing other texts like so many other technical books. The book is very thorough so don't let the size intimidate you. I would recommend this book to anyone interested in starting their own database project.
    3 people found this helpful
    Helpful
     Report
  • Juan J. Casero
    4.0 out of 5 stars Good supplement to online docs
    Reviewed in the United States on December 13, 2005
    Format: PaperbackVerified Purchase
    I have the first edition of this book. I purchased it when I started to use PostgreSQL to develop a retail reporting warehouse for our company. After a year of development I can tell you the book is worth the money. While the online manuals are much more extensive and complete they can also be quite terse. This book gives you the needed foundation you can then build upon by referring to the online documentation for PostgreSQL. Nowadays, when I have a question about the database server I always go straight to the online documentation but I also carry this book with me to work. I still find it can sometimes provide a more clear explanation of some part of the server than the online documenation can even if it is not always as in depth as I would like.
    6 people found this helpful
    Helpful
     Report
  • C. Kemp
    2.0 out of 5 stars Not Applicable to Recent Versions of PostgreSQL
    Reviewed in the United States on May 5, 2015
    Format: PaperbackVerified Purchase
    I formerly used PostgreSQL exclusively, The more recent editions of PostgreSQL are not nearly as developer friendly as prior versions. This book is for prior versions and doesn't have much value for the newer versions. I'm now using the database that comes with Java.
    One person found this helpful
    Helpful
     Report
  • Amazon Customer
    5.0 out of 5 stars The details are important!
    Reviewed in the United States on August 9, 2018
    Format: PaperbackVerified Purchase
    I am still trying to figure how to copy data from a CSV file to postgresql, I may give up, the book helped.
    Helpful
     Report
  • Jeffrey Strauss
    4.0 out of 5 stars Excellent resource for any PostgreSQL admin
    Reviewed in the United States on August 12, 2007
    Format: PaperbackVerified Purchase
    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.
    3 people found this helpful
    Helpful
     Report
  • Strontium90
    5.0 out of 5 stars Comprehensive coverage
    Reviewed in the United States on March 10, 2006
    Format: PaperbackVerified Purchase
    This is the only PostgreSQL book that I know of that covers writing functions and triggers in PL/pgSQL with any level of detail. There is also a very detailed section on performace monitoring and tuning. Overall, the best book you can get on PostgreSQL administration.
    4 people found this helpful
    Helpful
     Report

Top reviews from other countries

  • G. Drew
    5.0 out of 5 stars Excellent reading
    Reviewed in the United Kingdom on March 1, 2009
    Format: PaperbackVerified Purchase
    As with other reviewers, I have high praise for this book. It has a very good index that helps finding what you want quickly and the book is well structured so it is easy to jump around to find different topics.

    Also at over 1000 pages it works out at only a few pence per page, so is excellent value for money in my opinion.

    My only caveat about this book is that the typeface is very small. If, like me, you have bad eyesight then you might find yourself reaching for the magnifying glass quite often. But then if the typeface were any larger then I think this book would have to be split into two separate books as it would be so huge.

    Overall I would recommend this book.
    Report
See more reviews