Re: Regarding feature #3319

Hi,

Yes, We will store the details that are needed to re-establish the
connection.

Regards
Anil
--

<http://www.enterprisedb.com>

*Anil Sahoo*

Software Engineer

www.enterprisedb.com

Power to Postgres

<https://www.linkedin.com/company/edbpostgres>
<https://twitter.com/edbpostgres?lang=en>
<https://www.facebook.com/EDBpostgres>
<https://www.instagram.com/EDBpostgres/>

On Mon, Aug 12, 2024 at 2:08 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Hi
>
> On Mon, 12 Aug 2024 at 06:50, Anil Sahoo <anil(dot)sahoo(at)enterprisedb(dot)com>
> wrote:
>
>> Hi Hackers,
>>
>>
>> This feature #3319 <https://github.com/pgadmin-org/pgadmin4/issues/3319>,
>> demands the Workspace and the Query tool panel to be saved before exiting
>> the application and on restart it will show earlier opened panels.
>>
>>
>> We are already saving the Browser layout, Query tool layout and the
>> Object explorer tree state but to save the contents of panels we will
>> initially start with the Query tool. The below implementation will be done,
>>
>> 1. Store the query tool panels and the list of connections present in
>> each query tool panel and the active connection
>> 2. Store the query that is written in the editor
>> 3. Store the contents of scratch pad
>>
>> The main reason that this has never been worked on is that there is no
> way to restore the state of a connection to what it was and be sure we've
> got it right. How do you propose to handle that? I assume in a similar way
> to the warnings we give if a connection has to be re-established?
>
>>
>>
>>
>> We will use debouncing to store the workspace data and all other data
>> related to panels in the pgAdmin 4's configured database file. Through
>> debouncing we will be able to call the API at certain intervals of user
>> interaction, and it will update the stored data related to workspace and
>> all other panels.
>>
>
> OK.
>
> --
> Dave Page
> pgAdmin: https://www.pgadmin.org
> PostgreSQL: https://www.postgresql.org
> EDB: https://www.enterprisedb.com
>
> PGDay UK 2024, 11th September, London: https://2024.pgday.uk/
>
>