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
(AgriConnect)
/
python-musl
asyncpg
0.18.3
One-liner (summary)
Description
asyncpg -- A fast PostgreSQL Database Client Library for Python/asyncio
asyncpg is a database interface library designed specifically for PostgreSQL and Python/asyncio. asyncpg is an efficient, clean implementation of PostgreSQL server binary protocol for use with Python's asyncio framework. You can read more about asyncpg in an introductory blog post.
asyncpg requires Python 3.5 or later and is supported for PostgreSQL versions 9.2 to 11.
Documentation
The project documentation can be found here.
Performance
In our testing asyncpg is, on average, 3x faster than psycopg2 (and its asyncio variant -- aiopg).
The above results are a geometric mean of benchmarks obtained with PostgreSQL client driver benchmarking toolbench.
Features
asyncpg implements PostgreSQL server protocol natively and exposes its features directly, as opposed to hiding them behind a generic facade like DB-API.
This enables asyncpg to have easy-to-use support for:
- prepared statements
- scrollable cursors
- partial iteration on query results
- automatic encoding and decoding of composite types, arrays, and any combination of those
- straightforward support for custom data types
Installation
asyncpg is available on PyPI and has no dependencies. Use pip to install:
$ pip install asyncpg
Basic Usage
import asyncio import asyncpg async def run(): conn = await asyncpg.connect(user='user', password='password', database='database', host='127.0.0.1') values = await conn.fetch('''SELECT * FROM mytable''') await conn.close() loop = asyncio.get_event_loop() loop.run_until_complete(run())
License
asyncpg is developed and distributed under the Apache 2.0 license.
| Status | Completed |
|---|---|
| Checksum (MD5) | 9d390030aac0e87b18e2bdb78b3ae6cb |
| Checksum (SHA-1) | d5351e891427f0ce50cb4904be5cf8d9392edf6c |
| Checksum (SHA-256) | 86322774f74df0df08091fb4118b5f141352b75658ac4017758167dabe67648a |
| Checksum (SHA-512) | 4606fd98c6d1b77c2a156879e1896160470754fab318dde2c4b15b5db076cc9c2f… |
| GPG Signature | |
| Storage Region | Dublin, Ireland |
| Type | Binary (contains binaries and binary artifacts) |
| Uploaded At | 5 years, 2 months ago |
| Uploaded By |
|
| Slug Id | asyncpg-0183-cp36-cp36m-linux_x86_64whl |
| Unique Id | ykgNjPDLADFE |
| Version (Raw) | 0.18.3 |
| Version (Parsed) |
|
| extended metadata | |
| Abi | cp36m |
| Author | MagicStack Inc <hello@magic.io> |
| Classifiers | Development Status :: 5 - Production/Stable | Framework :: AsyncIO | Intended Audience :: Developers | License :: OSI Approved :: Apache Software License | Operating System :: MacOS :: MacOS X | Operating System :: Microsoft :: Windows | Operating System :: POSIX | Programming Language :: Python :: 3 :: Only | Programming Language :: Python :: 3.5 | Programming Language :: Python :: 3.6 | Programming Language :: Python :: 3.7 | Programming Language :: Python :: Implementation :: CPython | Topic :: Database :: Front-Ends |
| Homepage URL | https://github.com/MagicStack/asyncpg |
| Metadata Version | 2.1 |
| Platforms | POSIX | Windows | macOS |
| Py Filetype | bdist_wheel |
| Py Version | cp36 |
| pkg | asyncpg-0.18.3-cp36-cp36m-linux… |
237
2.2 MB |
md5 | sha1 | sha256 | sha512 |
This package has 94 files/directories.
|
|
asyncpg |
237 |
|
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
1 day, 3 hours ago
Scan result
Vulnerable
Vulnerability count
5
Max. severity
Critical| Target: | ||
| CRITICAL |
CVE-2631-89284: library: vulnerability titlePackage Name: package_name Installed Version: 1.8.96 Fixed Version: 2.10.58 References: shaw.biz www.butler.com www.levy-santos.com |
|
| CRITICAL |
CVE-6246-34291: library: vulnerability titlePackage Name: package_name Installed Version: 1.2.9 Fixed Version: 2.4.24 References: www.gonzalez.org www.warner.com washington.com |
|
| HIGH |
CVE-4618-27396: library: vulnerability titlePackage Name: package_name Installed Version: 1.1.18 Fixed Version: 2.3.36 References: munoz-green.org www.rivers.org martin.net |
|
| LOW |
CVE-4620-96114: library: vulnerability titlePackage Name: package_name Installed Version: 1.4.99 Fixed Version: 2.6.41 References: bentley.com mckenzie.com www.smith-smith.biz |
|
| LOW |
CVE-1708-21693: library: vulnerability titlePackage Name: package_name Installed Version: 1.4.32 Fixed Version: 2.1.36 References: estrada.com hines.com graham-white.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-musl/packages/detail/python/asyncpg/0.18.3/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/)|This version of 'asyncpg' @ Cloudsmith|
.. |This version of 'asyncpg' @ Cloudsmith| image:: https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python-musl/python/asyncpg/0.18.3/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true
:target: https://cloudsmith.io/~agriconnect/repos/python-musl/packages/detail/python/asyncpg/0.18.3/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/image::https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python-musl/python/asyncpg/0.18.3/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true[link="https://cloudsmith.io/~agriconnect/repos/python-musl/packages/detail/python/asyncpg/0.18.3/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/",title="This version of 'asyncpg' @ Cloudsmith"]<a href="https://cloudsmith.io/~agriconnect/repos/python-musl/packages/detail/python/asyncpg/0.18.3/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/"><img src="https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python-musl/python/asyncpg/0.18.3/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true" alt="This version of 'asyncpg' @ Cloudsmith" /></a>rendered as:
To embed the badge for the latest package version, use the following:
[](https://cloudsmith.io/~agriconnect/repos/python-musl/packages/detail/python/asyncpg/latest/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/)|Latest version of 'asyncpg' @ Cloudsmith|
.. |Latest version of 'asyncpg' @ Cloudsmith| image:: https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python-musl/python/asyncpg/latest/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true&show_latest=true
:target: https://cloudsmith.io/~agriconnect/repos/python-musl/packages/detail/python/asyncpg/latest/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/image::https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python-musl/python/asyncpg/latest/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true&show_latest=true[link="https://cloudsmith.io/~agriconnect/repos/python-musl/packages/detail/python/asyncpg/latest/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/",title="Latest version of 'asyncpg' @ Cloudsmith"]<a href="https://cloudsmith.io/~agriconnect/repos/python-musl/packages/detail/python/asyncpg/latest/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/"><img src="https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python-musl/python/asyncpg/latest/a=linux_x86_64;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true&show_latest=true" alt="Latest version of 'asyncpg' @ Cloudsmith" /></a>rendered as:
These instructions assume you have setup the repository first (or read it).
To install/use asyncpg @ version 0.18.3 ...
pip install 'asyncpg==0.18.3'You can also install the latest version of this package:
pip install --upgrade 'asyncpg'If necessary, you can specify the repository directly:
pip install \
--index-url=https://dl.cloudsmith.io/public/agriconnect/python-musl/python/simple/ \
asyncpg==0.18.3If you've got a project requirements.txt file, you can specify this as a dependency:
--index-url=https://dl.cloudsmith.io/public/agriconnect/python-musl/python/simple/
asyncpg==0.18.3In 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-musl/python/simple/
asyncpg==0.18.3