PostgreSQL

Korry Douglas, Susan Douglas

806 pages, parution le 07/03/2003

Ajouter à une liste

Indisponible

Résumé

PostgreSQL is a comprehensive, in-depth, and easy-to-read guide to the award-winning, enterprise-level open source database. Written for users, developers, and administrators, the book begins with a thorough overview of SQL*, and then delves into a description of all PostgreSQL data types and a complete explanation of PostgreSQL commands.

The first section of PostgreSQL includes a complete description of the PostgreSQL API for the most popular programming languages. Easy-to-follow exercises illustrate the development of working applications that fully demonstrate the features offered by each API. The book also offers a chapter describing the PL/pgSQL server-side procedural language, teaching the developer how to build triggers, functions, and stored procedures.

The second section of PostgreSQL was written for the PostgreSQL administrator. It describes how to install PostgreSQL on Windows, Linux, and Unix systems from source code or from precompiled installers. The authors have described all the PostgreSQL configuration options (compile-time, startup, and on-the-fly). The chapter on PostgreSQL security describes all the authentication protocols that the administrator can choose from and describes how to secure a database, both internally and externally.

Contents

I General PostgreSQL Use

Introduction to PostgreSQL and SQL
Working with Data in PostgreSQL
PostgreSQL SQL Syntax and Use
Performance

II Programming with PostgreSQL

Introduction to PostgreSQL Programming
Extending PostgreSQL
PL/pgSQL
The PostgreSQL C API-libpq
A Simpler C API-hbpgeasy
The PostgreSQL C++ API-libpq++
Embedding SQL Commands in
C Programs-ecpg
Using PostgreSQL from an ODBC
Client Application
Using PostgreSQL from a Java
Client Application
Using PostgreSQL with Perl
Using PostgreSQL with PHP
Using PostgreSQL with Tcl and Tcl/Tk
Using PostgreSQL with Python

III PostgreSQL Administration

Introduction to PostgreSQL Administration
PostgreSQL Administration
Internationalization and Localization Security

L'auteur - Korry Douglas

Korry Douglas is the Director of Research and Development for Appx Software. Over the last two decades, he has worked on the design and implementation of a number of high-level languages and development environments. His products interface with many relational (and non-relational) databases. Working with many different database products (Oracle, Sybase, SQL Server, PostgreSQL, MySQL, MSQL) has given him a unique understanding of the commonalities of and differences between databases.

L'auteur - Susan Douglas

Susan Douglas is the CEO of Conjectrix, Inc., a software consulting firm specializing in database- and security-related issues. When she's not busy at the computer, Susan is probably throwing pottery, glassblowing, or horseback riding.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Developer's Library
Auteur(s)	Korry Douglas, Susan Douglas
Parution	07/03/2003
Nb. de pages	806
Format	17,7 x 23
Couverture	Broché
Poids	1244g
Intérieur	Noir et Blanc
EAN13	9780735712577