Joshua D. Drake and John C. Worsley - Practical PostgreSQL
Here you can read online Joshua D. Drake and John C. Worsley - Practical PostgreSQL full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2011, publisher: OReilly Media, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:Practical PostgreSQL
- Author:
- Publisher:OReilly Media
- Genre:
- Year:2011
- Rating:4 / 5
- Favourites:Add to favourites
- Your mark:
Practical PostgreSQL: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "Practical PostgreSQL" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
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 PostgreSQLs 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...
Joshua D. Drake and John C. Worsley: author's other books
Who wrote Practical PostgreSQL? Find out the surname, the name of the author of the book and a list of all author's works by series.
Practical PostgreSQL — read online for free the complete book (whole text) full work
Below is the text of the book, divided by pages. System saving the place of the last page read, allows you to conveniently read the book "Practical PostgreSQL" online for free, without having to search again every time where you left off. Put a bookmark, and you can go to the page where you finished reading at any time.
Font size:
Interval:
Bookmark:
Beijing Cambridge Farnham Kln Sebastopol Tokyo
Supplemental files and examples for this book can be found at http://examples.oreilly.com/9781565928466/. Please use a standard desktop web browser to access these files, as they may not be accessible from all ereader devices.
All code files or examples referenced in the book will be available online. For physical books that ship with an accompanying disc, whenever possible, weve posted all CD/DVD content. Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to .
PostgreSQL is one of the most successful open source databases available. It is arguably also the most advanced, with a wide range of features that challenge even many closed-source databases.
This book is intended to be a practical guide to PostgreSQL v7.1.x, though most of the book should also apply to earlier and future releases of PostgreSQL. The content is focused on getting you comfortable with PostgreSQL in the most expedient fashion possible. Although we will touch on some academic database subjects, such discussion will be kept brief. Our core focus is to provide the reader with enough of an understanding of PostgreSQL to manage a fully operational PostgreSQL database. Our hope is that by introducing this book to the community we will provide a better understanding of PostgreSQL and its functionality.
This book is for anyone interested in utilizing the PostgreSQL object-relational database-management system (ORDBMS). The reader should be familiar with Linux- and Unix-based systems, but is not expected to be a database guru. Although the test operating system for this book is Red Hat Linux, the tasks in this book that apply to Linux should apply to most Unix variants without much modification.
This book is divided into four parts, each focused on a different aspect of a PostgreSQL database system. It also includes a complete command reference, and a small set of technical appendixes.
, is a general overview of PostgreSQL. It documents what it is, where you can obtain it, and how to install it on your system. It also covers a wide variety of compilation options which allow you to customize PostgreSQL to your needs.
, delves deeper into the use of SQL, covering how to perform essential database functions such as creating and altering tables, inserting rows into tables, copying data, retrieving result sets, and using views.
, which details the more advanced PostgreSQL features such as indices, inheritance, arrays, constraints, triggers, sequences and cursors. This chapter also documents PostgreSQLs advanced extensibility with user-defined operators and functions.
documents how to add and remove user accounts and groups, and manage database privileges.
wraps up the part by documenting the installation, configuration and use of the LXP PostgreSQL application server for the Apache HTTP server.
Finally, contains a comprehensive command reference guide, which documents each of the standard and extended SQL commands supported by PostgreSQL.
At the time of this books writing, version 7.1.3 is the most current release of PostgreSQL. This is the version used in all examples, and for the construction of our example database, booktown. All examples should be compatible with any of the PostgreSQL 7.1 versions, which is the reason you will see the version referred to as 7.1.x within our text.
The CD included with this book contains the complete source for PostgreSQL 7.1.3. The CD also includes the PostgreSQL application server LXP. The following is a listing of what is on the CD, including a short description of each package:
The community version of PostgreSQL in compressed source form. This is the most actively developed PostgreSQL distribution. We do not provide binaries of PostgreSQL, as you may want to compile different features.
The source is available as a single compressed file ( postgresql-7.1.3.tar.gz ). Its contents are not extracted on the CD, as you must copy and extract the files onto your hard drive before installing PostgreSQL.
lxp-eval-0.8.0.tgzAn evaluation/developer-use copy of the LXP PostgreSQL application server for Apache 1.3.x. LXP is a good tool for integrating PostgreSQL (and other technologies) with the web. This package is a binary distribution intended for x86-based systems. It must be copied to your hard drive before it can be extracted.
lxp/A directory containing the extracted contents of the lxp-eval-0.8.0.tgz file. LXP can be installed directly from the lxp directory on the CD. See for information on installing LXP.
booktown.sqlThe PostgreSQL dump of the example booktown database used throughout this book. This file contains both commands to re-create the database schema, as well as some sample data.
To install this database after you have installed PostgreSQL, type from the command line psql -U postgres template1 -f /mnt/cdrom/booktown.sql (where /mnt/cdrom is the path to your mounted CD, and postgres is your PostgreSQL superuser).
Used for filenames, directory names, string-bound constants, and URLs. It is also used for emphasis, and for the first use of a technical term.
Constant widthUsed for keywords, identifiers (such as tables and columns), data types, examples, and to show the contents of files, and the output of commands.
Constant width italicUsed in syntax descriptions to indicated user-defined items.
Constant width boldIndicates user input within examples.
UPPERCASEUsed within syntax descriptions, uppercase usually indicates keywords.
lowercaseUsed within syntax descriptions, lowercase usually indicates user-defined items, such as variables and identifiers.
[ ]Used within syntax descriptions, square brackets enclose optional items, which are separated from one another by pipes (|).
{ }Used within syntax descriptions, curly brackets enclose a set of items from which you must choose one.
...Used within syntax descriptions, ellipses indicate repeating information. Used within examples, ellipses indicate that a section of unimportant information was removed from the example output to improve readability and conserve space.
The owl icon indicates a tip, suggestion, or general note. For example, well let you know that PostgreSQL supports the use of all ISO standard time zone abbreviations in the section on time zones.
The turkey icon indicates a warning or caution. For example, well warn you ahead of time that using the
Font size:
Interval:
Bookmark:
Similar books «Practical PostgreSQL»
Look at similar books to Practical PostgreSQL. We have selected literature similar in name and meaning in the hope of providing readers with more options to find new, interesting, not yet read works.
Discussion, reviews of the book Practical PostgreSQL and just readers' own opinions. Leave your comments, write what you think about the work, its meaning or the main characters. Specify what exactly you liked and what you didn't like, and why you think so.