Skip to main content

Utilities to assist in database schema versioning

Project description

https://api.travis-ci.org/perseas/Pyrseas.png?branch=master

Pyrseas provides utilities to describe a PostgreSQL database schema as YAML, to verify the schema against the same or a different database and to generate SQL that will modify the schema to match the YAML description.

Features

  • Outputs a YAML description of a Postgres database’s tables and other objects (metadata), suitable for storing in a version control repository
  • Generates SQL statements to modify a database so that it will match an input YAML/JSON specification
  • Generates an augmented YAML description of a Postgres database from its catalogs and an augmentation specification.

Requirements

  • PostgreSQL 9.3 or higher
  • Python 2.7 or higher

License

Pyrseas is free (libre) software and is distributed under the BSD license. Please see the LICENSE file for details.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
Pyrseas-0.8.0-py2.py3-none-any.whl (113.4 kB) Copy SHA256 hash SHA256 Wheel py2.py3 Dec 13, 2017
Pyrseas-0.8.0.tar.gz (170.3 kB) Copy SHA256 hash SHA256 Source None Dec 13, 2017

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page