Hi
On Wed, 16 Apr 2025 at 11:38, Anil Sahoo <anil.sa...@enterprisedb.com>
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:*
>
> {
>
> “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/”
> }
> }
> }
>
Yes, that seems reasonable - except I'd keep the field names all in lower
case.
> 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.
>
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 PM Anil Sahoo <anil.sa...@enterprisedb.com>
> wrote:
>
>> Okay, I will implement it as per the suggestions.
>>
>> Thanks
>>
>> On Wed, Mar 19, 2025 at 5:14 PM Dave Page <dp...@pgadmin.org> wrote:
>>
>>>
>>>
>>> On Wed, 19 Mar 2025 at 10:58, Anil Sahoo <anil.sa...@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 <https://www.linkedin.com/in/anilksahoo9/> || Blog
>> <https://www.enterprisedb.com/anil-sahoo> || *GitHub
>> <https://github.com/anilsahoo20>*
>>
>> enterprisedb.com
>>
>
>
> --
>
>
> *Anil Sahoo*
>
> Software Development Engineer II
>
> LinkedIn <https://www.linkedin.com/in/anilksahoo9/> || Blog
> <https://www.enterprisedb.com/anil-sahoo> || *GitHub
> <https://github.com/anilsahoo20>*
>
> enterprisedb.com
>
--
Dave Page
pgAdmin: https://www.pgadmin.org
PostgreSQL: https://www.postgresql.org
pgEdge: https://www.pgedge.com
