Pyrseas 0.8.0
- This Release
- Pyrseas 0.8.0
- Date
- Status
- Stable
- Latest Stable
- Pyrseas 0.10.0 —
- Other Releases
- Abstract
- Utilities to assist in database schema versioning
- Description
- 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. Supports PostgreSQL 9.3, 9.4, 9.5, 9.6 and 10.
- Released By
- jma
- License
- BSD
- Resources
- Special Files
- Tags
Extensions
- augmentdb 0.8.0
- Generates an augmented YAML description of a Postgres database from its catalogs and an augmentation specification
- dbtoyaml 0.8.0
- Outputs a YAML description of a Postgres database's tables and other objects (metadata), suitable for storing in a version control repository
- yamltodb 0.8.0
- Generates SQL statements to modify a database so that it will match an input YAML/JSON specification
Documentation
- configitems
- Configuration Items
- foreign
- Foreign Data Objects
- issues
- Known Issues
- operator
- Operators
- devel
- Development
- cmdargs
- Common Command Line Options
- overview
- Overview
- constraint
- Constraints
- extension
- Extensions
- testing
- Testing
- cast
- Casts
- cfgobjects
- Augmenter Configuration Objects
- function
- Functions
- AUTHORS
- AUTHORS
- install
- Installation
- table
- Tables, Views and Sequences
- operfamily
- Operator Families
- column
- Columns
- Changelog
- Changelog
- eventtrig
- Event Triggers
- predefaug
- Predefined Database Augmentations
- language
- Procedural Languages
- textsearch
- Text Search Objects
- trigger
- Triggers
- config
- Configuration
- index
- PyrseasIndices and tables
- database
- Databases
- operclass
- Operator Classes
- dbobject
- Database Objects
- collation
- Collations
- rule
- Rules
- type
- Types and Domains
- augobjects
- Augmentation Objects
- schema
- Schemas
- dbaugment
- dbaugment - Augment a database
- indexes
- Indexes
- conversion
- Conversions
README
Contents
Pyrseas
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.