Asynchronous Postgres to Pandas
Project description
Asynchronously read data from Postgres, returned as a Pandas dataframe.
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.
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
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
apgp-0.1.tar.gz
(4.4 kB
view hashes)
Built Distribution
apgp-0.1-py3-none-any.whl
(5.7 kB
view hashes)