search

fractal-analytics-platform / fractal-server

Fractal backend
https://fractal-analytics-platform.github.io/fractal-server/
BSD 3-Clause "New" or "Revised" License
11 stars 3 forks source link

Deprecate psycopg2+asyncpg postgres adapter #1821

Open tcompa opened 2 weeks ago

tcompa commented 2 weeks ago

The new psycopg3-based adapter is supported and tested since fractal-server v2.2.0 (ref https://github.com/fractal-analytics-platform/fractal-server/issues/996). It is also in-use in fractal-web CI (ref https://github.com/fractal-analytics-platform/fractal-web/issues/515) and fractal-containers automated tests (ref https://github.com/fractal-analytics-platform/fractal-containers/issues/43) and fractal-client tests as well. It's also in production in one instance, and I moved another instance to it as of this morning.

This is not urgent, but as soon as all production instances are on the new adapter we can start some grace time and eventually remove support for the old one.

Update instructions:

tcompa commented 1 week ago

Another instance was updated to pyscopg3. With https://github.com/fractal-analytics-platform/fractal-server/commit/75de046186309f2ef037032f942cee7892b4467d we started removing one entry from the CI (old postgres adapter and python 3.9).

tcompa commented 6 days ago

When we do this deprecation, let's simplify the naming for pip extra and for DB_ENGINE variable.