About the Book
PostgreSQL is an object-relational
database server that is widely considered to be the world¿s most
advanced open-source database system. It is ANSI SQL-compatible, and it
offers powerful features to enable more complex software design than would
be possible with relational databases that are not object-oriented. PostgreSQL
is extremely modular, it supports a large number of datatypes, and programming
interfaces for PostgreSQL are available for all important programming languages,
including C, Perl, Python, Tcl, Java, and PHP.
PostgreSQL Developer¿s Handbook
provides a complete overview of the PostgreSQL database server and extensive
coverage of its core features, including object orientation, PL/pgSQL,
and the most important programming interfaces. The book introduces the
reader to the language and syntax of PostgreSQL and then moves quickly
into advanced programming topics.
Related Books
Developer's Library Books (Developer's
Library Books)
Table of Contents
Introduction.
I. Postgresql.
1. About PostgreSQL.
2. Preparing.
3. An Introduction to SQL.
4. PL/PGSQL.
5. Understanding Transactions.
6. Database Administration.
7. Backup and Recovery.
8. Performance Tuning.
9. Programming Interfaces.
10. Open Source Software.
II. PRACTICAL POSTGRESQL SOLUTIONS.
11. Importing Data and Working with
Binary Data.
12. Generating Multi-dimensional Results.
13. Classification of Data-Real World
Examples.
14. Generating Flash with PostgreSQL
and PHP.
15. PostgreSQL Regressions Tests.
16. Extending PostgreSQL's Core Features.
17. Date Calculations.
18. Persistent Database Connections
with PHP.
19. Using PostgreSQL and Microsoft
Software over the Network.
20. Drawing Graphs on UNIX Systems
Using gnuplot and PostgreSQL.
Index. |
