Hi Dave,What about the query tools opened with an ad-hoc server, should we just open a query tool with data without connections?
Thanks,Yogesh MahajanEnterpriseDBOn Thu, Mar 13, 2025 at 4:59 PM Dave Page <dpage@pgadmin.org> wrote:HiOn Thu, 13 Mar 2025 at 11:20, Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:Hi Dave,Couple of follow up questions - Thanks,Yogesh MahajanEnterpriseDBOn 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 PagepgAdmin: https://www.pgadmin.orgPostgreSQL: https://www.postgresql.orgpgEdge: https://www.pgedge.com-- Dave PagepgAdmin: https://www.pgadmin.orgPostgreSQL: https://www.postgresql.orgpgEdge: https://www.pgedge.com
HiOn Thu, 13 Mar 2025 at 11:20, Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:Hi Dave,Couple of follow up questions - Thanks,Yogesh MahajanEnterpriseDBOn 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 PagepgAdmin: https://www.pgadmin.orgPostgreSQL: https://www.postgresql.orgpgEdge: https://www.pgedge.com-- Dave PagepgAdmin: https://www.pgadmin.orgPostgreSQL: https://www.postgresql.orgpgEdge: https://www.pgedge.com
Hi Dave,Couple of follow up questions - Thanks,Yogesh MahajanEnterpriseDBOn 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?
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.
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.
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 PagepgAdmin: https://www.pgadmin.orgPostgreSQL: https://www.postgresql.orgpgEdge: https://www.pgedge.com
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.
2.Can we use an existing crypt key to encrypt the query data or simply json encoding should be enough?
-- Dave PagepgAdmin: https://www.pgadmin.orgPostgreSQL: https://www.postgresql.orgpgEdge: https://www.pgedge.com
pgadmin-hackers by date:
Соглашаюсь с условиями обработки персональных данных
