PostgreSQL: Up and Running, 3rd Edition

A Practical Guide to the Advanced Open Source Database



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

Price$30.67 - $40.30
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


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 application platform...

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

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 instructions fo...

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 sound...

Price:  $16.00  |  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

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 building ...

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

Windows 7 Up and Running

Windows 7 Up and Running

by Wei-Meng Lee

This compact book offers the quickest path for Windows XP and Vista users to get started with Microsoft's Windows 7 operating system. With Windows 7: Up and Running, you get the essential information you need to upgrade or install the system and configure it to fit your activities, along with a tour of Windows 7's features and built-in ap...

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

Ubuntu: Up and Running

Ubuntu: Up and Running

by Robin Nixon

Ubuntu for everyone! This popular Linux-based operating system is perfect for people with little technical background. It's simple to install, and easy to use -- with a strong focus on security. Ubuntu: Up and Running shows you the ins and outs of this system with a complete hands-on tour. You'll learn how Ubuntu works, how to quickly con...

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

Node: Up and Running

Node: Up and Running

by Tom Hughes-Croucher, Mike Wilson

This book introduces you to Node, the new web development framework written in JavaScript. You'll learn hands-on how Node makes life easier for experienced JavaScript developers: not only can you work on the front end and back end in the same language, you'll also have more flexibility in choosing how to divide application logic between c...

Price:  $27.81  |  Publisher:  O'Reilly Media  |  Release:  2012