Metadata-Version: 2.1
Name: pgcom
Version: 0.1.6
Summary: PostgreSQL communication manager
Home-page: https://github.com/viktorsapozhok/pgcom
Author: Alex Piskun
Author-email: piskun.aleksey@gmail.com
License: UNKNOWN
Platform: UNKNOWN
Requires-Python: >=3.6
Description-Content-Type: text/markdown
Requires-Dist: pandas (>=0.24.0)
Requires-Dist: psycopg2-binary (>=2.7.7)
Provides-Extra: docs
Requires-Dist: sphinx ; extra == 'docs'
Requires-Dist: sphinx-rtd-theme ; extra == 'docs'
Requires-Dist: sphinx-autodoc-typehints ; extra == 'docs'
Provides-Extra: sql
Requires-Dist: sqlalchemy (>=1.3.12) ; extra == 'sql'
Provides-Extra: test
Requires-Dist: codecov ; extra == 'test'
Requires-Dist: tox ; extra == 'test'

# pgcom

[![Build Status](https://travis-ci.org/viktorsapozhok/pgcom.svg?branch=master)](https://travis-ci.org/viktorsapozhok/pgcom)
[![pypi](https://img.shields.io/pypi/v/pgcom.svg)](https://pypi.python.org/pypi/pgcom)
[![Documentation Status](https://readthedocs.org/projects/pgcom/badge/?version=latest)](https://pgcom.readthedocs.io/en/latest/?badge=latest)
[![License: MIT](https://img.shields.io/badge/License-MIT-blue.svg)](https://opensource.org/licenses/MIT)

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](https://pgcom.readthedocs.io/en/latest/) for more.

## License

MIT License (see [LICENSE](LICENSE)).


