pgcom

Communication manager for PostgreSQL database, provides a collection of convenience wrappers over Psycopg adapter to simplify the usage of basic Psycopg methods in conjunction with Pandas DataFrames.

Installation

To install the package, simply use pip:

$ pip install pgcom

Key features

• Reading from database table to Pandas DataFrame.
• Writing from DataFrame to a table.
• Adaptation between DataFrames and COPY FROM.
• Methods to resolve conflicts in DataFrame before applying COPY FROM.
• Tools for setting asynchronous communication with database using LISTEN and NOTIFY commands.

Read the documentation for more.

License

MIT License (see LICENSE).