Using PostgreSQL with Python | Part II: Programming with PostgreSQL

Python is an object-oriented programming language. Like Perl, Tcl, and Java, Python is an interpreted language (as opposed to being a compiled language such as C or C++). Python supports a number of high-level data structures (lists, tuples, and sequences) that integrate very nicely into the table-oriented world of PostgreSQL.

Part I: General PostgreSQL Use

Introduction to PostgreSQL and SQL

Working with Data in PostgreSQL

PostgreSQL SQL Syntax and Use

Performance

Part II: Programming with PostgreSQL

Introduction to PostgreSQL Programming

Extending PostgreSQL

PL/pgSQL

The PostgreSQL C APIlibpq

A Simpler C APIlibpgeasy

The New PostgreSQL C++ APIlibpqxx

Embedding SQL Commands in C Programsecpg

Using PostgreSQL from an ODBC Client Application

Using PostgreSQL from a Java Client Application

Using PostgreSQL with Perl

Using PostgreSQL with PHP

Using PostgreSQL with Tcl and Tcl/Tk

Using PostgreSQL with Python

Using PostgreSQL with Python
Python/PostgreSQL Interface Architecture
Prerequisites
Client 1Connecting to the Server
Client 2Adding Error Checking
Client 3Query Processing
Client 4An Interactive Command Processor
Summary

Npgsql: The .NET Data Provider

Other Useful Programming Tools

Part III: PostgreSQL Administration

Introduction to PostgreSQL Administration

PostgreSQL Administration

Internationalization and Localization

Security

Replicating PostgreSQL Data with Slony

Contributed Modules

Index