Postgres Professional has become one of the main sponsors backing the development of the Psycopg library, the most popular PostgreSQL adapter for the Python programming language.
Maintaining the spirit of open source development, we are investing in this project to help Daniele Varrazzo and the Psycopg collaborators deliver the next major version of Psycopg -- free and open for the entire PostgreSQL community.
“I am very excited to collaborate with Postgres Professional, a company that has brought amazing innovations to PostgreSQL,” says Daniele. “They are continually expanding the possibilities of the database, most recently with their research on JSON. In these areas, a closer collaboration between server and client will be extremely beneficial.”
Python, now the most popular programming language in the world, is used to manipulate files, interact with web services, perform complex math, handle big data and train neural networks, rapidly prototype production clusters, and so much more. Simply put, Python is everywhere.
However, if you need to connect a database to your pattern of data flow, you will need an adapter. The Python world has used Psycopg2, a fast and reliable connector module, for the past 15 years, and it has evolved along with the major Python milestones, such as the move to Python 3 and the popularization of Unicode. It has provided a smooth flow of data from Python objects to PostgreSQL types.
Today, new challenges require a major redesign of the adapter architecture. Psycopg3 offers a smooth upgrade path to embrace the new offerings from the latest Python versions, especially asyncio and other IO-bound concurrency frameworks, which help to make the most of your hardware in concurrent scenarios. The interaction with the database has also been completely redesigned to make use of prepared statements, binary parameters and asynchronous communication.
We have been watching the growth of the Psycopg project for years and expect to see an increase in its adoption in the future. Psycopg is released under the terms of the GNU Lesser General Public License, allowing use by both free and proprietary software. If you are interested in more detailed information on Psycopg, visit the project’s website: https://www.psycopg.org/