Practical PostgreSQL
By Joshua D. Drake and John C. Worsley
3.5/5
()
Currently unavailable
Currently unavailable
About this ebook
Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system first developed in 1977 by the University of California at Berkeley. In spite of its long history, this robust database suffers from a lack of easy-to-use documentation. Practical PostgreSQL fills that void with a fast-paced guide to installation, configuration, and usage.
This comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features, such as transactions, versioning, replication, and referential integrity that enable developers and DBAs to use PostgreSQL for serious business applications. The thorough introduction to PostgreSQL's PL/pgSQL programming language explains how you can use this very useful but under-documented feature to develop stored procedures and triggers. The book includes a complete command reference, and database administrators will appreciate the chapters on user management, database maintenance, and backup & recovery. With Practical PostgreSQL, you will discover quickly why this open source database is such a great open source alternative to proprietary products from Oracle, IBM, and Microsoft.
Related to Practical PostgreSQL
Related ebooks
Cisco CCNA/CCENT Exam 640-802, 640-822, 640-816 Preparation Kit Rating: 2 out of 5 stars2/5MATLAB Programming for Biomedical Engineers and Scientists Rating: 4 out of 5 stars4/5Microsoft Windows Server 2008 R2 Administrator's Reference: The Administrator's Essential Reference Rating: 5 out of 5 stars5/5MSP430 Microcontroller Basics Rating: 5 out of 5 stars5/5Eleventh Hour Linux+: Exam XK0-003 Study Guide Rating: 4 out of 5 stars4/5CompTIA Linux+ Certification Study Guide (2009 Exam): Exam XK0-003 Rating: 0 out of 5 stars0 ratingsPrinciples of Functional Verification Rating: 0 out of 5 stars0 ratingsImplementing 802.11, 802.16, and 802.20 Wireless Networks: Planning, Troubleshooting, and Operations Rating: 5 out of 5 stars5/5CompTIA Network+ Certification Study Guide: Exam N10-004: Exam N10-004 2E Rating: 4 out of 5 stars4/5Microsoft SQL Server 2005: A Beginner''s Guide Rating: 0 out of 5 stars0 ratingsDigital Media Processing: DSP Algorithms Using C Rating: 0 out of 5 stars0 ratingsMac OSX Developer's Guide Rating: 0 out of 5 stars0 ratingsDatabase Design: Know It All Rating: 5 out of 5 stars5/5Securing Windows Server 2008: Prevent Attacks from Outside and Inside Your Organization Rating: 0 out of 5 stars0 ratingsSingle Sourcing: Building Modular Documentation Rating: 2 out of 5 stars2/5Gray Hat Hacking the Ethical Hacker's Rating: 5 out of 5 stars5/5The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook Rating: 0 out of 5 stars0 ratingsMigrating to the Cloud: Oracle Client/Server Modernization Rating: 0 out of 5 stars0 ratingsOCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 Rating: 0 out of 5 stars0 ratingsProgramming the Intel Galileo: Getting Started with the Arduino -Compatible Development Board Rating: 5 out of 5 stars5/5Microsoft Virtualization: Master Microsoft Server, Desktop, Application, and Presentation Virtualization Rating: 4 out of 5 stars4/5Data Mining Using SAS Enterprise Miner Rating: 0 out of 5 stars0 ratingsFritzing for Inventors: Take Your Electronics Project from Prototype to Product Rating: 0 out of 5 stars0 ratingsEleventh Hour Security+: Exam SY0-201 Study Guide Rating: 0 out of 5 stars0 ratingsCompTIA Security+ Certification Study Guide: Exam SY0-201 3E Rating: 0 out of 5 stars0 ratingsSecurity for Microsoft Windows System Administrators: Introduction to Key Information Security Concepts Rating: 4 out of 5 stars4/5Programming PIC Microcontrollers with PICBASIC Rating: 0 out of 5 stars0 ratingsModeling and Precision Control of Systems with Hysteresis Rating: 0 out of 5 stars0 ratingsIntelligent Sensor Design Using the Microchip dsPIC Rating: 0 out of 5 stars0 ratingsEmbedded Systems: World Class Designs Rating: 5 out of 5 stars5/5
Databases For You
Building a Scalable Data Warehouse with Data Vault 2.0 Rating: 4 out of 5 stars4/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5SQL Clearly Explained Rating: 5 out of 5 stars5/5Python Projects for Everyone Rating: 0 out of 5 stars0 ratingsOracle DBA Mentor: Succeeding as an Oracle Database Administrator Rating: 0 out of 5 stars0 ratingsPractical Data Analysis Rating: 4 out of 5 stars4/5Artificial Intelligence for Fashion: How AI is Revolutionizing the Fashion Industry Rating: 0 out of 5 stars0 ratingsSQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5COBOL Basic Training Using VSAM, IMS and DB2 Rating: 5 out of 5 stars5/5Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies Rating: 0 out of 5 stars0 ratingsQuery Store for SQL Server 2019: Identify and Fix Poorly Performing Queries Rating: 0 out of 5 stars0 ratingsSQL Server: Tips and Tricks - 2 Rating: 4 out of 5 stars4/5Professional Access 2013 Programming Rating: 0 out of 5 stars0 ratingsRelational Database Systems Rating: 0 out of 5 stars0 ratingsLearn SQL in 24 Hours Rating: 5 out of 5 stars5/5Business Intelligence Strategy and Big Data Analytics: A General Management Perspective Rating: 5 out of 5 stars5/5Data Mining: Concepts and Techniques Rating: 4 out of 5 stars4/5Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics Rating: 0 out of 5 stars0 ratingsData Structures Demystified Rating: 5 out of 5 stars5/5Data Science Using Python and R Rating: 0 out of 5 stars0 ratingsText Analytics with Python: A Practitioner's Guide to Natural Language Processing Rating: 0 out of 5 stars0 ratingsBlockchain Basics: A Non-Technical Introduction in 25 Steps Rating: 5 out of 5 stars5/5Serverless Architectures on AWS, Second Edition Rating: 5 out of 5 stars5/5Access 2016 For Dummies Rating: 0 out of 5 stars0 ratingsVisual Basic 2010 Coding Briefs Data Access Rating: 5 out of 5 stars5/5Data Science Strategy For Dummies Rating: 0 out of 5 stars0 ratingsDeveloping High Quality Data Models Rating: 0 out of 5 stars0 ratingsAccess 2010 All-in-One For Dummies Rating: 4 out of 5 stars4/5
Reviews for Practical PostgreSQL
9 ratings0 reviews