MIME-Version: 1.0
References: <CAM-5MT2gc+=tm5ErdoEyHDef3NzNL2UbAkrykdca9=1VJZi4fg@mail.gmail.com>
In-Reply-To: <CAM-5MT2gc+=tm5ErdoEyHDef3NzNL2UbAkrykdca9=1VJZi4fg@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 3 Dec 2024 13:10:05 -0500
Message-ID: <CANzqJaCykFdcEqKrdHbR9wZo0wUFuA07zJXuqC68s==aUNhAXQ@mail.gmail.com>
Subject: Re: Best Practices for Managing Schema Changes Dynamically with libpq
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c8d2ab0628619342"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCykFdcEqKrdHbR9wZo0wUFuA07zJXuqC68s%3D%3DaUNhAXQ%40mail.gmail.com>
Precedence: bulk

--000000000000c8d2ab0628619342
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Dec 3, 2024 at 12:44=E2=80=AFPM Sasmit Utkarsh <utkarshsasmit@gmail=
.com>
wrote:
[snip]

> How can we efficiently handle table additions/updates while keeping the
> application and database in sync dynamically?
>

Enumerate all relevant column names in SELECT and INSERT statements.  That
way, the application still works when you add columns or alter(*) data
types.  Dropping columns will still break your app.

*Altering to from a numeric type to a text type might still kill your app,
if it can't convert the string into your app's int or float type..

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Dec 3, 2024 at 12:44=E2=80=AFPM S=
asmit Utkarsh &lt;<a href=3D"mailto:utkarshsasmit@gmail.com">utkarshsasmit@=
gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote"><div>[snip]=C2=A0<=
/div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><di=
v>How can we efficiently handle table additions/updates while keeping the a=
pplication and database in sync dynamically?</div></div></blockquote></div>=
<div><br clear=3D"all"></div><div>Enumerate all relevant column names in SE=
LECT and INSERT statements.=C2=A0 That way, the application still works whe=
n you add columns or alter(*) data types.=C2=A0 Dropping columns will still=
 break your app.</div><div><br></div><div>*Altering to from a numeric type =
to a text type might still kill your app, if it can&#39;t convert the strin=
g into your app&#39;s int or float type..</div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div=
>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobs=
ter!</div></div></div></div></div></div>

--000000000000c8d2ab0628619342--