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

Hi Akshay/Dave,

We could make the Object Explorer appear on all the workspaces. If space is
a concern then let's make the object explorer collapsible. Even VS-Code
allows it.
That way, dragging the objects will not be a problem.

Below is what I propose:
[image: workspace-aditya.png]

On Tue, Aug 13, 2024 at 1:28 PM Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
wrote:

> 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
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"