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

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Aditya Toshniwal <[email protected]>
To: Dave Page <[email protected]>
Cc: Akshay Joshi <[email protected]>
Cc: Dave Page <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Subject: Re: Proposing Side Workspace in pgAdmin 4 for Query Tool, PSQL and Schema Diff
Date: Wed, 14 Aug 2024 16:30:31 +0530
Message-ID: <CAM9w-_nb1XahaKYTEU=KyK_wpBJA+f50FLJTRE9tA9+Eut0SCA@mail.gmail.com> (raw)
In-Reply-To: <CA+OCxoyGfFOpJvavTsngjaz=vgYLeYkrCZEZXAwtZP0Ou_Lw8w@mail.gmail.com>
References: <CANxoLDcGNeJuhrO=f4e7pdQbav3dmSLQJoKV6F7THvOjpTvqUg@mail.gmail.com>
	<CAM9w-_nH93wmqYPfY8A8z4mYiKnNfmewF7V1_ieZaQu6A+r7Ow@mail.gmail.com>
	<CA+OCxoyGfFOpJvavTsngjaz=vgYLeYkrCZEZXAwtZP0Ou_Lw8w@mail.gmail.com>

Hi Dave,


On Wed, Aug 14, 2024 at 4:17 PM Dave Page <[email protected]> wrote:

>
>
> On Wed, 14 Aug 2024 at 11:20, Aditya Toshniwal <
> [email protected]> 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 <
>> [email protected]> 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"


Attachments:

  [image/png] Screenshot 2024-08-13 at 1.00.19 PM.png (330.2K, ../CAM9w-_nb1XahaKYTEU=KyK_wpBJA+f50FLJTRE9tA9+Eut0SCA@mail.gmail.com/3-Screenshot%202024-08-13%20at%201.00.19%E2%80%AFPM.png)
  download | view image

  [image/png] Screenshot 2024-08-13 at 1.01.20 PM.png (70.8K, ../CAM9w-_nb1XahaKYTEU=KyK_wpBJA+f50FLJTRE9tA9+Eut0SCA@mail.gmail.com/4-Screenshot%202024-08-13%20at%201.01.20%E2%80%AFPM.png)
  download | view image

  [image/png] Screenshot 2024-08-13 at 1.01.35 PM.png (184.1K, ../CAM9w-_nb1XahaKYTEU=KyK_wpBJA+f50FLJTRE9tA9+Eut0SCA@mail.gmail.com/5-Screenshot%202024-08-13%20at%201.01.35%E2%80%AFPM.png)
  download | view image

  [image/png] Screenshot 2024-08-13 at 1.01.02 PM.png (110.3K, ../CAM9w-_nb1XahaKYTEU=KyK_wpBJA+f50FLJTRE9tA9+Eut0SCA@mail.gmail.com/6-Screenshot%202024-08-13%20at%201.01.02%E2%80%AFPM.png)
  download | view image

  [image/png] workspace-aditya.png (29.3K, ../CAM9w-_nb1XahaKYTEU=KyK_wpBJA+f50FLJTRE9tA9+Eut0SCA@mail.gmail.com/7-workspace-aditya.png)
  download | view image

view thread (8+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Proposing Side Workspace in pgAdmin 4 for Query Tool, PSQL and Schema Diff
  In-Reply-To: <CAM9w-_nb1XahaKYTEU=KyK_wpBJA+f50FLJTRE9tA9+Eut0SCA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox