Possibility to upgrade version of pip?

[makesbuckets]

First off... tremendous project here! It's been straightforward to get up and running so far, much appreciated.

I was looking to try and install libs like pandas and psycopg2 and went through the instructions go generating the embedded files. I was successful with the instructions to install a simpler lib like python-dotenv, however I am finding myself stuck with these other libs.

The general error message I see looks like:

ERROR: Could not find a version that satisfies the requirement psycopg2 (from versions: none)
ERROR: No matching distribution found for psycopg2

Somehow this error feels flaky at times. I've never seen go generate ./... succeed when including psycopg2 (and usually that failure is accompanied by this error message a few times). I have seen generate succeed when it was just pandas listed in requirements.txt, even though that same error message would pop up (but re: pandas instead of psycopg2).

The other warning I'll mention as possible context here is I also see the output:

[notice] A new release of pip is available: 23.0 -> 23.1.2
[notice] To update, run: /tmp/python-pip-darwin-amd64-macosx_11_0_x86_64/bin/python3 -m pip install --upgrade pip

And noticed that here seems to be where the version is fixed to 23.0.

I guess a few questions:

• is it possible that it's just as simple as "use the latest pip and be able to install all these packages"?
• is there some other underlying reason I can't use the psycopg2 lib?
• is there a way quiet down the "No matching distribution..." error logs when they are non-fatal?