Re: database design with temporary tables

On 8/29/21 9:10 AM, ourdiaspora wrote:
> Readers,
>
> Some advice would be appreciated about appropriate tables to store temporary data.
>
> Scenario:
> User copies csv file of user data, presumably into some temporary table(s);

Presumably not. Temporary tables only live at most for the length of a
session. It would be a really bad idea to hold sessions open for 24
hours. That is assuming nothing else causes the session to drop and the
data to be lost.

> User selects data (read-only) from extant tables;
> Web server combines user data with read-only data to produce content visible to user as html and/or pdf document;
> User does not need to sign in to use web page, only the user e-mail address;
> User data deleted (including e-mail address) after time (e.g. 24 hours) and/or user selects to receive combined data via e-mail (after which all user data is automatically deleted).
>
> What part of the documention would be most relevant to read firstly, please?

The abo
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com