If you use Python and PostgreSQL, and you would like to support the creation of the most advanced adapter between the two systems, please consider becoming a sponsor.
Sponsoring this project will help achieve swift completion and ensure the maintenance of psycopg2, psycopg3 and other related projects.
If you are interested in contributing to the maintenance of the project, please reach out. Thank you!
Psycopg is released under the terms of the GNU Lesser General Public License, allowing use from both free and proprietary software.
- Check the features list and comparison to see what Psycopg offers.
- Read the Psycopg 2 or Psycopg 3 documentation.
- Install Psycopg!
For help requests and development discussions please subscribe to the mailing list psycopg@postgresql.org.
Latest articles
Psycopg 3.2 released
Posted by Daniele Varrazzo on 2024-06-30
Tagged as
news,
release
It was quite the ride! But we made it!
After almost two years, 846 commits, more than 700 new tests, more than 20000 changes in 310 files (I didn't even realise that there were 310 files in this project...) Psycopg 3.2 has been released!
This release brings a few new feature and hopefully no meaningful non-backward compatible change. The whole list of changes is available in the changelog; these are some of the major points explained.
Pipeline mode in Psycopg
Posted by Denis Laxalde on 2024-05-08
Tagged as
psycopg3,
development
Version 3.1 of Psycopg added support for libpq pipeline mode, bringing significant performance boost, especially when network latency is important. In this article, we’ll briefly describe how it works from users’ perspective and under the hood while also providing a few implementation details.
Psycopg 3.1 released
Posted by Daniele Varrazzo on 2022-08-30
Tagged as
news,
release
Hello,
After several months of development, we are proud to release Psycopg 3.1!
Psycopg 3.1 is a gradual improvement on Psycopg 3.0, introducing new exciting features, redefining what can be done on the boundary between Python and PostgreSQL.