Hi Dave,
Yes zip files will have the version number, here is an
example: pgadmin4-9.2-arm64.zip.
Yes, version number will be included in the earlier mentioned URL.
Also I will keep the field names in lower case.
Thanks
On Wed, Apr 16, 2025 at 7:15 PM Dave Page <dp...@pgadmin.org> wrote:
> 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
>
>
--
*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
