Re: database design with temporary tables

On 29/08/2021 17:36, ourdiaspora wrote:
> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
>
> On Sunday, August 29th, 2021 at 5:24 PM, Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)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(at)rodonnell(dot)ie