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)
Category:General articles and guides