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.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 186 mm
Breite: 231 mm
Dicke: 43 mm
Gewicht
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 Klassifikation
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.
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.
