Hello, I have implemented a backend to enable Django to use PostgreSQL using Psycopg 3.
The backend is currently implemented as an external module [1] requiring a few modifications to Django [2] to successfully run the whole Django test suite. Most of the changes are import-related (breaking the assumption that "psycopg2" is always present if you are talking to PostgreSQL); a few changes are more interesting, because they show the difference in the database behaviour moving from client-side to server-side parameters passing. I have written an article explaining the changes needed [3] which you might find useful. [1] https://github.com/dvarrazzo/django-psycopg3-backend [2] https://github.com/django/django/compare/stable/3.2.x...dvarrazzo:psycopg3-support [3] https://www.psycopg.org/articles/2021/08/02/psycopg3-django-driver/ The next step, on this front, will be to liaise with the Django project and understand if there is interest in accepting the changes (I hope so) and whether the changes need to be adapted to better suit the Django project. On the Psycopg 3 front, I would say that supporting the whole Django test suite is a good maturity test of which I am very happy. I am completing a final review looking for missing bits (verifying that the tests in the psycopg2 test suite have an equivalent in Psycopg 3), after which we can release a package with hopefully the definitive adapter interface. Thank you very much for your support. I hope that this work will be useful for everyone. -- Daniele
