You can use boolean logic (e.g. AND/OR/NOT) for complex search queries. For more help and examples, see the search documentation.
Search by package name:
my-package (implicit)
name:my-package (explicit)
Search by package filename:
my-package.ext (implicit)
filename:my-package.ext (explicit)
Search by package tag:
latest (implicit)
tag:latest (explicit)
Search by package version:
1.0.0 (implicit)
version:1.0.0 (explicit)
prerelease:true (prereleases)
prerelease:false (no prereleases)
Search by package architecture:
architecture:x86_64
Search by package distribution:
distribution:el
Search by package license:
license:MIT
Search by package format:
format:deb
Search by package status:
status:in_progress
Search by package file checksum:
checksum:5afba
Search by package security status:
severity:critical
Search by package vulnerabilities:
vulnerabilities:>1
vulnerabilities:<1000
Search by # of package downloads:
downloads:>8
downloads:<100
Search by package type:
type:binary
type:source
Search by package size (bytes):
size:>50000
size:<10000
Search by dependency name/version:
dependency:log4j
dependency:log4j=1.0.0
dependency:log4j>1.0.0
Search by uploaded date:
uploaded:>"1 day ago"
uploaded:<"August 14, 2022 EST"
Search by entitlement token (identifier):
entitlement:3lKPVJPosCsY
Search by policy violation:
policy_violated:true
deny_policy_violated:true
license_policy_violated:true
vulnerability_policy_violated:true
Search by repository:
repository:repo-name
Search queries for all Debian-specific (and related) package types
Search by component:
deb_component:unstable
Search queries for all Maven-specific (and related) package types
Search by group ID:
maven_group_id:org.apache
Search queries for all Docker-specific (and related) package types
Search by image digest:
docker_image_digest:sha256:7c5..6d4
(full hashref only)
Search by layer digest:
docker_layer_digest:sha256:4c4..ae4
(full hashref only)
Field type modifiers (depending on the type, you can influence behaviour)
For all queries, you can use:
~foo for negation
For string queries, you can use:
^foo to anchor to start of term
foo$ to anchor to end of term
foo*bar for fuzzy matching
For number/date or version queries, you can use:
>foo for values greater than
>=foo for values greater / equal
<foo for values less than
<=foo for values less / equal
Need a secure and centralised artifact repository to deliver Alpine,
Cargo,
CocoaPods,
Composer,
Conan,
Conda,
CRAN,
Dart,
Debian,
Docker,
Go,
Helm,
Hex,
LuaRocks,
Maven,
npm,
NuGet,
P2,
Python,
RedHat,
Ruby,
Swift,
Terraform,
Vagrant,
Raw & More packages?
Cloudsmith is the new standard in Package / Artifact Management and Software Distribution.
With support for all major package formats, you can trust us to manage your software supply chain.
agriconnect
psycopg2-binary
2.7.6.1
One-liner (summary)
Description
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: |  |
|---|---|
| Windows: |
| Status | Completed |
|---|---|
| Checksum (MD5) | 785636c5495014870078917ce95d93f1 |
| Checksum (SHA-1) | 7e553b7f90e0bc326bf27371ef0b09908caa80d0 |
| Checksum (SHA-256) | 08769e17c764a54d3cba5b2ba6a73ca986cf2e561b57e97df6d28437ad6b8a26 |
| Checksum (SHA-512) | f5305c62fc0f146df1660a4f3dfb600f38e37c0a444f3574c820af70976a3ad246… |
| GPG Signature | |
| Storage Region | Dublin, Ireland |
| Type | Binary (contains binaries and binary artifacts) |
| Uploaded At | 5 years, 5 months ago |
| Uploaded By |
|
| Slug Id | psycopg2_binary-2761-cp36-cp36m-linux_armv7lwhl |
| Unique Id | 4g3y8kNBfMmh |
| Version (Raw) | 2.7.6.1 |
| Version (Parsed) |
|
| extended metadata | |
| Abi | cp36m |
| Author | Federico Di Gregorio <fog@initd.org> |
| Classifiers | Development Status :: 5 - Production/Stable | Intended Audience :: Developers | License :: OSI Approved :: GNU Library or Lesser General Public License (LGPL) | License :: OSI Approved :: Zope Public License | Operating System :: Microsoft :: Windows | Operating System :: Unix | Programming Language :: C | Programming Language :: Python | Programming Language :: Python :: 2 | Programming Language :: Python :: 2.6 | Programming Language :: Python :: 2.7 | Programming Language :: Python :: 3 | Programming Language :: Python :: 3.2 | Programming Language :: Python :: 3.3 | Programming Language :: Python :: 3.4 | Programming Language :: Python :: 3.5 | Programming Language :: Python :: 3.6 | Programming Language :: Python :: 3.7 | Programming Language :: Python :: Implementation :: CPython | Programming Language :: SQL | Topic :: Database | Topic :: Database :: Front-Ends | Topic :: Software Development | Topic :: Software Development :: Libraries :: Python Modules |
| Download URL | http://initd.org/psycopg/tarballs/PSYCOPG-2-7/psycopg2-2.7.6.1.tar.gz |
| Homepage URL | http://initd.org/psycopg/ |
| Metadata Version | 2.1 |
| Platforms | any |
| Py Filetype | bdist_wheel |
| Py Version | cp36 |
| pkg | psycopg2_binary-2.7.6.1-cp36-cp… |
88
458.6 KB |
md5 | sha1 | sha256 | sha512 |
This package has 51 files/directories.
| Newer |
|
psycopg2-binary |
70 |
|
||
|
|
psycopg2-binary |
88 |
|
Security Scanning:
You can't see this because your subscription doesn't include this feature, sorry!
With Security Scanning, Cloudsmith will scan your artifacts for vulnerabilities when they're uploaded. These are then presented to you via the UI and the API, so that you can build rules into your CI/CD pipelines to decide how to handle low, medium, high and critical software vulnerabilities.
If you'd like to trial or ask about the Security Scanning feature, just ask us. We'll be happy to help!
Last scanned
an hour ago
Scan result
Vulnerable
Vulnerability count
5
Max. severity
Critical| Target: | ||
| CRITICAL |
CVE-2711-39099: library: vulnerability titlePackage Name: package_name Installed Version: 1.2.42 Fixed Version: 2.7.75 References: www.payne.com clark-davis.com www.allen.com |
|
| HIGH |
CVE-7907-79016: library: vulnerability titlePackage Name: package_name Installed Version: 1.5.67 Fixed Version: 2.3.62 References: allen.info www.aguirre.com middleton.com |
|
| HIGH |
CVE-6609-30670: library: vulnerability titlePackage Name: package_name Installed Version: 1.5.93 Fixed Version: 2.3.67 References: carter-miller.com morse.biz valencia.org |
|
| MEDIUM |
CVE-3106-32910: library: vulnerability titlePackage Name: package_name Installed Version: 1.3.2 Fixed Version: 2.7.55 References: www.espinoza-spence.org roy-smith.com www.mccormick.com |
|
| MEDIUM |
CVE-9048-74948: library: vulnerability titlePackage Name: package_name Installed Version: 1.3.92 Fixed Version: 2.5.91 References: martin.com sharp-smith.com hunter.com |
|
You can embed a badge in another website that shows this or the latest version of this package.
To embed the badge for this specific package version, use the following:
[](https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/psycopg2-binary/2.7.6.1/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/)|This version of 'psycopg2-binary' @ Cloudsmith|
.. |This version of 'psycopg2-binary' @ Cloudsmith| image:: https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/psycopg2-binary/2.7.6.1/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/?render=true
:target: https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/psycopg2-binary/2.7.6.1/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/image::https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/psycopg2-binary/2.7.6.1/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/?render=true[link="https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/psycopg2-binary/2.7.6.1/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/",title="This version of 'psycopg2-binary' @ Cloudsmith"]<a href="https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/psycopg2-binary/2.7.6.1/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/"><img src="https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/psycopg2-binary/2.7.6.1/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/?render=true" alt="This version of 'psycopg2-binary' @ Cloudsmith" /></a>rendered as:
To embed the badge for the latest package version, use the following:
[](https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/psycopg2-binary/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/)|Latest version of 'psycopg2-binary' @ Cloudsmith|
.. |Latest version of 'psycopg2-binary' @ Cloudsmith| image:: https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/psycopg2-binary/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/?render=true&show_latest=true
:target: https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/psycopg2-binary/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/image::https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/psycopg2-binary/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/?render=true&show_latest=true[link="https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/psycopg2-binary/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/",title="Latest version of 'psycopg2-binary' @ Cloudsmith"]<a href="https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/psycopg2-binary/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/"><img src="https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/psycopg2-binary/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=psycopg2-binary;xv=cp36/?render=true&show_latest=true" alt="Latest version of 'psycopg2-binary' @ Cloudsmith" /></a>rendered as:
These instructions assume you have setup the repository first (or read it).
To install/use psycopg2-binary @ version 2.7.6.1 ...
pip install 'psycopg2-binary==2.7.6.1'You can also install the latest version of this package:
pip install --upgrade 'psycopg2-binary'If necessary, you can specify the repository directly:
pip install \
--index-url=https://dl.cloudsmith.io/public/agriconnect/python/python/simple/ \
psycopg2-binary==2.7.6.1If you've got a project requirements.txt file, you can specify this as a dependency:
--index-url=https://dl.cloudsmith.io/public/agriconnect/python/python/simple/
psycopg2-binary==2.7.6.1In addition, you can use this repository as an extra index url. However, please read our documentation on this parameter before using it. For example in a requirements.txt file:
--extra-index-url=https://dl.cloudsmith.io/public/agriconnect/python/python/simple/
psycopg2-binary==2.7.6.1