Re: database design with temporary tables - Mailing list pgsql-general

From Adrian Klaver
Subject Re: database design with temporary tables
Date
Msg-id 0e9373c9-565c-5edb-5c71-b3ea40be9473@aklaver.com
Whole thread Raw
In response to database design with temporary tables  (ourdiaspora <ourdiaspora@protonmail.com>)
Responses Re: database design with temporary tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: database design with temporary tables  (ourdiaspora <ourdiaspora@protonmail.com>)
Re: database design with temporary tables  (Mladen Gogala <gogala.mladen@gmail.com>)
List pgsql-general
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
viae-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.klaver@aklaver.com



pgsql-general by date:

Previous
From: ourdiaspora
Date:
Subject: database design with temporary tables
Next
From: Adrian Klaver
Date:
Subject: Re: database design with temporary tables