PostgreSQL Developer's HandbookSams Publishing, 2002 - Всего страниц: 753 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. |
Содержание
Introduction | 1 |
PostgreSQL | 5 |
About PostgreSQL | 7 |
Preparing | 15 |
An Introduction to SQL | 39 |
Understanding Transactions | 121 |
PLPGSQL | 131 |
Database Administration | 151 |
TcLTK | 420 |
ODBC | 438 |
Open Source Software | 441 |
Practical PostgreSQL Solutions | 469 |
Importing Data and Working with Binary Data | 471 |
Generating Multidimensional Results | 495 |
Classification of DataReal World Examples | 507 |
Generating Flash with PostgreSQL and PHP | 541 |
Backup and Recovery | 193 |
Performance Tuning | 211 |
Programming Interfaces | 243 |
Embedded SQL C Preprocessor ECPG | 296 |
Perl | 314 |
The DBI Interface and DBD for PostgreSQL | 327 |
DBI Proxies | 346 |
Java | 372 |
Python | 403 |
PostgreSQL Regressions Tests | 569 |
Extending PostgreSQLs Core Features | 579 |
Date Calculations | 607 |
Persistent Database Connections with PHP | 657 |
Using PostgreSQL and Microsoft Software over the Network | 669 |
Using PostgreSQL with Microsoft Office | 677 |
Drawing Graphs on UNIX Systems Using gnuplot and PostgreSQL | 691 |
713 | |