Development Articles
From PostgreSQL Wiki
These are articles about developing with PostgreSQL (not on developing PostgreSQL itself).
Contents |
General Development
- Programming OTL using PostgreSQL and unixODBC in the Solaris environment: a step-by-step guide by Carlos Crosetti (2006-02-13)
- Programming OTL using PostgreSQL and ODBC in the Windows environment: a step-by-step guide by Carlos Croseetti (2006-02-13)
- Writing Applications for PostgreSQL by Bruce Momjian
JDBC/J2EE
- Accessing PostgreSQL through JDBC via a Java SSL tunnel by Chianglin Ng
Materialized Views
- Implementing Materialized Views in PostgreSQL by Jonathan Gardner
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)
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)
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)
