Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u50A5-00AfEf-OE for pgadmin-hackers@arkaria.postgresql.org; Wed, 16 Apr 2025 10:38:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u50A3-00Brs2-B2 for pgadmin-hackers@arkaria.postgresql.org; Wed, 16 Apr 2025 10:38:32 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u50A2-00Brrk-Lz for pgadmin-hackers@lists.postgresql.org; Wed, 16 Apr 2025 10:38:31 +0000 Received: from mail-oi1-x22a.google.com ([2607:f8b0:4864:20::22a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u509w-000M4r-0f for pgadmin-hackers@postgresql.org; Wed, 16 Apr 2025 10:38:27 +0000 Received: by mail-oi1-x22a.google.com with SMTP id 5614622812f47-3feb0db95e6so4184563b6e.1 for ; Wed, 16 Apr 2025 03:38:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1744799904; x=1745404704; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=gEbD9E8tao5u0HJrlcsAPJvCDf//3y6yDW0RHkpl994=; b=Fm+4rFG51ZMFEvHW2N4LWEVTw0T9BEO9L8uqnv8QlREq0Z7/VROsTyYR+GfnFEeULD 9zqAIqWTsx/70tKZduvUHE+X/VNpxnMLnS7KGTfb+oeJfTn+UPbII38CJJ3C4Le+gv3c lw6QeIi1BjNBLLNlrD0XFERr0iSuc+RSaJIbFdTJL8pYi2tl9mJDfR3cKp+cDjixQ8Xk l4mkb7+uPodaUnPqzGFogPzPWjkktzx6GoDuC57F6UJ7FL0vFEc3c7ZuFwsoKj5dJtuw mJHVBJTc2hOrwZRKoAerVQ7aA/tPMaIIUHTiwzK+SLD/d8yu/OSMfGAz2yI5cVC200kq n87g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744799904; x=1745404704; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=gEbD9E8tao5u0HJrlcsAPJvCDf//3y6yDW0RHkpl994=; b=hCAOMl3uq4puIHpFOVnWW3rVsDfaOfLZ9BnOSNsgFKXQgO9jpgD/v20EnSE9PtY0w/ tLsQZvZSwd05f2CiWi78Kr0rxOukIVoJ3umunt6ktX2xX028Pi4SFxFSjPDJtKKOp4ki oBj42POSMfkdolS35IXzO2OflWN+cJvjrpQQZ5mQd//aLtCvRiqq+YvE/PQxVAt9gPFt j5p0GdnJ9ZguOdFD+wP+bDrJH3WRMVKn9rRCEqlJfVnmkxtl6HOmXFttufjrnZ1EnDUG OQDo4wK76VwZ21wJhPRpCHbFnaOhKO/e4L+vsCB1msJk4ZWmK+FcTJT1Em99j+FdWlTl Z/NA== X-Gm-Message-State: AOJu0YzbFaAVxdlhwRowSW+4aF+ICPiq+zjq6V+gYK5WUB/tpwM8rvlE s0FEMzmTkdoLa812Ys7ejetboObWaRjtn6bkAqUABMobGD7aiNxPb62Abg1J5zuk04tdRkOxYUx bNHQ/WK88cxLy7bhN2PaVdYYaZKTyufuEwGmek7iOsUuw2t0QmyFV X-Gm-Gg: ASbGncs+G2nU6o8+jBoOY8e85f2hqo3sFddXQDerBYXtMYBUfZ/yGXcAX+0un+UfIff hjWpfx+4uO4nRzUSADvcOe8BGV1k8myKHM62378+NdnotYtINSvPnZAfW/AsSM2O+FHOS5DyIL0 x/UTLZQ071n7tPRPw/SBbNzyA= X-Google-Smtp-Source: AGHT+IHp3Rfd/pPyIcmF4lSBlHqoz1VRbgSSI/YYCYKfcCMwonbvDjZUC/R6I56JKsbgui6cMj2Vva7xbQqUxbvywCQ= X-Received: by 2002:a05:6808:10d0:b0:3fa:7909:2717 with SMTP id 5614622812f47-400b022fed9mr662758b6e.34.1744799903133; Wed, 16 Apr 2025 03:38:23 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Anil Sahoo Date: Wed, 16 Apr 2025 16:07:45 +0530 X-Gm-Features: ATxdqUFWbmP_Eh8CDO4ctS_s5-crDsFxDXLR7fhLmpsblSxxVdXd0pOg-DJA9I4 Message-ID: Subject: Re: Require suggestions on feature #5766 To: Dave Page Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000006e5a870632e2e2e4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006e5a870632e2e2e4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Dave, As we discussed in the last meeting, along with your suggestion to add a key in pgaweb's versions.json indicating the source URL for downloading updates for the auto-update feature, I propose the following approach. We will need to make corresponding changes in the pgaweb repository to support this. *Example versions.json format:* { =E2=80=9Cedb-pgadmin4=E2=80=9D: { =E2=80=9Cversion=E2=80=9D: =E2=80=9C9.0=E2=80=9D, =E2=80=9Cversion_int=E2=80=9D: 90000, =E2=80=9Cdownload_url=E2=80=9D: =E2=80=9C https://www.enterprisedb.com/downloads/postgres-postgresql-downloads=E2=80= =9D, =E2=80=9Cauto_update_url=E2=80=9D: { =E2=80=9CmacOS=E2=80=9D: =E2=80=9C=E2=80=9C, =E2=80=9Cwindows=E2=80=9D: =E2=80=9C=E2=80=9D } }, =E2=80=9Cpgadmin4=E2=80=9D: { =E2=80=9Cversion=E2=80=9D: =E2=80=9C9.2=E2=80=9D, =E2=80=9Cversion_int=E2=80=9D: 90200, =E2=80=9Cdownload_url=E2=80=9D: =E2=80=9Chttps://www.pgadmin.org/downlo= ad/=E2=80=9D, =E2=80=9Cauto_update_url=E2=80=9D: { =E2=80=9CmacOS=E2=80=9D: =E2=80=9C https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v9.2/macos/=E2=80=9D, =E2=80=9Cwindows=E2=80=9D: =E2=80=9C https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v9.2/windows/=E2=80=9D } } } Additionally, as I mentioned earlier, for Electron=E2=80=99s auto-update to function on macOS, we need to provide a zip installer that contains the pgA= dmin 4.app. If we maintain zip installers for both arm64 and x86_64 macOS architectures, and potentially extend auto-update support to Windows in the future, we estimate requiring up to 1.5 GB of additional storage on the FTP server beyond the current allocation. Please note that we only need to store the zip files for the latest version, as older versions will be updated directly to the newest release. Please share your suggestions on this. Thanks, Anil On Wed, Mar 19, 2025 at 6:53=E2=80=AFPM Anil Sahoo wrote: > Okay, I will implement it as per the suggestions. > > Thanks > > On Wed, Mar 19, 2025 at 5:14=E2=80=AFPM Dave Page wro= te: > >> >> >> On Wed, 19 Mar 2025 at 10:58, Anil Sahoo >> wrote: >> >>> Hi Dave, >>> >>> As discussed I moved with auto-update of pgAdmin 4 application in macOs >>> system locally. It is successful. >>> So now I have to do some additional user experience improvements. >>> >>> Listing down some ways we can show the user that a new version is >>> available and he can download and install it. >>> >>> *Option 1:* >>> >>> Show a dialog with the released features and fixes(mentioned in the >>> release note) with *"Download & Restart"* and *"Cancel"* buttons. This >>> dialog will be shown only when the application starts for the first tim= e of >>> the day. >>> >>> Benefits of showing this dialog will help users to know about the new >>> features and bugs fixed available in the latest version. >>> >>> "Download & Restart" button will download the latest version and quit >>> the app and install and open the latest app. "Cancel" will cancel the >>> notification. >>> >>> *Option 2:* >>> >>> We are currently showing a warning notification of the latest version >>> available, if the older version is being used by the user, we can add *= "Download >>> & Restart"* and *"Cancel" * buttons. And those buttons will work the >>> way they are working in Option 1. >>> >>> Additionally we will add *"Check for updates"* option in pgAdmin 4 >>> native menu, if any time a user wants to check for updates manually the= n >>> can prefer this and if update is available then the *"Restart to >>> update"* option will show and if clicked will quit the app and install >>> the latest version. >>> >>> Let me know in which way we can proceed. >>> >> >> Option 1 seems good to me; though the current notifier should continue t= o >> work as it does now if a particular distribution channel doesn't support >> auto-updates (for example, the EDB PostgreSQL Installer). >> >> -- >> Dave Page >> pgAdmin: https://www.pgadmin.org >> PostgreSQL: https://www.postgresql.org >> pgEdge: https://www.pgedge.com >> >> > > -- > > > *Anil Sahoo* > > Software Development Engineer II > > LinkedIn || Blog > || *GitHub > * > > enterprisedb.com > --=20 *Anil Sahoo* Software Development Engineer II LinkedIn || Blog || *GitHub * enterprisedb.com --0000000000006e5a870632e2e2e4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi D= ave,

As we discusse= d in the last meeting, along with your suggestion to add a key in pgaweb= 9;s=C2=A0versions.json indicating the source URL for downloadi= ng updates for the auto-update feature, I propose the following approach. W= e will need to make corresponding changes in the pgaweb reposi= tory to support this.

Exampl= e versions.json format:

{

=C2=A0=C2=A0=E2=80=9Cedb-= pgadmin4=E2=80=9D: {
=C2=A0=C2=A0=C2=A0=C2=A0=E2=80=9Cversion=E2=80=9D: =E2=80=9C9.0=E2=80= =9D,
=C2=A0=C2= =A0=C2=A0=C2=A0=E2=80=9Cversion_int=E2=80=9D: 90000,
=C2=A0=C2=A0=C2=A0=C2=A0=E2=80=9Cdown= load_url=E2=80=9D: =E2=80=9Chttps://www.enterprisedb.com/downloads/postgres-postgresql-downloads= =E2=80=9D,
= =C2=A0=C2=A0=C2=A0= =C2=A0=E2=80=9Cauto_update_url=E2=80=9D: {
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=E2=80=9CmacOS=E2=80=9D: =E2=80=9C<edb_installer_url>=E2=80=9C,
=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=E2=80=9Cwindows=E2=80=9D: =E2=80=9C<ed= b_installer_url>=E2=80=9D
=C2=A0=C2=A0=C2=A0}
=C2=A0=C2=A0},
=C2=A0=C2=A0=E2=80=9Cpgadmin4=E2=80=9D: {
=C2=A0=C2=A0=C2=A0=C2=A0=E2= =80=9Cversion=E2=80=9D: =E2=80=9C9.2=E2=80=9D,
=C2=A0=C2=A0=C2=A0=C2=A0=E2=80=9Cversion_in= t=E2=80=9D: 90200,
=C2=A0=C2=A0=C2=A0=C2=A0=E2=80=9Cdownload_url=E2=80=9D: =E2=80=9Chttps://www.pgadmin.org/download/=E2=80=9D,
=C2=A0=C2=A0=C2=A0=C2=A0=E2=80=9Cauto_update_url= =E2=80=9D: {
= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=E2=80=9CmacOS=E2=80=9D: = =E2=80=9Chttps://ftp.postgresql= .org/pub/pgadmin/pgadmin4/v9.2/macos/=E2=80=9D,
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=E2=80=9C= windows=E2=80=9D: =E2=80=9Chttps://ft= p.postgresql.org/pub/pgadmin/pgadmin4/v9.2/windows/=E2=80=9D
=C2=A0=C2=A0=C2=A0}
=C2=A0=C2=A0}
}

Additionally, = as I mentioned earlier, for Electron=E2=80=99s auto-update to function on m= acOS, we need to provide a zip installer that contains the pgAdmin 4.app.

If we maintain= zip installers for both arm64 and x86_64 macOS a= rchitectures, and potentially extend auto-update support to Windows in the = future, we estimate requiring up to 1.5 GB of additional storage on the FTP= server beyond the current allocation. Please note that we only need to sto= re the zip files for the latest version, as older versions will be updated = directly to the newest release.

Please share your suggestions on this.

Thanks,
Anil

On Wed, Mar 19, 2025 at 6:53=E2=80=AFPM= Anil Sahoo <anil.sahoo@enterprisedb.com> wrote:
Okay, I will implement it= as per the suggestions.

Thanks

On Wed, Mar 19, 202= 5 at 5:14=E2=80=AFPM Dave Page <dpage@pgadmin.org> wrote:


On W= ed, 19 Mar 2025 at 10:58, Anil Sahoo <anil.sahoo@enterprisedb.com> wrote:
= Hi Dave,

As discussed I moved with auto-update of pgAdmi= n 4 application in macOs system locally. It is successful.=C2=A0
= So now I have to do some additional user experience improvements.

Listing down some ways we can show the user that a new vers= ion is available and he can download and install it.

Option 1:=C2=A0
Show a dialog with the released features and fi= xes(mentioned in the release note) with "Download & Restart&quo= t; and "Cancel"=C2=A0 buttons. This dialog will be sho= wn only when the application starts for the first time of the day.

Benefits of showing this dialog will help us= ers to know about the new features and bugs fixed available in the latest v= ersion.=C2=A0

"Download & Restart&quo= t; button will download the latest version and quit the app and install and= open the latest app.=C2=A0"Cancel" will cancel the notificatio= n.
Option 2:<= /font>
We are currently showing a warning no= tification of the latest version available, if the older version is being u= sed by the user, we can add=C2=A0"Download & Restart" and "Cancel"=C2=A0 buttons. And those buttons will work = the way they are working in Option 1.

Additionally we will add "Check for updates" option i= n pgAdmin 4 native menu, if any time a user wants to check for updates manu= ally then can prefer this and if update is available then the=C2=A0<= span style=3D"font-family:"Helvetica Neue";font-size:13px">&qu= ot;Restart to update" option will show and if clicked will quit th= e app and install the latest version.

Let me know= in which way we can proceed.

Option 1 seems good to me; though the current notifier should continu= e to work as it does now if a particular distribution channel doesn't s= upport auto-updates (for example, the EDB PostgreSQL Installer).
= =C2=A0
--


--


=

Anil Sahoo

= Software Developmen= t Engineer II

LinkedIn=C2=A0|| Blog=C2= =A0|| GitHub


enterprisedb.com



--


=

Anil Sahoo

= Software Developmen= t Engineer II

LinkedIn=C2=A0|| Blog=C2= =A0|| GitHub


enterprisedb.com

--0000000000006e5a870632e2e2e4--