Re: Regarding feature #3319

Hi

On Thu, 13 Mar 2025 at 11:20, Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:

Hi Dave,

Couple of follow up questions - 

Thanks,

Yogesh Mahajan

EnterpriseDB

On Thu, Mar 13, 2025 at 4:37 PM Dave Page <dpage@pgadmin.org> wrote:

On Tue, 11 Mar 2025 at 08:31, Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:

Hello Team,

Couple of more questions arose during discussion - 

1.What all tools should we reopen while restoration? It could be Query tool, ERD, Psql, Schema diff as of now may get additional in future.

Yes :-). Ideally, as much of the original state as possible should be restored. 

So, should we open the psql without data and schema diff without comparison results?

I don't see that we have any choice for psql. We absolutely should *not* attempt to automatically re-run user queries.

For the schema diff, yes, that could be very expensive. The user can press the button if they want to incur that cost.

 

Also for the query tools open with an ad-hoc server, should we just open a query tool with data without connections?

 

2.Can we use an existing crypt key to encrypt the query data or simply json encoding should be enough?

We're already storing the query history, so we should follow the precedent there.

Currently we are storing this data with json encoding done by the request module.

--

Dave Page

pgAdmin: https://www.pgadmin.org

PostgreSQL: https://www.postgresql.org

pgEdge: https://www.pgedge.com

--

Dave Page

pgAdmin: https://www.pgadmin.org

PostgreSQL: https://www.postgresql.org

pgEdge: https://www.pgedge.com