Re: database design with temporary tables

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: database design with temporary tables
Дата
Msg-id 0e9373c9-565c-5edb-5c71-b3ea40be9473@aklaver.com
обсуждение исходный текст
Ответ на database design with temporary tables  (ourdiaspora <ourdiaspora@protonmail.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: ourdiaspora
Дата:
Сообщение: database design with temporary tables
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: database design with temporary tables