Package Search Help

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.

Start My Free Trial
 Public agriconnect agriconnect (AgriConnect) / python
Prebuilt wheel for Python packages

Python logo asyncpg  0.18.3

One-liner (summary)

An asyncio PosgtreSQL driver

Description

asyncpg -- A fast PostgreSQL Database Client Library for Python/asyncio

https://travis-ci.org/MagicStack/asyncpg.svg?branch=master https://ci.appveyor.com/api/projects/status/9rwppnxphgc8bqoj/branch/master?svg=true https://img.shields.io/pypi/v/asyncpg.svg

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).

performance.png

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.

Size

2.1 MB

Downloads

72

Tags

bdist/wheel whl linux_armv7l cp36 cp36m latest

Status  Completed
Checksum (MD5) 117779fca0e20d6047792e3b5f215043
Checksum (SHA-1) 3d55053ede8a1ec306ec9a11f63af31297c0dc49
Checksum (SHA-256) 14ce514ea40657c9b346a20ba18dafa94ac640de5618578de20d3ccfe92db24d
Checksum (SHA-512) fc541819de402e3f00c06d9735f8401b592b61c9f789dfdb02408775501c59e57e…
GPG Signature
Storage Region  Dublin, Ireland
Type  Binary (contains binaries and binary artifacts)
Uploaded At 5 years, 1 month ago
Uploaded By quan
Slug Id asyncpg-0183-cp36-cp36m-linux_armv7lwhl
Unique Id soJzUeQ12ibt
Version (Raw) 0.18.3
Version (Parsed)
  • Major: 0
  • Minor: 18
  • Patch: 3
  • Type: SemVer (Strict)
  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… 72
2.1 MB
md5 sha1 sha256 sha512
Package Contents (asyncpg-0.18.3-cp36-cp36m-linux_armv7l.whl)
Loading...

This package has 94 files/directories.

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, 19 hours ago

Scan result

Vulnerable

Vulnerability count

4

Max. severity

Low
Target:
LOW

CVE-8583-85214: library: vulnerability title



Package Name: package_name
Installed Version: 1.2.75
Fixed Version: 2.9.35

References: stokes.com wong.com www.mccormick.com
LOW

CVE-5413-98958: library: vulnerability title



Package Name: package_name
Installed Version: 1.5.46
Fixed Version: 2.4.70

References: www.hill-martinez.info jacobs-crawford.com www.roberts.com
LOW

CVE-4348-43667: library: vulnerability title



Package Name: package_name
Installed Version: 1.3.36
Fixed Version: 2.8.9

References: paul-frye.com walters-davis.com www.blackburn.biz
LOW

CVE-1664-27787: library: vulnerability title



Package Name: package_name
Installed Version: 1.4.61
Fixed Version: 2.6.6

References: parsons-campbell.com jones.com ford-peterson.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:

[![This version of 'asyncpg' @ Cloudsmith](https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/asyncpg/0.18.3/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true)](https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/asyncpg/0.18.3/a=linux_armv7l;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/python/asyncpg/0.18.3/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true
   :target: https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/asyncpg/0.18.3/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/
image::https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/asyncpg/0.18.3/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true[link="https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/asyncpg/0.18.3/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/",title="This version of 'asyncpg' @ Cloudsmith"]
<a href="https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/asyncpg/0.18.3/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/"><img src="https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/asyncpg/0.18.3/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true" alt="This version of 'asyncpg' @ Cloudsmith" /></a>

rendered as: This version of 'asyncpg' @ Cloudsmith

To embed the badge for the latest package version, use the following:

[![Latest version of 'asyncpg' @ Cloudsmith](https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/asyncpg/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true&show_latest=true)](https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/asyncpg/latest/a=linux_armv7l;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/python/asyncpg/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true&show_latest=true
   :target: https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/asyncpg/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/
image::https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/asyncpg/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true&show_latest=true[link="https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/asyncpg/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/",title="Latest version of 'asyncpg' @ Cloudsmith"]
<a href="https://cloudsmith.io/~agriconnect/repos/python/packages/detail/python/asyncpg/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/"><img src="https://api-prd.cloudsmith.io/v1/badges/version/agriconnect/python/python/asyncpg/latest/a=linux_armv7l;xa=cp36m;xf=bdist_wheel;xn=asyncpg;xv=cp36/?render=true&show_latest=true" alt="Latest version of 'asyncpg' @ Cloudsmith" /></a>

rendered as: Latest version of 'asyncpg' @ Cloudsmith

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/python/simple/ \
  asyncpg==0.18.3

If 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/
asyncpg==0.18.3

In 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/
asyncpg==0.18.3
Warning: We highly recommend using pip (or similar) rather than installing directly.
Top