MIME-Version: 1.0
From: sud <suds1434@gmail.com>
Date: Tue, 30 Jul 2024 20:46:32 +0530
Message-ID: <CAD=mzVU0rx4A0onfC4jHxZ7XreZrk9DNa9pFoGDOjPD1ZhfHgw@mail.gmail.com>
Subject: Trigger usecase
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001aa887061e7877c6"
Archived-At: <https://www.postgresql.org/message-id/CAD%3DmzVU0rx4A0onfC4jHxZ7XreZrk9DNa9pFoGDOjPD1ZhfHgw%40mail.gmail.com>
Precedence: bulk

--0000000000001aa887061e7877c6
Content-Type: text/plain; charset="UTF-8"

Hello,

We have a streaming application (using apache flink and kafka) which
populates data in the tables of a postgres database version 15.4.

Now while loading transactions data we also get some reference data
information from source (for example customer information) and for these ,
we dont want to modify or override the existing customer data but want to
keep the old data with a flag as inactive and the new record should get
inserted with flag as active. So for such use case , should we cater this
inside the apache flink application code or should we handle this using
trigger on the table level which will execute on each INSERT and execute
this logic?

I understand trigger is difficult to debug and monitor stuff. But here in
this case , team mates is saying , we shouldn't put such code logic into a
streaming application code so should rather handle through trigger.

I understand, technically its possible bith the way, but want to understand
experts opinion on this and pros ans cons?

Regards
Sud

--0000000000001aa887061e7877c6
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><div dir=3D"auto">Hello,=C2=A0<br></div><div dir=3D"auto"=
><br></div><div dir=3D"auto">We have a streaming application (using apache =
flink and kafka) which populates data in the tables of a postgres database =
version 15.4.</div><div dir=3D"auto"><br></div><div dir=3D"auto">Now while =
loading transactions data we also get some reference data information from =
source (for example customer information) and for these , we dont want to m=
odify or override the existing customer data but want to keep the old data =
with a flag as inactive and the new record should get inserted with flag as=
 active. So for such use case , should we cater this inside the apache flin=
k application code or should we handle this using trigger on the table leve=
l which will execute on each INSERT and execute this logic?=C2=A0</div><div=
 dir=3D"auto"><br></div><div dir=3D"auto">I understand trigger is difficult=
 to debug and monitor stuff. But here in this case , team mates is saying ,=
 we shouldn&#39;t put such code logic into a streaming application code so =
should rather handle through trigger.=C2=A0</div><div dir=3D"auto"><br></di=
v><div dir=3D"auto">I understand, technically its possible bith the way, bu=
t want to understand experts opinion on this and pros ans cons?</div><div d=
ir=3D"auto"><br></div><div dir=3D"auto">Regards</div><div dir=3D"auto">Sud<=
/div></div>

--0000000000001aa887061e7877c6--