Jared Odulio wrote:
On Sun, 2003-08-17 at 10:51, Orlando Andico wrote:
On 17 Aug 2003, Jared Odulio wrote:
I used the PL/pgSQL for handling business logic. But the disadvantage isUmmm.. How about using Perl DBI to talk to the back-end (and implement the
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
business logic), and expose the business logic to the rest of your
applications using Web Services?
That's too complicated for a simple practical task and it should be language-agnostic. PL/pgSQL is already as good as it is.
one of my current project is migrating PL/pgsql codes to MySQL.
some of you may react as "jerk, stored procedures will only be
supported on MySQL 5.x and later." yes, i know. and i'm only doing
it on UDFs (User-Defined Functions). writing UDFs on MySQL
is such a pain. you have to code it in C/C++. that's why i've
considered using MyPerl, MyPHP, MyLUA ("poor man's"
storedproc on MySQL). but another hassle for this approach
is the recompilation of MySQL on Win32. that's why i'd rather
wait for the MySQL 5.x release.all i can say is that using the plain PL/pgSQL can make your UDFs/Procs easily portable to other db servers (supporting ANSI SQL 9?) without the overhead of scripting engines.
-- 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
