apgp

Asynchronous Postgres to Pandas


Keywords
pandas, postgres, redshift
License
MIT
Install
pip install apgp==0.1

Documentation

Asynchronous Postgres to Pandas (APGP)

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

Packagist

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

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'