Logo

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