PostgreSQL

Thie tutorials offer readers a thorough overview of database basics, starting with an explanation of why you might need to use a PostgreSQL database, and following with a summary of what different database types have to offer when compared to alternatives like spreadsheets. You'll also learn all about relational database design topics such as the SQL query language, and introduce core principles including normalization and referential integrity.

This book is the definitive guide to undocumented and partially-documented features of the PostgreSQL server. It helps you learn to apply the right solution at the right time, about avoiding risk, about making robust choices related to PostgreSQL databases. It is packed with of experience over decades deep to lay out real-world techniques.

This book is about POSTGRESQL, the most advanced open source database. From its origins in academia, POSTGRESQL has moved to the Internet with explosive growth. It is hard to believe the advances during the past four years under the guidance of a team of worldwide Internet developers. This book is a testament to their vision, and to the success that POSTGRESQL has become.

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.

The purpose of this book is an introduction to the PostgreSQL specific aspects: its architecture, installing procedure, maintenance and optimization tasks. Thus it is primarily aimed to database administrators. But it is only a starting point in these objectives and many topics are omitted. For a complete treatment we recommend to get through professional training courses offered by many consulting companies.

Although the number of database systems on the market is constantly climbing, the Postgres database continues to be an under-championed, reliable option for many scenarios. Its open-source nature, cross-platform flexibility, and wide selection of additional tools are just some of the strengths that make this system a go-to for any data management need, enterprise or otherwise.

In this book, the internals of PostgreSQL for database administrators and system developers are described. The main purposes of this book are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.

This book is for those who will not settle for a black-box approach when working with a database. Briefly touching upon the main concepts of PostgreSQL, the book then plunges into the depths of data consistency and isolation, explaining implementation details of multiversion concurrency control and snapshot isolation, buffer cache and write-ahead log, and the locking system.

This book will help you build efficient and fault-tolerant PostgreSQL applications. You'll thoroughly examine the advanced features of PostgreSQL, including logical replication, database clusters, performance tuning, monitoring, and user management.

This short pamphlet provides an overview of PostgreSQL DBMS, covering the history of its development, the main features, and a product roadmap. If you are just getting started, you can use this book as a step-by-step installation and configuration guide.

The aim of this book is to help you master the functionalities offered by PostGIS, from data creation, analysis and output, to ETL and live edits - a comprehensive guide covering all the concepts you need to master PostGIS.

This manual is part of the official reference documentation for PostgreSQL 9.0. It describes all the SQL commands available in PostgreSQL.

This manual is part of the official reference documentation for PostgreSQL 9.0. It describes the SQL language specification as implemented by PostgreSQL, including syntax, data types, functions and operators, indexes and transactions.