Difference between revisions of "Development Articles"

From PostgreSQL wiki
Jump to: navigation, search
(Split from community articles)
 
(+schemalint)
 
(36 intermediate revisions by 10 users not shown)
Line 1: Line 1:
These are articles about developing with PostgreSQL (not on [[Developer and Contributor Resources|developing PostgreSQL]] itself).
+
These are articles about developing with PostgreSQL (not on [[Development information|developing PostgreSQL]] itself).
  
 
== General Development ==
 
== General Development ==
  
* [http://www.geocities.com/ccrosetti/otl/index.html Programming OTL using PostgreSQL and unixODBC in the Solaris environment: a step-by-step guide] by Carlos Crosetti (2006-02-13)
+
* [http://www.webdotdev.com/nvd/articles-reviews/postgresql/programming-otl-using-postgresql-and-unixodbc-in-the-solaris-environment-348.html Programming OTL using PostgreSQL and unixODBC in the Solaris environment: a step-by-step guide] by Carlos Crosetti (2006-02-13)
* [http://www.geocities.com/ccrosetti/otlw/index.html Programming OTL using PostgreSQL and ODBC in the Windows environment: a step-by-step guide] by Carlos Croseetti (2006-02-13)
 
 
* [http://www.postgresql.org/files/documentation/books/aw_pgsql/writing_apps/ Writing Applications for PostgreSQL] by Bruce Momjian
 
* [http://www.postgresql.org/files/documentation/books/aw_pgsql/writing_apps/ Writing Applications for PostgreSQL] by Bruce Momjian
 +
* [http://www.codeproject.com/KB/database/PostgreSQLTasks.aspx PostgreSQL & PostGIS operations] by Mohammed Thabet
 +
* [https://github.com/kristiandupont/schemalint 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 ==
 
== JDBC/J2EE ==
  
 
* [http://www.linuxfocus.org/English/March2003/article285.shtml Accessing PostgreSQL through JDBC via a Java SSL tunnel] by Chianglin Ng
 
* [http://www.linuxfocus.org/English/March2003/article285.shtml Accessing PostgreSQL through JDBC via a Java SSL tunnel] by Chianglin Ng
 +
 +
== Lua ==
 +
 +
* [[Lua|Accessing PostgreSQL Databases Using the Lua Scripting Language]]
  
 
== Materialized Views ==
 
== Materialized Views ==
 +
See [[Materialized Views]] for more information
  
 
* [http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html Implementing Materialized Views in PostgreSQL] by Jonathan Gardner
 
* [http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html Implementing Materialized Views in PostgreSQL] by Jonathan Gardner
 +
* [http://www.pgcon.org/2008/schedule/events/69.en.html Materialized Views that Really Work] by Dan Chak
  
 
== Microsoft Access and .NET ==
 
== Microsoft Access and .NET ==
Line 22: Line 33:
 
* [http://www.postgresonline.com/journal/index.php?/archives/37-REST-in-PostgreSQL-Part-2-A-The-REST-Server-service-with-ASP.NET.html REST in PostgreSQL Part 2 A - The REST Server service with ASP.NET] - Postgres OnLine Journal (March 2008)
 
* [http://www.postgresonline.com/journal/index.php?/archives/37-REST-in-PostgreSQL-Part-2-A-The-REST-Server-service-with-ASP.NET.html REST in PostgreSQL Part 2 A - The REST Server service with ASP.NET] - Postgres OnLine Journal (March 2008)
 
*[http://www.postgresonline.com/journal/index.php?/archives/24-Using-MS-Access-with-PostgreSQL.html Using MS Access with PostgreSQL]  Postgres OnLine Journal (January/February 2008)
 
*[http://www.postgresonline.com/journal/index.php?/archives/24-Using-MS-Access-with-PostgreSQL.html Using MS Access with PostgreSQL]  Postgres OnLine Journal (January/February 2008)
 +
*[http://www.c-sharpcorner.com/UploadFile/thabet084/CrystalReport_PostgreSQL08252009111048AM/CrystalReport_PostgreSQL.aspx?ArticleID=02d7c2d1-2fb6-4b1f-bc0c-79dfda6cc54c Crystal Report with PostgreSQL using dataset]By Mohammed Thabet Zaky (August 2009)
  
 
== PL/pgSQL ==
 
== PL/pgSQL ==
  
 
* HOWTO: [[Return more than one row of data from PL/pgSQL functions]] by Stephan Szabo
 
* HOWTO: [[Return more than one row of data from PL/pgSQL functions]] by Stephan Szabo
 +
*[http://www.postgresonline.com/journal/index.php?/archives/16-Trojan-SQL-Function-Hack---A-PL-Lemma-in-Disguise.html 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)
 +
* [http://www.postgres.cz/index.php/PL/pgSQL_(en) Introduction to PL/pgSQL] by Pavel Stehule
 +
 +
== Python ==
 +
*[[Using psycopg2 with PostgreSQL]]
 +
 +
== PL/Python ==
 +
*[http://www.postgresonline.com/journal/index.php?/archives/99-Quick-Intro-to-PLPython.html Quick Intro to PLPython]  Postgres OnLine Journal (January 2009)
 +
*[http://www.postgresonline.com/journal/index.php?/archives/100-PLPython-Part-2-Control-Flow-and-Returning-Sets.html PLPython Part 2: Control Flow and Returning Sets]  Postgres OnLine Journal (February 2009)
 +
*[http://www.postgresonline.com/journal/index.php?/archives/101-PLPython-Part-3-Using-custom-classes,-pulling-data-from-PostgreSQL.html PLPython Part 3: Using custom classes, pulling data from PostgreSQL]  Postgres OnLine Journal (February 2009)
 +
*[http://www.postgresonline.com/journal/index.php?/archives/102-PLPython-Part-4-PLPython-meets-aggregates.html PLPython Part 4: PLPython meets aggregates]  Postgres OnLine Journal (February/March 2009)
 +
*[http://www.postgresonline.com/journal/index.php?/archives/107-PLPython-Part-5-PLPython-meets-PostgreSQL-Multi-column-aggregates-and-SVG-plots.html PLPython Part 5: PLPython meets PostgreSQL Multi-column aggregates and SVG plots]  Postgres OnLine Journal (February/March 2009)
 +
 +
*[http://www.postgresonline.com/journal/index.php?/archives/106-PL-Python-Cheatsheet-Overview.html PL Python Cheatsheet]  Postgres OnLine Journal (February/March 2009)
 +
 +
== PL/R ==
 +
*[http://www.joeconway.com/web/guest/pl/r PL/R Wiki]
 +
*[http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01 Up and Running with PL/R An Almost Idiot's Guide]
 +
*[http://www.postgresonline.com/journal/archives/188-plr_part1.html Quick Intro to PL/R and R] - 2010-11-28 Postgres OnLine Journal
 +
*[http://www.postgresonline.com/journal/archives/189-plr_part2.html PL/R Part 2: Functions that take arguments and the power of aggregation] - 2010-12-10 Postgres OnLine Journal
 +
*[http://www.postgresonline.com/journal/archives/190-plr_part3.html PL/R Part 3: Sharing Functions across PL/R functions with plr_module] - 2010-12-20 Postgres OnLine Journal
 +
 +
== Smalltalk ==
 +
 +
* [http://www.io.com/~jimm/projects/squeak_postgresql/ Squeak Smalltalk client by Jim Menard (2005-2006)]
 +
 +
* [http://www.cincomsmalltalk.com/userblogs/jsavidge/blogView?showComments=true&title=Installing+PostgreSQL+to+use+with+VisualWorks+StORE&entry=3319025226 Installing the PostgreSQL driver and client library from the Store in VisualWorks Smalltalk by Cincom (2006)]
  
 
== Referential Integrity ==
 
== Referential Integrity ==
Line 34: Line 73:
  
 
== Web development ==
 
== Web development ==
 
+
* [http://whatcodecraves.com/articles/2008/02/05/setup_rails_with_postgresql/ Setup Rails with PostgreSQL]
 
* [http://www.tgds.net/ultra.html Using Macromedia UltraDev with PostgreSQL, Tomcat and Apache] by Tony Grant
 
* [http://www.tgds.net/ultra.html Using Macromedia UltraDev with PostgreSQL, Tomcat and Apache] by Tony Grant
 
* [http://www.holindis.co.uk/PostgreSQLApacheTomcatWin32_v1.1.pdf Apache 2.0, Tomcat 5.5, WARs & PostgreSQL 8.1 JDBC DataSources on Windows] by Chris Drawater (Jan 2006)
 
* [http://www.holindis.co.uk/PostgreSQLApacheTomcatWin32_v1.1.pdf Apache 2.0, Tomcat 5.5, WARs & PostgreSQL 8.1 JDBC DataSources on Windows] by Chris Drawater (Jan 2006)
 
* Italian: [http://cuneo.linux.it/materiale/index.php?txt=pgsql/index Appunti di PostgreSQL] by Giorgio Ponza - GlugCN (2006-03-14)
 
* Italian: [http://cuneo.linux.it/materiale/index.php?txt=pgsql/index Appunti di PostgreSQL] by Giorgio Ponza - GlugCN (2006-03-14)
 +
 +
[[Category:General articles and guides]]

Latest revision as of 15:19, 17 March 2020

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

General Development

Client Libraries

Client Libraries access PostgreSQL from your favorite language

JDBC/J2EE

Lua

Materialized Views

See Materialized Views for more information

Microsoft Access and .NET

PL/pgSQL

Python

PL/Python

PL/R

Smalltalk

Referential Integrity

Web development