Proposing Side Workspace in pgAdmin 4 for Query Tool, PSQL and Schema Diff

Hi All,

I’m currently developing a proof of concept (POC) for integrating a side
workspace (7708 <https://github.com/pgadmin-org/pgadmin4/issues/7708>) into
pgAdmin 4 similar to the workspaces found in VSCode and PyCharm. This
workspace will be for Query Tool, PSQL, and Schema Diff Tool. I’ve
completed the initial phase of this POC and would appreciate your feedback
on the following points:

1. Does this approach seem promising?
2. We plan to make the interface configurable, allowing users to choose
between "Classic UI" and "Workspace UI." We’ll also work on selecting
appropriate labels for these options.

*How it works/behaves:*

- The first workspace is the general workspace, which includes the
Object Explorer and other basic tabs (retaining the current look and feel).
- The second workspace is dedicated solely to the Query Tool, where
we’ll introduce a welcome page (the design is still in progress). Every
Query Tool and View/Edit Data tab will open within this workspace.
- The third workspace is reserved for PSQL, where all PSQL tabs will be
opened.
- The fourth workspace is specifically for Schema Diff, where all Schema
Diff tabs will be opened.

*Challenges:*

- Drag and Drop objects from the General workspace to the Query Tool
workspace.
- Changing the UI from "Classic" to "Workpsace" and vice versa based on
preference setting.

I have created an installer for OSX and Windows if you would like to check
the behavior you can download it from
https://drive.google.com/drive/folders/18TO5ezO7PcgI0ArStPW0S2gBvqInvDkz?usp=drive_link

Few Screenshots:
[image: Screenshot 2024-08-13 at 1.00.19 PM.png]. [image:
Screenshot 2024-08-13 at 1.01.02 PM.png]

[image: Screenshot 2024-08-13 at 1.01.20 PM.png]. [image:
Screenshot 2024-08-13 at 1.01.35 PM.png]

Akshay Joshi

Principle Software Architect

enterprisedb.com

* Blog*: https://www.enterprisedb.com/akshay-joshi
* GitHub*: https://github.com/akshay-joshi
* LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216