On 8/29/21 2:26 PM, Adrian Klaver wrote:
The pool is maintained, the individual connections(sessions) come and
go. Otherwise there would be no point to having a pool. Every time the
connection(session) is closed the temporary table disappears.
Yes, you're right. And that is very convenient.
On 8/29/21 10:41 AM, Mladen Gogala wrote:
On 8/29/21 12:24 PM, Adrian Klaver 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. That is assuming nothing else causes the session to drop and
th
On 8/29/21 12:24 PM, Adrian Klaver 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. That is assuming nothing else causes the session to drop and
the data to be lost.
Well, that's precise
On Sunday, August 29th, 2021 at 5:56 PM, Ray O'Donnell
wrote:
>
- or do they connect only to the web server, which then
>
> uses its own account on the database server?
Thank you; was not aware of this consideration and this option seems most
appropriate for the simple sql commands envisaged.
On 29/08/2021 17:53, Adrian Klaver wrote:
On 8/29/21 9:38 AM, ourdiaspora wrote:
‐‐‐ Original Message ‐‐‐
On Sunday, August 29th, 2021 at 5:30 PM, Adrian Klaver
wrote:
On 8/29/21 9:24 AM, Adrian Klaver wrote:
Whoops, unfinished thought. What I was going to ask is:
The above is
On 8/29/21 9:38 AM, ourdiaspora wrote:
‐‐‐ Original Message ‐‐‐
On Sunday, August 29th, 2021 at 5:30 PM, Adrian Klaver
wrote:
On 8/29/21 9:24 AM, Adrian Klaver wrote:
Whoops, unfinished thought. What I was going to ask is:
The above is not clear to me. Are you asking about the Po
On 8/29/21 9:36 AM, ourdiaspora wrote:
‐‐‐ Original Message ‐‐‐
On Sunday, August 29th, 2021 at 5:24 PM, Adrian Klaver
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 ther
‐‐‐ Original Message ‐‐‐
On Sunday, August 29th, 2021 at 5:38 PM, Ray O'Donnell
wrote:
>
> I'd save a timestamp with the session data, and then run a cron job
>
> which deletes sessions older than whatever lifetime you want.
>
Is it prudent in this scenario for the user to create (a)
On Sunday, August 29, 2021, Ray O'Donnell wrote:
>
>>>
>> 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?
>
>
In general a
On Sunday, August 29, 2021, ourdiaspora wrote:
>
>
> Yes, wanted to know relevant parts because often the first problem is to
> know which part of the (extensive) documentation to read...
>
>
Suggest you just start developing. When you get stuck the nature of the
block should inform where to go l
On 29/08/2021 17:36, ourdiaspora wrote:
‐‐‐ Original Message ‐‐‐
On Sunday, August 29th, 2021 at 5:24 PM, Adrian Klaver
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 ther
‐‐‐ Original Message ‐‐‐
On Sunday, August 29th, 2021 at 5:30 PM, Adrian Klaver
wrote:
> On 8/29/21 9:24 AM, Adrian Klaver wrote:
>
>
> Whoops, unfinished thought. What I was going to ask is:
>
> The above is not clear to me. Are you asking about the Postgres
>
> documentation?
>
Yes
‐‐‐ Original Message ‐‐‐
On Sunday, August 29th, 2021 at 5:24 PM, Adrian Klaver
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
On 8/29/21 9:24 AM, Adrian Klaver wrote:
On 8/29/21 9:10 AM, ourdiaspora wrote:
Readers,
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 w
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
ses
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);
User selects data (read-only) from extant tables;
Web server combines user data with read-only data to produce content
16 matches
Mail list logo
