sqlalchemy postgresql adapter and utilities.


Keywords
data-science, etl, finance, postgres, postgresql, python-3, sqlalchemy
License
BSD-3-Clause
Install
pip install pgawedge==0.2.0

Documentation

Build Status codecov.io Code Health

pgawedge

Postgresql Sqlalchemy adapter.

Purpose

pgawedge acts as an adapter(wedge) for setting sqlalchemy to use postgres conventions. Additionally, many utilities that relying on implementations buried throughout sqlalchemy's extensive documentation are included.

These include:

  • default postgres connection environmental variables names.
  • Primary key, foreign key, constraint naming conventions.
  • Server side UUID and UTC TIMESTAMP creation.
  • Serialization/deserialization for UUID's and JSON objects.

Pre-release Status

NOTE: pgawedge is still a pre-release and the API Could change. The most significant changes would affect the schema reflection API in alchemy.py.