Re: Schema design: user account deletion vs. keeping family tree data

Ron Johnson <ronljohnsonjr@gmail.com>

From: Ron Johnson <ronljohnsonjr@gmail.com>
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-11-25T22:02:26Z
Lists: pgsql-general
On Tue, Nov 25, 2025 at 4:08 PM 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’t expect at first thought (see also the website about
> 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

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