pgcom 0.1.6

PostgreSQL communication manager

pgcom

Communication manager for PostgreSQL database, provides a collection of wrappers over Psycopg adapter to simplify the usage of basic SQL operators.

Installation

To install the package, simply use pip:

$ pip install pgcom

You can also install the development version of pgcom from master branch of Git repository:

$ pip install git+https://github.com/viktorsapozhok/pgcom.git

Key features

• Execution of the database operations, reading query into a DataFrame, inserting records from DataFrame to the table
• Using COPY FROM for efficient writing data to the table
• Methods to resolve primary and foreign key conflicts before writing to the table
• Tools for setting asynchronous communication with database using PostgreSQL LISTEN and NOTIFY commands

Read the documentation for more.

License

MIT License (see LICENSE).