PostgreSQL

sudo pip install pgdb
# sudo python3 -m pip install pgdb

from pgdb import Connection

## PostgreSQL
connection = Connection(user='postgres', database='main', host='localhost')

## 
connection.query("select * from main")

## query
connection.get("select * from main limit 1")

## 
connection.execute("update main set status = 0")

## 
connection.executemany("insert into main values %(status)s", [{'status': 1}])

# 

cursor = connection.cursor()
connection.commit()
connection.rollback()
connection.close()

For development

python setup.py sdist

## edit ~/.pypirc
### [pypi]
### repository = https://pypi.python.org/pypi
### username =  
### password =  

twine register dist/pgdb-0.0.1.tar.gz
twine upload dist/pgdb-0.0.1.tar.gz