pgAPI

CLI tool and Python library for manipulating Postgres databases

Inspiration | Installation | Usage | Roadmap

Inspiration

sqlite-utils provides a beautiful Pythonic API on top of SQLite databases. pgAPI is an attempt to lift-and-shift that API and replicate it on top of Postgres instead.

Installation

pip install pgAPI

Usage

Development

pip install -e '.[test,docs]'
pytest

Roadmap

v0.1.0

• MVP around pgapi.Database to have basic interaction with Postgres, and be able to run queries returned in Pythonic formats.
• Tests should pass even if that means minimal coverage
• CLI should be disabled
• docs should be disabled or