Other Useful Programming Tools

In the last few chapters, we've described some of the more popular programming interfaces and procedural languages that you can use with PostgreSQL. It seems that new PostgreSQL-friendly APIs, tools, and even procedural languages appear almost daily. You can find most of "extras" at the gborg.postgresql.org or pgfoundry.org web sites. In this chapter, we'll give you a short introduction to a few of our favorite development packages. You may not have heard of these packages before, or perhaps you have but haven't had a chance to learn about them. This chapter is by no means exhaustivethere are hundreds of projects hosted at the PostgreSQL incubators.

In this chapter, we'll introduce you to PL/Java, a server-side procedural language that lets you write portable functions and stored procedures in Java. We'll also give you a very short peek at pgcurl, a small collection of functions that you can use to upload and download web documents (using HTTP, FTP, secure HTTP, secure FTP, and so on) from within a PostgreSQL server. Finally, we'll show you a replacement for the psql client that combines the convenience of the bash shell with the power of a PostgreSQL server.

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

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



PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
ISBN: 735712573
EAN: N/A
Year: 2004
Pages: 261

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net