Extensions
- dbtoyaml 0.7.1
- Output PostgreSQL schemas in YAML format
- yamltodb 0.7.1
- Generate SQL to sync a database with a YAML schema spec
Documentation
- cmdargs
- Common Command Line Options
- operator
- Operators
- devel
- Development
- overview
- Overview
- configitems
- Configuration Items
- foreign
- Foreign Data Objects
- issues
- Known Issues
- cfgobjects
- Augmenter Configuration Objects
- function
- Functions
- dbconn
- Database Connections
- constraint
- Constraints
- testing
- Testing
- cast
- Casts
- augmentdb
- Augmenter Databases
- extension
- Extensions
- trigger
- Triggers
- textsearch
- Text Search Objects
- language
- Procedural Languages
- eventtrig
- Event Triggers
- predefaug
- Predefined Database Augmentations
- config
- Configuration
- index
- PyrseasIndices and tables
- install
- Installation
- AUTHORS
- AUTHORS
- Changelog
- Changelog
- table
- Tables, Views and Sequences
- column
- Columns
- operfamily
- Operator Families
- indexes
- Indexes
- conversion
- Conversions
- augobjects
- Augmentation Objects
- dbaugment
- dbaugment - Augment a database
- schema
- Schemas
- dbobject
- Database Objects
- database
- Databases
- operclass
- Operator Classes
- rule
- Rules
- type
- Types and Domains
- collation
- Collations
README
Contents
Pyrseas
Pyrseas provides a framework and utilities to upgrade and maintain a PostgreSQL database.
Features
- Outputs a YAML description of a PostgreSQL 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
- (planned) Generates a flexible web application to update PostgreSQL tables
Requirements
- PostgreSQL 8.4 or higher
- Python 2.6 or higher
- (planned) Werkzeug
- (planned) Jinja2
License
Pyrseas is free (libre) software and is distributed under the BSD license. Please see the LICENSE file for details.