Development Articles

These are articles about developing with PostgreSQL (not on developing PostgreSQL itself).

General Development

• Programming OTL using PostgreSQL and unixODBC in the Solaris environment: a step-by-step guide by Carlos Crosetti (2006-02-13)
• Writing Applications for PostgreSQL by Bruce Momjian
• PostgreSQL & PostGIS operations by Mohammed Thabet
• schemalint by Kristian Dupont - a tool to verify the database schema against Don't Do This recommendations.

Client Libraries

Client Libraries access PostgreSQL from your favorite language

JDBC/J2EE

• Accessing PostgreSQL through JDBC via a Java SSL tunnel by Chianglin Ng

Lua

• Accessing PostgreSQL Databases Using the Lua Scripting Language

Materialized Views

See Materialized Views for more information

• Implementing Materialized Views in PostgreSQL by Jonathan Gardner
• Materialized Views that Really Work by Dan Chak

Microsoft Access and .NET

• Connecting to PostgreSQL from Windows Platforms by Damond Walker
• The npgsql Project - .Net Data Provider for PostgreSQL
• Using Microsoft .NET with the PostgreSQL Database Server via ODBC by Matthew Stanfield (2002-04-15)
• REST in PostgreSQL Part 2 A - The REST Server service with ASP.NET - Postgres OnLine Journal (March 2008)
• Using MS Access with PostgreSQL Postgres OnLine Journal (January/February 2008)
• Crystal Report with PostgreSQL using datasetBy Mohammed Thabet Zaky (August 2009)

PL/pgSQL

• HOWTO: Return more than one row of data from PL/pgSQL functions by Stephan Szabo
• Trojan SQL Function Hack - A PL Lemma in Disguise Postgres OnLine Journal (January/February 2008) - Trick to using set returning functions in non-constant join (e.g. simulate SQL Server 2005 CROSS APPLY)
• Introduction to PL/pgSQL by Pavel Stehule

Python

• Using psycopg2 with PostgreSQL

PL/Python

• Quick Intro to PLPython Postgres OnLine Journal (January 2009)
• PLPython Part 2: Control Flow and Returning Sets Postgres OnLine Journal (February 2009)
• PLPython Part 3: Using custom classes, pulling data from PostgreSQL Postgres OnLine Journal (February 2009)
• PLPython Part 4: PLPython meets aggregates Postgres OnLine Journal (February/March 2009)
• PLPython Part 5: PLPython meets PostgreSQL Multi-column aggregates and SVG plots Postgres OnLine Journal (February/March 2009)

• PL Python Cheatsheet Postgres OnLine Journal (February/March 2009)

PL/R

• PL/R Wiki
• Up and Running with PL/R An Almost Idiot's Guide
• Quick Intro to PL/R and R - 2010-11-28 Postgres OnLine Journal
• PL/R Part 2: Functions that take arguments and the power of aggregation - 2010-12-10 Postgres OnLine Journal
• PL/R Part 3: Sharing Functions across PL/R functions with plr_module - 2010-12-20 Postgres OnLine Journal

Smalltalk

• Squeak Smalltalk client by Jim Menard (2005-2006)

• Installing the PostgreSQL driver and client library from the Store in VisualWorks Smalltalk by Cincom (2006)

Referential Integrity

• Compensating for Unimplemented Features in PostgreSQL 7.1 by John Pagakis and Todd Gauthier (2001-08-21)
• Referential Integrity Tutorial & Hacking the Referential Integrity tables by Joel Burton (2001-09-03)
• Removing Foreign Keys by Dan Langille

Web development

• Setup Rails with PostgreSQL
• Using Macromedia UltraDev with PostgreSQL, Tomcat and Apache by Tony Grant
• Apache 2.0, Tomcat 5.5, WARs & PostgreSQL 8.1 JDBC DataSources on Windows by Chris Drawater (Jan 2006)
• Italian: Appunti di PostgreSQL by Giorgio Ponza - GlugCN (2006-03-14)