Re: Dependencies, and upcoming changes to pip

From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: Shaheed Haque <shaheedhaque(at)gmail(dot)com>
Cc: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Dependencies, and upcoming changes to pip
Date: 2020-12-14 07:05:52
Message-ID: CANxoLDdXfah91mLbrkZQwRyZ=XNFH8CP1-SsrRKoU3=BjRFpGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Thanks, Shaheed

Updated the version.

On Sat, Dec 12, 2020 at 5:24 PM Shaheed Haque <shaheedhaque(at)gmail(dot)com>
wrote:

> This has been released. Please consider relaxing your dependencies
> accordingly...
>
> On Wed, 2 Dec 2020 at 10:04, Shaheed Haque <shaheedhaque(at)gmail(dot)com> wrote:
>
>> It looks like pgcli has changed (https://github.com/dbcli/pgcli/pull/1224)
>> ahead of the upcoming pip 21 release (but I'm not sure what their release
>> plans are).
>>
>> On Tue, 20 Oct 2020 at 23:28, Shaheed Haque <shaheedhaque(at)gmail(dot)com>
>> wrote:
>>
>>> Ok, thanks for the update!
>>>
>>> On Tue, 20 Oct 2020 at 08:11, Akshay Joshi <
>>> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>>
>>>> Hi Shaheed
>>>>
>>>> On Tue, Oct 20, 2020 at 12:09 AM Shaheed Haque <shaheedhaque(at)gmail(dot)com>
>>>> wrote:
>>>>
>>>>> Hi Akshay,
>>>>>
>>>>> I noticed that pgAdmin 4.27 updated the dependencies a bit, for which
>>>>> many thanks. The current situation from my perspective is not quite all
>>>>> roses yet because I get this:
>>>>>
>>>>> ERROR: After October 2020 you may experience errors when installing or
>>>>> updating packages. This is because pip will change the way that it resolves
>>>>> dependency conflicts.
>>>>>
>>>>> We recommend you use --use-feature=2020-resolver to test your packages
>>>>> with the new resolver before it becomes the default.
>>>>>
>>>>> pgadmin4 4.27 requires sqlparse<0.4,>=0.3.0, but you'll have sqlparse
>>>>> 0.4.1 which is incompatible.
>>>>>
>>>>> From reviewing the sqlparse change log, I presume the reason pgAdmin
>>>>> wants <0.4 is to preserve support for Python 3.4? I'll need to adapt my
>>>>> installer to deal with pgAdmin separately...unless you are planning to
>>>>> require Python 3.5 and so relax the <0.4 constraint sometime soon.
>>>>>
>>>>> Is that likely (or should I plan to make the changes)?
>>>>>
>>>>> Any input appreciated.
>>>>>
>>>>
>>>> We have used *pgcli* code for autocompletion in pgAdmin4 and we
>>>> pick this setting from
>>>> https://github.com/dbcli/pgcli/blob/master/setup.py. As they haven't
>>>> tested their code with the latest version of sqlparse we should not change
>>>> it.
>>>>
>>>>>
>>>>> Thanks, Shaheed
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Wed, 30 Sep 2020 at 10:27, Akshay Joshi <
>>>>> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>>>>
>>>>>> Thanks, Shaheed for pointing it out, we will definitely look into it.
>>>>>>
>>>>>> On Tue, Sep 29, 2020 at 6:08 PM Shaheed Haque <shaheedhaque(at)gmail(dot)com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> I've long wondered why pgAdmin4 seems to hard pin its dependencies;
>>>>>>> specifically these two which do seem rather outdated:
>>>>>>>
>>>>>>> pgadmin4 4.26 requires pytz==2018.9, but you'll have pytz 2020.1
>>>>>>> which is incompatible.
>>>>>>> pgadmin4 4.26 requires sqlparse==0.2.4, but you'll have sqlparse
>>>>>>> 0.3.1 which is incompatible.
>>>>>>>
>>>>>>> So far, I've just ignored this , and as far as I know, I have not
>>>>>>> encountered any obvious issues. But, with the upcoming changes to pip's
>>>>>>> resolver, I suspect this is going to become a hard error for me as I
>>>>>>> believe the new resolver will simply abort the install in such cases:
>>>>>>>
>>>>>>> ERROR: After October 2020 you may experience errors when installing
>>>>>>> or updating packages. This is because pip will change the way that it
>>>>>>> resolves
>>>>>>> dependency conflicts.
>>>>>>>
>>>>>>> We recommend you use --use-feature=2020-resolver to test your
>>>>>>> packages with the new resolver before it becomes the default.
>>>>>>>
>>>>>>> So, I'd like to request that any unneeded constraints are either
>>>>>>> removed, or relaxed, or at least updated to something close to current.
>>>>>>>
>>>>>>> Thanks, Shaheed
>>>>>>>
>>>>>>> P.S. We understand about venvs, but we have a whole bunch of
>>>>>>> dependencies beyond pgAdmin and having to set up multiple venvs to isolate
>>>>>>> everything is a deployment-time overhead we prefer to avoid.
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> *Thanks & Regards*
>>>>>> *Akshay Joshi*
>>>>>> *pgAdmin Hacker | Sr. Software Architect*
>>>>>> *EDB Postgres <http://edbpostgres.com>*
>>>>>>
>>>>>> *Mobile: +91 976-788-8246*
>>>>>>
>>>>>
>>>>
>>>> --
>>>> *Thanks & Regards*
>>>> *Akshay Joshi*
>>>> *pgAdmin Hacker | Sr. Software Architect*
>>>> *EDB Postgres <http://edbpostgres.com>*
>>>>
>>>> *Mobile: +91 976-788-8246*
>>>>
>>>

--
*Thanks & Regards*
*Akshay Joshi*
*pgAdmin Hacker | Principal Software Architect*
*EDB Postgres <http://edbpostgres.com>*

*Mobile: +91 976-788-8246*

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Shaheed Haque 2020-12-15 02:24:37 Re: Dependencies, and upcoming changes to pip
Previous Message Aditya Toshniwal 2020-12-14 05:42:29 Re: insert sql generated from pgAdmin