Résumé
This book is a complete tutorial on PostgreSQL features and functions beginning with the basics and building up to the design and construction of databases and integrating them with programming languages for the Web. Here we'll show you how to make the most of this fully programmable databases' powerful features like aggregate, join, transaction, inheritance, embedding your own C routines and more.
This book covers:
- Detailed tutorial in PostgreSQL
- Installing from binaries and source code on UNIX and Windows
- Working with graphical tools
- Various forms of queries, subqueries, aggregate functions and joins
- Transactions, locking, stored procedures and triggers
- Performance monitoring, tuning and server control
- Connecting and executing SQL statements using C (libpq) and Embedded SQL
- Developing applications in PHP, Perl and Java
Table of Contents
- Introduction
- Chapter 1: Introduction to PostgreSQL
- Chapter 2: Relational Database Principles
- Chapter 3: Getting Started with PostgreSQL
- Chapter 4: Accessing Your Data
- Chapter 5: PostgreSQL Graphical Tools
- Chapter 6: Data Interfacing
- Chapter 7: Advanced Data Selection
- Chapter 8: Data Definition and Manipulation
- Chapter 9: Transactions and Locking
- Chapter 10: Stored Procedures and Triggers
- Chapter 11: PostgreSQL Administration
- Chapter 12: Database Design
- Chapter 13: Accessing PostgreSQL From C Using libpq
- Chapter 14: Accessing PostgreSQL From C Using Embedded SQL
- Chapter 15: Accessing PostgreSQL from PHP
- Chapter 16: Accessing PostgreSQL From Perl
- Chapter 17: Accessing PostgreSQL from Java
- Chapter 18: Further Information and Resources
- Appendices
- Appendix A: PostgreSQL Database Limits
- Appendix B: PostgreSQL data types
- Appendix C: PostgreSQL SQL Syntax
- Appendix D: psql Reference
- Appendix E: Database Schema and Tables
- Appendix F: Large Objects Support in PostgreSQL
- Index
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.
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.
Avis des lecteurs
publié le 23/06/2005 Acheteur vérifié
Très Bien
Très Bien.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Wrox Press |
| Auteur(s) | Richard Stones, Neil Matthew |
| Parution | 18/10/2001 |
| Nb. de pages | 570 |
| Format | 18,4 x 22,8 |
| Couverture | Broché |
| Poids | 741g |
| Intérieur | Noir et Blanc |
| EAN13 | 9781861005151 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
