File added late

1 file was added to this release more than 14 days after its initial publication. Inspect the release files before installing.

Psycopg is the most popular PostgreSQL database adapter for the Python programming language. Its main features are the complete implementation of the Python DB API 2.0 specification and the thread safety (several threads can share the same connection). It was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a large number of concurrent “INSERT”s or “UPDATE”s.

Psycopg 2 is mostly implemented in C as a libpq wrapper, resulting in being both efficient and secure. It features client-side and server-side cursors, asynchronous communication and notifications, “COPY TO/COPY FROM” support. Many Python types are supported out-of-the-box and adapted to matching PostgreSQL data types; adaptation can be extended and customized thanks to a flexible objects adaptation system.

Psycopg 2 is both Unicode and Python 3 friendly.

Documentation

Documentation is included in the doc directory and is available online.

For any other resource (source code repository, bug tracker, mailing list) please check the project homepage.

Installation

Building Psycopg requires a few prerequisites (a C compiler, some development packages): please check the install and the faq documents in the doc dir or online for the details.

If prerequisites are met, you can install psycopg like any other Python package, using pip to download it from PyPI:

$ pip install psycopg2

or using setup.py if you have downloaded the source package locally:

$ python setup.py build
$ sudo python setup.py install

You can also obtain a stand-alone package, not requiring a compiler or external libraries, by installing the psycopg2-binary package from PyPI:

$ pip install psycopg2-binary

The binary package is a practical choice for development and testing but in production it is advised to use the package built from sources.

Linux/OSX:

Linux and OSX build status

Windows:

Windows build status

Project links

Data verified by PyPI on Oct 16, 2024
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
  • Last file added:
Newer release available (2.9.13) File added late

2 maintainers

PyPI data
Data sourced directly from PyPI's database.
Avatar for jerickso from gravatar.com jerickso Avatar for piro from gravatar.com piro

Credits

Author: Federico Di Gregorio

Maintainer: Daniele Varrazzo

License

GNU Library or Lesser General Public License (LGPL) (LGPL with exceptions)

Requires

Python >=3.8

Classifiers

Report project as malware

Release files for psycopg2 2.9.10

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

File added late

1 file was uploaded more than 14 days after the first file in this release.

While project maintainers occasionally add legitimate files to an existing release, late additions can also indicate a security compromise.

We recommend inspecting the release files before installing.

Source distribution (sdist)

Source distribution for psycopg2 2.9.10
File Size Uploaded
psycopg2-2.9.10.tar.gz 385.7 kB Details

Built distributions (wheels)

Table of built distributions (wheels) for psycopg2 2.9.10
File
psycopg2-2.9.10-cp313-cp313-win_amd64.whl 2.6 MB CPython 3.13 CPython 3.13 Windows x86-64 Details
psycopg2-2.9.10-cp312-cp312-win_amd64.whl 1.2 MB CPython 3.12 CPython 3.12 Windows x86-64 Details
psycopg2-2.9.10-cp312-cp312-win32.whl 1.0 MB CPython 3.12 CPython 3.12 Windows x86-32 Details
psycopg2-2.9.10-cp311-cp311-win_amd64.whl 1.2 MB CPython 3.11 CPython 3.11 Windows x86-64 Details
psycopg2-2.9.10-cp311-cp311-win32.whl 1.0 MB CPython 3.11 CPython 3.11 Windows x86-32 Details
psycopg2-2.9.10-cp310-cp310-win_amd64.whl 1.2 MB CPython 3.10 CPython 3.10 Windows x86-64 Details
psycopg2-2.9.10-cp310-cp310-win32.whl 1.0 MB CPython 3.10 CPython 3.10 Windows x86-32 Details
psycopg2-2.9.10-cp39-cp39-win_amd64.whl 1.2 MB CPython 3.9 CPython 3.9 Windows x86-64 Details
psycopg2-2.9.10-cp39-cp39-win32.whl 1.0 MB CPython 3.9 CPython 3.9 Windows x86-32 Details

Total release size: 11.7 MB

