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

Hi Dave,

On Wed, Aug 14, 2024 at 4:17 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:

>
>
> On Wed, 14 Aug 2024 at 11:20, Aditya Toshniwal <
> aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:
>
>> Hi Akshay/Dave,
>>
>> We could make the Object Explorer appear on all the workspaces.
>>
>
> To what end? Part of the reason for not doing that is that tools like the
> query tool or psql are not connected to, related to, or contextually linked
> to the treeview at all once they've been instantiated - therefore, why show
> them together?
>
For drag-drop, refer to the objects or open a new query tool directly from
the tree like now.
Or, we can change object explorer content relevant to the workspace
selected.

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

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