One of the most common mistakes when working with large datasets in PostgreSQL is fetching everything into memory at once. It is the path of least resistance: you write your query, call fetchall(), and iterate over the results. For small da…
The most popular PostgreSQL adapter for Python A complete implementation of the Python DB API 2.0 specification, built on top of the official PostgreSQL client library, with many extensions giving access to the full power of modern Python a…
FastAPI is currently the established framework to write a REST API in Python. Its clever use of dependency injections and static typing makes developing web services a breeze, using a minimal amount of code and a clean and consistent archit…
The most popular PostgreSQL adapter for Python A complete implementation of the Python DB API 2.0 specification, built on top of the official PostgreSQL client library, with many extensions giving access to the full power of modern Python a…
We have released Psycopg 3.3 - and you should be excited about it! This version lets you take advantage of one of the biggest innovation in Python 3.14: the template strings, which allow you to write expressive and safe queries. How does it…
Psycopg 3 provides both a sync and an async Python interface: for each object used to perform I/O operations, such as Connection, Cursor, there is an async counterpart: AsyncConnection, AsyncCursor, with an intuitive interface: just add the…
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 h…
We are immensely proud to release on PyPI the first beta package of Psycopg 3! Psycopg 3 is a complete rewrite of Psycopg 2, maintaining the same fundamental libpq wrapper architecture and DB-API interface design, but exposing new features
This is a relatively small release compared to previous major releases. However the creation of the packages took a lot of effort. The previously used CI system now has reduced support for free software projects - it was decided that packag…
Following the release of PostgreSQL 10 we have released new binary packages as Psycopg 2.7.3.2. There are no code changes from Psycopg 2.7.3, but the new binary packages ship with the PostgreSQL 10 client library, enabling the use of new fe…
Cancelling a long running query from Python is not something that happens automatically: the libpq doesn't react to Python signals so the only way to stop a query is to run a pg_cancel_backend from another process. Killing the Python proces…
I'm happy to announce the release of Psycopg 2.4.6: a huge thank you to the many contributors. This is a bugfix release, introducing no new feature. There are several small corrections in different areas (copy, adaptation, use of extra curs…