Skip to main content

Asynchronous Postgres to Pandas

Project description

Asynchronously read data from Postgres, returned as a Pandas dataframe.

Packagist

Packagist

logo

logo

Example

from apgp import Query

q = Query("""SELECT * FROM github.repository""")

q.execute()

#         id        name                        full_name description   fork  \
#  122866357  test_repo2  secretagentjamesbond/test_repo2        None  False
#  122866319   test_repo   secretagentjamesbond/test_repo        None  False

# homepage language default_branch          created_at  owner_id  private
#     None     None         master 2018-02-25 19:02:37  36823666    False
#     None     None         master 2018-02-25 19:02:15  36823666    False

q.close()

Performance

Graphic pulled from Asyncpg github page.

performance

performance

Setup

In order to bypass manually connecting you will need a config.yaml in your project root. You can see an an example in the config.yaml.example file.

database: 'dbname'
host: 'host'
port: 5439
user: 'username'
password: 'password'

Project details


Release history Release notifications | RSS feed

This version

0.1

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for apgp, version 0.1
Filename, size File type Python version Upload date Hashes
Filename, size apgp-0.1-py3-none-any.whl (5.7 kB) File type Wheel Python version py3 Upload date Hashes View
Filename, size apgp-0.1.tar.gz (4.4 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page