Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1erGTu-00014z-El for pgadmin-hackers@arkaria.postgresql.org; Thu, 01 Mar 2018 05:10:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1erGTt-0003Ld-Dh for pgadmin-hackers@arkaria.postgresql.org; Thu, 01 Mar 2018 05:10:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1erGTt-0003LN-7M for pgadmin-hackers@lists.postgresql.org; Thu, 01 Mar 2018 05:10:13 +0000 Received: from mail-oi0-x229.google.com ([2607:f8b0:4003:c06::229]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1erGTl-0004yl-LV for pgadmin-hackers@postgresql.org; Thu, 01 Mar 2018 05:10:12 +0000 Received: by mail-oi0-x229.google.com with SMTP id c18so3599515oiy.9 for ; Wed, 28 Feb 2018 21:10:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=JZJlG4O31IUDK4mPA9/RKmXrVWTO/stTBVZZYkMcKHI=; b=aOd7zCb5jJVF00Ks2pjZvO0GWQ2kYmATFEixxHAO/iBOcgueaclyBRbskLmOzNPHsU ++af49FdxMcAHLfLPqhuQLIKfoG0MhS+IVYy43A9qr/vZgtcNdHCCcl1M+NAZ1gkIPih Ld15OnlAMQCcywcR4mqlTLBzg4avngskEbj3P1tc65vx9QL0ixHdFW/Nk6f/l/9LfqCZ cIFT973OcJiqF6iJjMAlkBb9kE6+T7wUOZWCsAENiOI/7XowJO9SlRiY3O3DT2VyuGOf BLrywZhItPIX+DWza9wJkqYyKB5csckvOe2HiWE6wTkPTTi+z9x2wP5wo5cNe7BzdSmi kDpQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=JZJlG4O31IUDK4mPA9/RKmXrVWTO/stTBVZZYkMcKHI=; b=ARgSIg9YtwfjtQeSZ2Pv0S9+glxKeP2UXBah1gu7GFQtXAQQMVp2VMwg8h0GNNfNrg h7fbTQRwmjdpA1PI1o+0IAoNldXrKyzQ6+xpfPSWaQKp63z5yDtD0ZLwPgcw8TvZkfiU tg9JKAwk3fFIB60sxfqT2yNqGej/lfFKLTTirv5L+SGzsLD1232b+83AXeCAP+2MULnN 6Ms4LlxerWGNJy7vHDUg8BXHMnfcmQKVeQhcGU08V3AVS0DEdOpm41kilGDxfEphTfE7 cbgQGuyM9R1ERbkddQuMHLPslT8yptbNVdkeU1mZHaSzWAVcofelroobCsJPXQVY5L1/ kYWQ== X-Gm-Message-State: AElRT7GQBoL/uwbnkaDxXz2QuNeARMX8yKDJ6MCJeZlZ39xjx1S3ZoLD 60e/s0Nndm4M+3iWXXbLzkC5AnF9pXFFgvmgX5XPTA== X-Google-Smtp-Source: AG47ELtQ2twRCPMrcXYZEGUCyGnZlnUzr83WgnJ00jvuv+N2TGZoqVnnQyVpGOb2fbIt3H638Gsy5QSPpQj3hwY03Ek= X-Received: by 10.202.221.131 with SMTP id u125mr365045oig.104.1519881002380; Wed, 28 Feb 2018 21:10:02 -0800 (PST) MIME-Version: 1.0 Received: by 10.74.8.150 with HTTP; Wed, 28 Feb 2018 21:09:42 -0800 (PST) In-Reply-To: References: From: Murtuza Zabuawala Date: Thu, 1 Mar 2018 10:39:42 +0530 Message-ID: Subject: Re: Feature #3061 To: Neethu Mariya Joy Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="001a113d60183fc79a056652dff9" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --001a113d60183fc79a056652dff9 Content-Type: text/plain; charset="UTF-8" Hello, First of all I'm assuming that you have some degree of knowledge about Python, HTML, JS & Git. We have had added similar feature recently. Check: https://redmine.postgresql.org/issues/2951 for more details. Code location of Dashboard module in git repository: ../pgadmin4/web/pgadmin/dashboard There are 3 requirments in the ticket, 1) disable/enable some widgets (widget - Server Sessions | Transactions per second | Tuples in etc) We have done this for all the graphs in one shot, now user can enable/disable all the graphs via preferences dialog. You can refer the commit as a reference if you want to add this functionality for each individual graphs. 2) add custom/user specify widgets - First of all, You need to provide an option to Create new dashboard dialog, Update existing dashboard dialog option and also to delete those existing custom dashboards on dashboard page. - You have to create a separate table in sqlite3 database to store the data for that user defined dashboards like Dashboard name, SQL etc. - You also have to provide option to use to choose what type of graph user wants (Line chart, Pie chart, Table etc) - Size & location of the graph/table. 3) add user role with access only to dashboard This needs further discussion with community members if we really need this or not. You can refer README for more information regarding how to run pgAdmin4. Let us know if you need any help. -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Wed, Feb 28, 2018 at 6:29 PM, Neethu Mariya Joy < neethumariyajoy@gmail.com> wrote: > Hi, > > I am Neethu Mariya Joy, an undergraduate sophomore pursuing BE(Hons) in > Computer Engineering from BITS Pilani, India. > > I would like to work on the feature #3061, "Dashboard Customisation". > Kindly provide suggestions for the same. > > Sincerely, > Neethu Mariya Joy > GitHub | Linkedin > > --001a113d60183fc79a056652dff9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,

First of all I'm assuming that you have some degree of knowled= ge about Python, HTML, JS & Git.

We have had added similar feature recent= ly.
Check:=C2=A0https://redmine.postgresql.or= g/issues/2951 for more details.
Code location of Dashboard module in = git repository: ../pgadmi= n4/web/pgadmin/dashboard

There are 3 requirments in the ticket,
1) disable/enable= some widgets (widget - Server Sessions | Transactions per second | Tuples = in etc)=C2=A0
We have done this for all the graphs in on= e shot, now user can enable/disable all the graphs via preferences dialog.<= /font>
You can refer the = commit as a reference if you want to add this functionality=C2=A0for ea= ch individual=C2=A0graphs.

2) = add custom/user specify widgets=C2=A0
- First of all, Yo= u need to provide an option to Create new dashboard dialog, Update existing= dashboard dialog option and also to delete those existing custom dashboard= s on dashboard page.
= - You have to create a separate=C2=A0table in sqlite3 database to store the= data for that user defined dashboards like Dashboard name, SQL etc.=
- You also have to provide option to use to choose what type o= f graph user wants (Line chart, Pie chart, Table etc)
- = Size & location of the graph/table.

3) add user role with access only to dashboard
This needs further=C2=A0discussion with community membe= rs if we really need this or not.
=
You can= refer README for more information regarding how to run pgAdmin4.

=
Let us know if you need any help.


--
Regards,
Murtuza Zabuawala
Enterpr= iseDB:=C2=A0http://www.enterprisedb.com
The Enterprise PostgreSQL= Company


On Wed, Feb 28, 2018 at 6:29 PM, Neethu Mari= ya Joy <neethumariyajoy@gmail.com> wrote:
Hi,=C2=A0

I am = Neethu Mariya Joy,=C2=A0an undergraduate sophomo= re pursuing BE(Hons) in Computer Engineering from BITS Pilani, India.=C2=A0=

I would like to work on the feature #3061, "Dashboa= rd Customisation". Kindly provide suggestions for the same.

Sincerely,
Neethu Mariy= a Joy
GitHub=C2=A0|=C2=A0Linkedin

--001a113d60183fc79a056652dff9--