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

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Schema design: user account deletion vs. keeping family tree data
Date: 2025-11-25 22:02:26
Message-ID: CANzqJaCfSFh+hjL1EVa9tHA3gzHfnciWBhFBzz_naPj3a008kA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 25, 2025 at 4:08 PM Jan Claeys <lists(at)janc(dot)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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ertan Küçükoglu 2025-11-25 22:03:15 Re: Restore Windows dump to Linux (locale issue)
Previous Message Adrian Klaver 2025-11-25 21:20:04 Re: Restore Windows dump to Linux (locale issue)