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 1u534q-00BLIX-B8 for pgadmin-hackers@arkaria.postgresql.org; Wed, 16 Apr 2025 13:45:21 +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 1u534n-00F9zS-Sq for pgadmin-hackers@arkaria.postgresql.org; Wed, 16 Apr 2025 13:45:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u534n-00F9uh-Bh for pgadmin-hackers@lists.postgresql.org; Wed, 16 Apr 2025 13:45:18 +0000 Received: from mail-lj1-x231.google.com ([2a00:1450:4864:20::231]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u534i-000OwX-2j for pgadmin-hackers@postgresql.org; Wed, 16 Apr 2025 13:45:17 +0000 Received: by mail-lj1-x231.google.com with SMTP id 38308e7fff4ca-30c2d427194so61529181fa.0 for ; Wed, 16 Apr 2025 06:45:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin.org; s=google; t=1744811113; x=1745415913; 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=vu3b7TVNmKSQQr39U8Lc97lx52jSIYjcf37RtfbtEM4=; b=Lq2Y9GA/5L9VZe6Mw0lMbs96U1xhM05lSUvzximnWEpEFFBIumz/cxVUx0zT7YdxPV IDiDiK4+IIl5qtYGEdfQx7Nflq2xXJQRbWgq0L7WS054bFv31RT3n/J3e8fchKBDAEnv h3YqkfgvuPsQynzgaTQpJmRAbi4f/o1ndOPv3LqtAXqCYut3TQRmqbID1blteqhToMjB Xs36h5Z+KU1Mfkv8wNJnmIQsgxniGBWTLfJMv/dqw3wST9xuA0xpvxHSbACazzOHl7lM ggXjfqizi8paA1oeBUtSv8OU/vtBo5/ne60N5n+/2WHTIhxXLstFhdukrspK3rGyFhGt GqBg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744811113; x=1745415913; 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=vu3b7TVNmKSQQr39U8Lc97lx52jSIYjcf37RtfbtEM4=; b=lzZfqs9GAl/xxGkpL7nJc9ThpyPbOC6LmVdTQwETb3e2ENqJ83oEDRFhl/h8Ppc59i taPkpyq4sMOj6nwBI0Eb/Nkx5PevLKfmFMr7cPToZHksTlJ4HKhZgzBFNhzp/PMbBk4d Z+1vBQ5nDmoHXY5qF7diPixHCaBbG7UbPUoQV6DhXIrpYGLxjVA3NvD1uAh7q0Ds28zC CR8zIB4AOqpSTW1QxCxtq2PQXD8SKfZ6Ktp3eIiae/sBMFecARWldRXjzcfjKIZ41+ot kr4rHBXbeRs3oqOVjjih49RZcaDa5rtcn9Ys+3na5eWpAFanxV+TYran3h72nw96v265 1cnA== X-Gm-Message-State: AOJu0Yy+rgDueeMVjzP1W0RrlYgfsQkbM9gG/F95T+0vqQMJ5ZFxEQ9v jmXm7hra3mzjC1Nlx9nz7e7nqV/gP2GskH032wuF+rTNhCNnvJtJhLNf8vMiI8YVfFFZbBIasau BV4nw9WxZp5CapNjID4wUfQLxwjbXcikvFF1c X-Gm-Gg: ASbGncvqaZ1fargmJ2JwVJ6vgcorSDP02cW/wvRtZMjDcnTITjjmRpbA4Nhy1RAQDDi 4rX3BwHM1fm/14kA/9UNn8m2+fhZoD3BJp/GBAMf56+sW3OtbdpRSjv1kektdLzzhwWvCRjtKGm +1fVmk47O9/CfylZpoKVp+88BR X-Google-Smtp-Source: AGHT+IGumF7LmTsg6ixhotbgclIfE5qW3SBD8V2SPjTJCYDoYJRwsFf4bG0g80k37Pc4hC6M9PpZwOWH4vCXOI0OHHo= X-Received: by 2002:a05:651c:1613:b0:30b:cd68:b69c with SMTP id 38308e7fff4ca-3107f694c85mr7999691fa.3.1744811112424; Wed, 16 Apr 2025 06:45:12 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dave Page Date: Wed, 16 Apr 2025 14:45:00 +0100 X-Gm-Features: ATxdqUEm_GPV0oroMuAZIYuQThcYA-mTJ_EGGvuMFdXnzgtIli5VVAYM-8KTO9s Message-ID: Subject: Re: Require suggestions on feature #5766 To: Anil Sahoo Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000008e8a500632e57e7a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008e8a500632e57e7a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi On Wed, 16 Apr 2025 at 11:38, Anil Sahoo wrote: > 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/down= load/=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 > } > } > } > Yes, that seems reasonable - except I'd keep the field names all in lower case. > 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 p= gAdmin > 4.app. > > If we maintain zip installers for both arm64 and x86_64 macOS > architectures, and potentially extend auto-update support to Windows in t= he > future, we estimate requiring up to 1.5 GB of additional storage on the F= TP > 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. > Do the zip files include the version number (and is that also included in the URLs above)? > 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 wr= ote: >> >>> >>> >>> 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 macO= s >>>> 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 fir= st >>>> time 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 th= en >>>> 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 >>> to work as it does now if a particular distribution channel doesn't sup= port >>> 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 >> > > > -- > > > *Anil Sahoo* > > Software Development Engineer II > > LinkedIn || Blog > || *GitHub > * > > enterprisedb.com > --=20 Dave Page pgAdmin: https://www.pgadmin.org PostgreSQL: https://www.postgresql.org pgEdge: https://www.pgedge.com --0000000000008e8a500632e57e7a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi

On Wed, 16 Apr 2025 at 11:38,= Anil Sahoo <anil.sahoo@e= nterprisedb.com> wrote:
<= p>Hi Dave,

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

Yes, that seems reasonable - except I'd keep the field = names all in lower case.
=C2=A0

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

Do the zip files include the version number (and is that also included in = the URLs above)?
=C2=A0
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, 2025 at 5:1= 4=E2=80=AFPM Dave Page <dpage@pgadmin.org> wrote:


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

As discussed I moved with auto-update of pgAdm= in 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 ver= sion is available and he can download and install it.

<= div>Option 1:=C2=A0
Show a dialog with the released features and f= ixes(mentioned in the release note) with "Download & Restart&qu= ot; and "Cancel"=C2=A0 buttons. This dialog will be sh= own only when the application starts for the first time of the day.<= /div>

Benefits of showing this dialog will help u= sers to know about the new features and bugs fixed available in the latest = version.=C2=A0

"Download & Restart&qu= ot; button will download the latest version and quit the app and install an= d open the latest app.=C2=A0"Cancel" will cancel the notificati= on.
Option 2:=
We are currently showing a warning n= otification of the latest version available, if the older version is being = used 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 = in pgAdmin 4 native menu, if any time a user wants to check for updates man= ually then can prefer this and if update is available then the=C2=A0= &q= uot;Restart to update" option will show and if clicked will quit t= he app and install the latest version.

Let me kno= w in which way we can proceed.

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


--


Anil Sahoo=

Software Develop= ment Engineer II

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


enterprisedb.com

<= /span>


--


Anil Sahoo=

Software Develop= ment Engineer II

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


enterprisedb.com

<= /span>


--
--0000000000008e8a500632e57e7a--