Re: Require suggestions on feature #5766 - Mailing list pgadmin-hackers

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:

{

  “edb-pgadmin4”: {
    “version”: “9.0”,
    “version_int”: 90000,
    “download_url”: “https://www.enterprisedb.com/downloads/postgres-postgresql-downloads”,
    “auto_update_url”: {
        “macOS”: “<edb_installer_url>“,
        “windows”: “<edb_installer_url>”
   }
  },
  “pgadmin4”: {
    “version”: “9.2”,
    “version_int”: 90200,
    “download_url”: “https://www.pgadmin.org/download/”,
    “auto_update_url”: {
        “macOS”: “https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v9.2/macos/”,
        “windows”: “https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v9.2/windows/”
   }
  }
}

Additionally, as I mentioned earlier, for Electron’s 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 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 PM Anil Sahoo <anil.sahoo@enterprisedb.com> wrote:

Okay, I will implement it as per the suggestions.

Thanks

On Wed, Mar 19, 2025 at 5:14 PM 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 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 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 then 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 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

--

Anil Sahoo Software Development Engineer II LinkedIn || Blog || GitHub enterprisedb.com