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

This version
History Node

0.1

Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
apgp-0.1-py3-none-any.whl (5.7 kB) Copy SHA256 hash SHA256 Wheel py3 Mar 23, 2018
apgp-0.1.tar.gz (4.4 kB) Copy SHA256 hash SHA256 Source None Mar 23, 2018

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page