MIME-Version: 1.0
References: <CAEzggP_UOGwe5BA9s3iLY3R8LEi4QztA=2ka+vkRp-Wy64vXdQ@mail.gmail.com>
 <bbd73b96fbce29e0c1941253590f39ced1e79d4d.camel@janc.be>
In-Reply-To: <bbd73b96fbce29e0c1941253590f39ced1e79d4d.camel@janc.be>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 25 Nov 2025 17:02:26 -0500
Message-ID: <CANzqJaCfSFh+hjL1EVa9tHA3gzHfnciWBhFBzz_naPj3a008kA@mail.gmail.com>
Subject: Re: Schema design: user account deletion vs. keeping family tree data
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000013fbd406447270bd"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCfSFh%2BhjL1EVa9tHA3gzHfnciWBhFBzz_naPj3a008kA%40mail.gmail.com>
Precedence: bulk

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

On Tue, Nov 25, 2025 at 4:08=E2=80=AFPM Jan Claeys <lists@janc.be> wrote:
[snip]

> Genealogy is messy, and you will have to be able to store all sorts of
> data you didn=E2=80=99t expect at first thought (see also the website abo=
ut
> names Rob Sargent linked to).
> You also seem to make assumptions about relations being 1:1 or 1:N when
> in reality they are very often 1:N or N:N instead.
>

Gramps is a great Python-based genealogy program, which has a Web frontend:
https://github.com/gramps-project/gramps-web

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Nov 25, 2025 at 4:08=E2=80=AFPM J=
an Claeys &lt;<a href=3D"mailto:lists@janc.be">lists@janc.be</a>&gt; wrote:=
</div><div class=3D"gmail_quote gmail_quote_container"><div>[snip]=C2=A0</d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex">Genealogy is messy, an=
d you will have to be able to store all sorts of<br>
data you didn=E2=80=99t expect at first thought (see also the website about=
<br>
names Rob Sargent linked to).<br>
You also seem to make assumptions about relations being 1:1 or 1:N when<br>
in reality they are very often 1:N or N:N instead.<br></blockquote></div><d=
iv><br></div><div>Gramps is a great Python-based genealogy program, which h=
as a Web frontend:=C2=A0<a href=3D"https://github.com/gramps-project/gramps=
-web">https://github.com/gramps-project/gramps-web</a></div><div><br></div>=
<span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=
=3D"gmail_signature"><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;Redact=
ed&gt; lobster!</div></div></div></div></div></div>

--00000000000013fbd406447270bd--