Beginning Databases with PostgreSQL

From Novice to Professional

Neil Matthew, Richard Stones - Collection The Expert's Voice in Open Source

640 pages, parution le 12/05/2005

Ajouter à une liste

Indisponible

Résumé

PostgreSQL is one of the world's most popular open source relational database systems. It is renowned for its wide range of capabilities and its ability to perform functions not available in other databases. This book will provide you with the tools to transition into PostgreSQL for the first time, and it will introduce you to the product's most prominent features.

You will learn simultaneously about key relational database design and management principles-all to help you effectively manage your data-driven application. Also included is extensive coverage of the most popular PostgreSQL APIs, including PHP, Perl, Java, and C. You will benefit from the generous reference material covering PostgreSQL data types, syntax, the psql client, and large object support.

L'auteur - Neil Matthew

Neil Matthew - Neil Matthew graduated with a degree in mathematics from the University of Nottingham in the UK and has been using and programming computers for over 30 years. Neil has used just about every flavor of UNIX since 1978, right up to today's Linux distributions. He has co-authored several computing books with Richard Stones, including Beginning Linux Programming, Professional Linux Programming, and Beginning Databases with MySQL.

L'auteur - Richard Stones

Richard Stones - Richard Stones graduated from university with an electrical engineering degree, but decided software was more fun. He has programmed in a variety of languages, but only admits to knowing VB under duress. He has worked for a number of companies, from the very small to the very large, in a variety of areas, from real-time embedded systems upward. He is currently employed by Celesio AG as a systems architect, working principally on systems for the retail side of the business. He has co-authored several computing books with Neil Matthew, including Beginning Linux Programming, Professional Linux Programming, and Beginning Databases with MySQL.

Sommaire

Introduction to PostgreSQL
Relational Database Principles
Getting Started with PostgreSQL
Accessing Your Data
PostgreSQL Command-Line and Graphical Tools
Data Interfacing
Advanced Data Selection
Data Definition and Manipulation
Transactions and Locking
Functions, Stored Procedures, and Triggers
PostgreSQL Administration
Database Design
Accessing PostgreSQL from C Using libpq
Accessing PostgreSQL from C Using Embedded SQL
Accessing PostgreSQL from PHP
Accessing PostgreSQL from Perl
Accessing PostgreSQL from Java
Accessing PostgreSQL from C#

A PostgreSQL Database Limits
B PostgreSQL Data Types
C PostgreSQL SQL Syntax Reference
D psql Reference
E Database Schema and Tables
F Large Objects Support in PostgreSQL

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Apress
Auteur(s)	Neil Matthew, Richard Stones
Collection	The Expert's Voice in Open Source
Parution	12/05/2005
Nb. de pages	640
Format	18 x 23
Couverture	Broché
Poids	1035g
Intérieur	Noir et Blanc
EAN13	9781590594780
ISBN13	978-1-59059-478-0