PostgreSQL Developer's Handbook
Published on 4. January 2002
Book
Paperback/Softback
768 pages
978-0-672-32260-0 (ISBN)
Description
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.
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.
More details
Language
English
Place of publication
Indianapolis
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 186 mm
Width: 231 mm
Thickness: 43 mm
Weight
1216 gr
ISBN-13
978-0-672-32260-0 (9780672322600)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
Ewald Geschwinde and Hans-Juergen Schoenig are partners in Cybertec Geschwinde & Schoenig OEG (www.cybertec.at), a company based in Vienna, Austria that provides commercial PostgreSQL support, training, tuning, and remote administration to international clients. They also offer training through the first PostgreSQL Academy. Their accomplishments include the creation of a popular Webshop using PostgreSQL and the implementation of a massive scientific database containing data on millions of Austrian social insurance recipients.
Before founding Cybertec, both Geschwinde and Schoenig worked at Synthesis, an Austrian research company focusing on forecasting the Austrian labor market. While there, the worked with Unix systems and automated text production using EFEU, LaTex, and Perl.
Before founding Cybertec, both Geschwinde and Schoenig worked at Synthesis, an Austrian research company focusing on forecasting the Austrian labor market. While there, the worked with Unix systems and automated text production using EFEU, LaTex, and Perl.
Content
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.
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.