On Sun, Aug 17, 2003 at 01:32:11AM +0800, Jared Odulio wrote: > I used the PL/pgSQL for handling business logic. But the disadvantage > is you are locked in to using Postgresql as the only database for your > entire client/server applications. But the advantage is you only have > to maintain a single-tier for all the business logic operations. Yes > it is ideal as a middle-tier especially if you have client > applications written in multiple languages(e.g. C/C++, Java, Python > etc.). They have one common source of business logic to execute. And > it leaves all the processing loads to your server thus unloading your > client apps of unnecessary loads. > > My most complex uses of PL/pgSQL were mainly for transactions. The use > of store functions, triggers etc. are very helpful in stabilizing > enterprise applications.
What documents can you recommend for people wanting to learn more about using PL/pgSQL for stored functions, triggers, and other more advanced usages of PostgreSQL? I'm also having difficulty finding practical documentation on how to use the Object-Relational aspect of PostgreSQL. Links would be highly appreciated. Thank you very much. :) --> Jijo -- Federico Sevilla III : http://jijo.free.net.ph : When we speak of free Network Administrator : The Leather Collection, Inc. : software we refer to GnuPG Key ID : 0x93B746BE : freedom, not price. -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
