Re: PG rules! (RULES being the word ;->) - Mailing list pgsql-general

From Dr. Evil
Subject Re: PG rules! (RULES being the word ;->)
Date
Msg-id 20010718183310.16256.qmail@sidereal.kz
Whole thread Raw
In response to Re: Re: PG rules! (RULES being the word ;->)  (Janning Vygen <vygen@planwerk6.de>)
List pgsql-general
> this way i have to implement my businees logic twice. inside the
> database and in the middleware. I dont think that this is very good.

Sometimes implenting the business logic twice is the right thing to
do.  For instance, let's say we have a financial application, and we
need to calculate account balances (let's say it's non-trivial to do
this).  It seems like it would be good to have the middleware
calculate it, and have PG calculate it.  That way, if there is a bug
somewhere in the routine that does the calculation, it will be caught.

It all depends on what you're doing.

pgsql-general by date:

Previous
From: Pete Leonard
Date:
Subject: Re: sick DB - ??
Next
From: Stephan Szabo
Date:
Subject: Re: [SQL] What is the syntax turn off auto commit?