Release files / psycopg2-2.9.10.tar.gz

Download URL psycopg2-2.9.10.tar.gz
Size 385.7 kB
Tags Source
SHA-256 checksum
How to use checksums 		12ec0b40b0273f95296233e8750441339298e6a572f7039da5b260e3c8b60e11
BLAKE2b-256 checksum
How to use checksums 		62512007ea29e605957a17ac6357115d0c1a1b60c8c984951c19419b3474cdfd
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		No
Uploaded via twine/4.0.2 CPython/3.10.12

Release files / psycopg2-2.9.10-cp313-cp313-win_amd64.whl

File added late

This file was uploaded more than 14 days after the first file in this release.

While project maintainers occasionally add legitimate files to an existing release, late additions can also indicate a security compromise.

We recommend inspecting the release file before installing.

Download URL psycopg2-2.9.10-cp313-cp313-win_amd64.whl
Size 2.6 MB
Tags CPython 3.13 Windows x86-64
SHA-256 checksum
How to use checksums 		91fd603a2155da8d0cfcdbf8ab24a2d54bca72795b90d2a3ed2b6da8d979dee2
BLAKE2b-256 checksum
How to use checksums 		ae49a6cfc94a9c483b1fa401fbcb23aca7892f60c7269c5ffa2ac408364f80dc
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		No
Uploaded via twine/4.0.2 CPython/3.10.12

Release files / psycopg2-2.9.10-cp312-cp312-win_amd64.whl

Download URL psycopg2-2.9.10-cp312-cp312-win_amd64.whl
Size 1.2 MB
Tags CPython 3.12 Windows x86-64
SHA-256 checksum
How to use checksums 		4a579d6243da40a7b3182e0430493dbd55950c493d8c68f4eec0b302f6bbf20e
BLAKE2b-256 checksum
How to use checksums 		66debaed128ae0fc07460d9399d82e631ea31a1f171c0c4ae18f9808ac6759e3
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		No
Uploaded via twine/4.0.2 CPython/3.10.12

Release files / psycopg2-2.9.10-cp312-cp312-win32.whl

Download URL psycopg2-2.9.10-cp312-cp312-win32.whl
Size 1.0 MB
Tags CPython 3.12 Windows x86-32
SHA-256 checksum
How to use checksums 		65a63d7ab0e067e2cdb3cf266de39663203d38d6a8ed97f5ca0cb315c73fe067
BLAKE2b-256 checksum
How to use checksums 		3d164623fad6076448df21c1a870c93a9774ad8a7b4dd1660223b59082dd8fec
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		No
Uploaded via twine/4.0.2 CPython/3.10.12

Release files / psycopg2-2.9.10-cp311-cp311-win_amd64.whl

Download URL psycopg2-2.9.10-cp311-cp311-win_amd64.whl
Size 1.2 MB
Tags CPython 3.11 Windows x86-64
SHA-256 checksum
How to use checksums 		0435034157049f6846e95103bd8f5a668788dd913a7c30162ca9503fdf542cb4
BLAKE2b-256 checksum
How to use checksums 		33395a9a229bb5414abeb86e33b8fc8143ab0aecce5a7f698a53e31367d30caa
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		No
Uploaded via twine/4.0.2 CPython/3.10.12

Release files / psycopg2-2.9.10-cp311-cp311-win32.whl

Download URL psycopg2-2.9.10-cp311-cp311-win32.whl
Size 1.0 MB
Tags CPython 3.11 Windows x86-32
SHA-256 checksum
How to use checksums 		47c4f9875125344f4c2b870e41b6aad585901318068acd01de93f3677a6522c2
BLAKE2b-256 checksum
How to use checksums 		20a2c51ca3e667c34e7852157b665e3d49418e68182081060231d514dd823225
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		No
Uploaded via twine/4.0.2 CPython/3.10.12

Release files / psycopg2-2.9.10-cp310-cp310-win_amd64.whl

