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. On Sun, 2003-08-17 at 00:34, Winelfred G. Pasamba wrote: > Jared Odulio said: > > what in particular about PL/pgSQL? I have used PL/pgSQL for my stored > > functions (do not mistake this for stored procedures, Oracle/MS SQL > > users please). And I can execute my stored functions just like how I > > execute built-in functions in SQL like AVG(), ABS(), SUBSTRING() etc. > > i'm thinking of using it as a middle-tier in a school system so we can > implement different user interfaces technologies without rewriting the > application logic. > > for example, we currently have enrollment application logic in C/C++ and > we need to reimplement that on PHP if we want Web Registration. And if we > do that then i have to maintain two things for 1 function. > > what was your most complex use of PL/pgSQL? > -- > 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
signature.asc
Description: This is a digitally signed message part
-- 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
