Free Downloads
PostgreSQL: Up And Running: A Practical Introduction To The Advanced Open Source Database

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.With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. 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 restoreApply the psql command-line utility and the pgAdmin graphical administration toolExplore PostgreSQL tables, constraints, and indexesLearn powerful SQL constructs not generally found in other databasesUse several different languages to write database functionsTune your queries to run as fast as your hardware will allowQuery external and variegated data sources with foreign data wrappersLearn how to use built-in replication features to replicate data

Paperback: 234 pages

Publisher: O'Reilly Media; 2 edition (December 28, 2014)

Language: English

ISBN-10: 1449373194

ISBN-13: 978-1449373191

Product Dimensions: 7 x 0.5 x 9.2 inches

Shipping Weight: 11.2 ounces (View shipping rates and policies)

Average Customer Review: 3.7 out of 5 stars  See all reviews (13 customer reviews)

Best Sellers Rank: #127,495 in Books (See Top 100 in Books) #34 in Books > Computers & Technology > Networking & Cloud Computing > Network Administration > Storage & Retrieval #59 in Books > Computers & Technology > Databases & Big Data > SQL #550 in Books > Textbooks > Computer Science > Programming Languages

So, first of all I'm a PostgreSQL user for 7 years and an instructor for 3 years. I feel that PostgreSQL has one of the absolute best online documentation repos of any open source project. Easy to use and find answers.However, in teaching PostgreSQL administration, I find that there are still quite a few individuals who like a comprehensive introduction to a topic. Quite a few of these individuals like that comprehensive introduction to be in book form. This is a good resource for those individuals.WHAT I LIKE:1) The authors are active in using PostgreSQLIt is obvious from the tone in which the book is written. Small things, like knowing that 's Redshift is a fork of a PostgreSQL fork . . . aren't monumental, but give the authors credibility in my mind since I use Postgres in its community, EnterpriseDB, and Redshift flavors.2) Concise, quick tips for administratorsThere is more to PostgreSQL administration than configuration of the pg_hba.conf, postgresql.conf, and pg_ident.conf files. However, a solid understanding of these will help a new PostgreSQL user troubleshoot 80% of the issues they will likely encounter. A good but brief coverage of these files' formats, psql, and interactive/non-interactive administration are the best reasons for a new admin to buy this book.3) Datatype discussion, including new JSON typesThere has been a lot of buzz in the community regarding the newer JSON data types that some feel make PostgreSQL a serious competitor in both the relational DB world as well as the unstructured data (MongoDB, Cassandra, etc) world. This book gives a great overview of all existing datatypes as well as the new ones available in 9.4.

PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database Pro OpenSolaris: A New Open Source OS for Linux Developers and Administrators (Expert's Voice in Open Source) Nessus Network Auditing: Jay Beale Open Source Security Series (Jay Beale's Open Source Security) RUN: What To Know About Running Before You Begin (A Complete Beginners Guide: Learn How To Start Running And Jogging): (Running And Jogging For Beginners, Weight Loss, Exercise, How to Run And Jog) Running Mindfully: How to Meditate While Running for Your Body, Mind and Soul (Tibetan Buddhism, Mindful Running) Running: Distance Running: Improve Your Long Distance Running Step By Step Surgery Open Heart: A Surgical Nurse Guides You Through Open Heart Surgery (Open Heart Surgery, Aortic Valve / Mitral Valve Replacement, Coronary Artery Bypass, Aortic Aneurysm, Myxoma) Intellectual Property and Open Source: A Practical Guide to Protecting Code Embedded Linux Primer: A Practical Real-World Approach (Prentice Hall Open Source Software Development Series) Polyamory: The Practical Dater's Guide to the Pursuit and Maintenance of Open Relationships **FREE BONUS BOOK** (Polyamory, Polyamorous, Relationship, ... Polyamory Dating, Open Relationships) Librarian's Guide to Online Searching: Cultivating Database Skills for Research and Instruction, 4th Edition: Cultivating Database Skills for Research and Instruction Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design DB2/400: The New AS/400 Database: The Unabridged Guide to the New IBM Database Management System Database Design Using Entity-Relationship Diagrams, Second Edition (Foundations of Database Design) Applied Cryptography: Protocols, Algorithms, and Source Code in C [ APPLIED CRYPTOGRAPHY: PROTOCOLS, ALGORITHMS, AND SOURCE CODE IN C BY Schneier, Bruce ( Author ) Nov-01-1995 Strunk's Source Readings in Music History: The Early Christian Period and the Latin Middle Ages (Revised Edition) (Vol. 2) (Source Readings Vol. 2) Running: The Ultimate Guide To Running For Weight Loss, Health And Fitness - Includes Easy To Follow Training Plans For Beginners (How to Run, Jogging, Marathon Training) Running for Health and Happiness: The Beginner's Guide to Faster, Pain-Free Running RUNNING: STRETCHING: Pre and Post Running Stretching Exercises (Flexibility, Warm Ups, Cool Downs, Fitness, Strength) Running: Lose Weight, Burn Fat & Increase Metabolism: Weight Loss Motivation (Running, Walking, Burn Fat, Marathons, Marathon Training, Weight Loss Motivation)