PostgreSQL: Up and Running, 3rd Edition

A Practical Guide to the Advanced Open Source Database



Bookstore > Books > PostgreSQL: Up and Running, 3rd Edition

Price$25.95 - $44.99
Rating
AuthorsRegina Obe, Leo Hsu
PublisherO'Reilly Media
Published2017
Pages314
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101491963417
ISBN-139781491963418
EBook Hardcover Paperback

Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you'll also discover that PostgeSQL is more than a database system - it's an impressive application platform as well.

With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e.

If you're a current PostgreSQL user, you'll pick up gems you may have missed before.

Learn basic administration tasks such as role management, database creation, backup, and restore; Apply the psql command-line utility and the pgAdmin graphical administration tool; Explore PostgreSQL tables, constraints, and indexes; Learn powerful SQL constructs not generally found in other databases; Use several different languages to write database functions; Tune your queries to run as fast as your hardware will allow; Query external and variegated data sources with foreign data wrappers; Learn how to use built-in replication to replicate data.


  1. (2 books)
  2. (2 books)



4 5 111

Similar Books


Ansible: Up and Running, 3rd Edition

Ansible: Up and Running, 3rd Edition

by Bas Meijer, Lorin Hochstein, Rene Moser

Among the many configuration management tools available, Ansible has some distinct advantages: It's minimal in nature. You don't need to install agents on your nodes. And there's an easy learning curve. With this updated third edition, you'll quickly learn how to be productive with Ansible whether you're a develop...

Price:  $40.00  |  Publisher:  O'Reilly Media  |  Release:  2022

PostgreSQL: Up and Running, 2nd Edition

PostgreSQL: Up and Running, 2nd Edition

by Regina O. Obe, Leo S. Hsu

Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.2, 9.3, and 9.4, you'll also discover that PostgeSQL is more than a database system - it's also an impressive applicatio...

Price:  $25.95  |  Publisher:  O'Reilly Media  |  Release:  2014

Kubernetes: Up and Running, 3rd Edition

Kubernetes: Up and Running, 3rd Edition

by Brendan Burns, Joe Beda, Kelsey Hightower, Lachlan Evenson

In just five years, Kubernetes has radically changed the way developers and ops personnel build, deploy, and maintain applications in the cloud. With this book's updated third edition, you'll learn how this popular container orchestrator can help your company achieve new levels of velocity, agility, reliability, and efficiency-w...

Price:  $52.95  |  Publisher:  O'Reilly Media  |  Release:  2022

Java Web Services: Up and Running

Java Web Services: Up and Running

by Martin Kalin

This example-driven book offers a thorough introduction to Java's APIs for XML Web Services (JAX-WS) and RESTful Web Services (JAX-RS).Java Web Services: Up and Running takes a clear, pragmatic approach to these technologies by providing a mix of architectural overview, complete working code examples, and short yet precise instructio...

Price:  $3.81  |  Publisher:  O'Reilly Media  |  Release:  2009

Cocoa and Objective-C: Up and Running

Cocoa and Objective-C: Up and Running

by Scott Stevenson

Build solid applications for Mac OS X, iPhone, and iPod Touch, regardless of whether you have basic programming skills or years of programming experience. Cocoa and Objective-C: Up and Running shows you how to use Apple's Cocoa framework and its Objective-C language through step-by-step tutorials, hands-on tasks, clear examples, and ...

Price:  $12.46  |  Publisher:  O'Reilly Media  |  Release:  2010

Up and Running with Joomla, 2nd Edition

Up and Running with Joomla, 2nd Edition

by R. Allen Wyke, Skip Matheny

Need to launch a feature-rich website quickly where you have one or more people authoring the content? Want to use a powerful, robust, and scalable Content Management System (CMS) you can trust? This Short Cut will get you up and running with Joomla 1.5, a freely available open source CMS. Learn how to install, configure, customize, and e...

Price:  $9.99  |  Publisher:  O'Reilly Media  |  Release:  2009

Introduction to Game Design, Prototyping, and Development, 3rd Edition

Introduction to Game Design, Prototyping, and Development, 3rd Edition

by Jeremy Gibson Bond

A hands-on book that explains concepts "by doing," Introduction to Game Design, Prototyping, and Development, 3rd Edition, takes readers through the process of making both paper and digital game prototypes. Rather than focusing on a single tutorial, as most Unity books have done, this book explores several small prototypes, rein...

Price:  $79.99  |  Publisher:  Addison-Wesley  |  Release:  2022

Twitter API: Up and Running

Twitter API: Up and Running

by Kevin Makice

This groundbreaking book provides you with the skills and resources you need to build web applications for Twitter. Perfect for new and casual programmers intrigued by the microblogging, Twitter API: Up and Running carefully explains how each part of Twitter's API works, with detailed examples that show you how to assemble those buil...

Price:  $25.68  |  Publisher:  O'Reilly Media  |  Release:  2009