Download URL psycopg2-2.9.10-cp310-cp310-win_amd64.whl
Size 1.2 MB
Tags CPython 3.10 Windows x86-64
SHA-256 checksum
How to use checksums 		c6f7b8561225f9e711a9c47087388a97fdc948211c10a4bccbf0ba68ab7b3b5a
BLAKE2b-256 checksum
How to use checksums 		4750c509e56f725fd2572b59b69bd964edaf064deebf1c896b2452f6b46fdfb3
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		No
Uploaded via twine/4.0.2 CPython/3.10.12

Release files / psycopg2-2.9.10-cp310-cp310-win32.whl

Download URL psycopg2-2.9.10-cp310-cp310-win32.whl
Size 1.0 MB
Tags CPython 3.10 Windows x86-32
SHA-256 checksum
How to use checksums 		5df2b672140f95adb453af93a7d669d7a7bf0a56bcd26f1502329166f4a61716
BLAKE2b-256 checksum
How to use checksums 		0aa9146b6bdc0d33539a359f5e134ee6dda9173fb8121c5b96af33fa299e50c4
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		No
Uploaded via twine/4.0.2 CPython/3.10.12

Release files / psycopg2-2.9.10-cp39-cp39-win_amd64.whl

Download URL psycopg2-2.9.10-cp39-cp39-win_amd64.whl
Size 1.2 MB
Tags CPython 3.9 Windows x86-64
SHA-256 checksum
How to use checksums 		88138c8dedcbfa96408023ea2b0c369eda40fe5d75002c0964c78f46f11fa442
BLAKE2b-256 checksum
How to use checksums 		2cf80be7d99d24656b689d83ac167240c3527efb0b161d814fb1dd58329ddf75
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		No
Uploaded via twine/4.0.2 CPython/3.10.12

Release files / psycopg2-2.9.10-cp39-cp39-win32.whl

Download URL psycopg2-2.9.10-cp39-cp39-win32.whl
Size 1.0 MB
Tags CPython 3.9 Windows x86-32
SHA-256 checksum
How to use checksums 		9d5b3b94b79a844a986d029eee38998232451119ad653aea42bb9220a8c5066b
BLAKE2b-256 checksum
How to use checksums 		5f29bc9639b9c50abd93a8274fd2deffbf70b2a65aa9e7881e63ea6bc4319e84
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing? 		No
Uploaded via twine/4.0.2 CPython/3.10.12

Release history Release notifications | RSS feed

2.9.13

7 release files

2.9.12

7 release files

2.9.11

7 release files

This release

2.9.10 This release

10 release files

2.9.9

13 release files

2.9.8

11 release files

2.9.7

11 release files

2.9.6

13 release files

2.9.5

13 release files

2.9.4

11 release files

2.9.3

11 release files

2.9.2

11 release files

2.9.1

11 release files

2.9

9 release files

2.8.6

15 release files

2.8.5

13 release files

2.8.4

13 release files

2.8.3

11 release files

2.8.2

11 release files

2.8.1

11 release files

2.8

11 release files

2.7.7

30 release files

2.7.6.1

30 release files

2.7.6

30 release files

2.7.5

30 release files

2.7.4

27 release files

2.7.3.2

31 release files

2.7.3.1

31 release files

2.7.3

31 release files

2.7.2

31 release files

2.7.1

31 release files

2.7

31 release files

2.6.2

15 release files

2.6.1

11 release files

2.6

1 release file

2.5.5

1 release file

2.5.4

1 release file

2.5.3

1 release file

2.5.2

1 release file

2.5.1

1 release file

2.5

1 release file

2.4.6

1 release file

2.4.5

1 release file

2.4.4

1 release file

2.4.3

1 release file

2.4.2

1 release file

2.4.1

1 release file

2.4

1 release file

2.3.2

1 release file

2.3.1

1 release file

2.3.0

1 release file

2.2.2

1 release file

2.2.1

1 release file

2.2.0

1 release file

2.0.14

1 release file

2.0.13

1 release file

2.0.12

1 release file

2.0.11

1 release file

2.0.10

1 release file

2.0.8

2.0.7

2.0.6

2.0.5.1

2.0.4

2.0.3

2.0.2

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page