---

PostgreSQL Developer's Handbook2001

ISBN: N/A
EAN: N/A

Year: 2004
Pages: 125

BUY ON AMAZON

• Main Page
• Table of content
• Copyright
• About the Authors
• Ewald Geschwinde
• Hans-Jurgen Schonig
• Acknowledgments
• Tell Us What You Think
• Introduction
• Part I: PostgreSQL
• Chapter 1. About PostgreSQL
• License
• The Basic Concepts of PostgreSQL
• Chapter 2. Preparing
• Hardware Requirements
• Software Requirements
• Installing PostgreSQL
• Starting the Server and Creating Databases
• The User Interface
• Chapter 3. An Introduction to SQL
• Relational Databases and Their Components
• Building a Database
• Inserting Data
• Retrieving Data
• Updating and Deleting Data
• Writing Advanced SQL Code
• Building Complex Data Structures and Modeling Techniques
• Chapter 4. Understanding Transactions
• How the Transaction Code Affects Daily Work
• Chapter 5. PLPGSQL
• Why Use PLpgSQL?
• Enabling a Database with PLpgSQL
• The Structure of PLpgSQL
• Writing Functions
• Using Functions in PLpgSQL
• Writing Triggers
• Oracle s PLSQL and PLpgSQLComparing Two Worlds
• Chapter 6. Database Administration
• How to Configure PostgreSQL
• Adding Users and Managing User Rights
• Modifying Databases
• System Tables
• Security and Access Restrictions
• Summary
• Chapter 7. Backup and Recovery
• Common Errors
• Backup Strategies and Tools for PostgreSQL
• Summary
• Chapter 8. Performance Tuning
• Measuring Performance
• Indexes and Performance
• Using EXPLAIN and Understanding the Optimizer
• Tuning SQL
• System Performance
• Working with Large Amounts of Data
• Regular Expressions and Performance
• Summary
• Chapter 9. Programming Interfaces
• CC
• Embedded SQL C Preprocessor (ECPG)
• Perl
• PHP
• Java
• Python
• TcLTK
• ODBC
• Chapter 10. Extended PostgreSQLSoftware for PostgreSQL
• Contributed Software
• Administration Tools
• Part II: Practical PostgreSQL Solutions
• Chapter 11. Importing Data and Working with Binary Data
• Importing ASCII and Binary Data Using COPY
• Working with ASCII and EBCDIC
• Summary
• Chapter 12. Generating Multidimensional Results
• Generating Multidimensional Results on the Database Level
• Creating Multidimensional Arrays on the Application Level
• Summary
• Chapter 13. Classification of DataReal-World Examples
• Working with SQL
• EFEUThe Perfect Tool for Data Warehousing
• Summary
• Chapter 14. Generating Flash with PostgreSQL and PHP
• PHP s Flash Interfaces
• Simple Flash Examples
• Adding Data to Flash
• Working with Geometric Datatypes
• Using Action Script for Interactive Applications
• A Final Example
• Summary
• Chapter 15. PostgreSQL Regression Tests
• The Idea Behind Regression Tests
• Running Tests
• Evaluating Regression Tests
• Summary
• Chapter 16. Extending PostgreSQL s Core Features
• Adding Functions and an Overview of Programming Conventions
• Adding Datatypes
• Adding Operators
• Adding Aggregates
• Changing PostgreSQL s Rule System
• Summary
• Chapter 17. Date Calculations
• SQL and Dates
• Using PerlThe DateCalc Module
• Analyzing a Time Series
• Summary
• Chapter 18. Persistent Database Connections with PHP
• Speed Tests
• Dangerous Side Effects
• Testing Persistent Connections
• Summary
• Chapter 19. Using PostgreSQL and Microsoft Software over the Network
• Connecting to MS Office
• Using Visual Basic to Connect to PostgreSQL
• Using PostgreSQL with Microsoft Office
• Summary
• Chapter 20. Drawing Graphs on Unix Systems Using gnuplot and PostgreSQL
• About gnuplot
• Using PostgreSQL and gnuplot
• A Simple LaTex Document
• Geometric Datatypes and gnuplotA Simple Example
• Summary