Re: database design with temporary tables

Поиск
Список
Период
Сортировка
От Ray O'Donnell
Тема Re: database design with temporary tables
Дата
Msg-id 7d2c5ed8-ad27-611e-7717-f3c5e3aa4995@rodonnell.ie
обсуждение исходный текст
Ответ на Re: database design with temporary tables  (ourdiaspora <ourdiaspora@protonmail.com>)
Ответы Re: database design with temporary tables  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: database design with temporary tables  (ourdiaspora <ourdiaspora@protonmail.com>)
Список pgsql-general
On 29/08/2021 17:36, ourdiaspora wrote:
> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
> 
> On Sunday, August 29th, 2021 at 5:24 PM, Adrian Klaver
> <adrian.klaver@aklaver.com> wrote:
> 
>> 
>> 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.
> 
> Is there an alternative scenario, such as the user is able to create
> a new table with saves the session data for a maximum time (such as
> 24 hours), even up to a certain time if the web browser crashes for
> example?

I'd save a timestamp with the session data, and then run a cron job 
which deletes sessions older than whatever lifetime you want.

Ray.



-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie



В списке pgsql-general по дате отправления:

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