Pyrseas 0.5.0
- This Release
- Pyrseas 0.5.0
- Date
- Status
- Stable
- Latest Stable
- Pyrseas 0.10.0 —
- Other Releases
- Abstract
- Framework and utilities to upgrade and maintain databases
- Description
- Pyrseas provides a framework and utilities to upgrade and maintain a PostgreSQL database. Its utilities output a database schema in YAML format suitable for committing to a version control system and read this format to generate SQL to sync to another database. Supports PostgreSQL 8.4, 9.0 and 9.1.
- Released By
- jma
- License
- BSD
- Resources
- Special Files
- Tags
Extensions
- dbtoyaml 0.5.0
- Output PostgreSQL schemas in YAML format
- yamltodb 0.5.0
- Generate SQL to sync a database with a YAML schema spec
Documentation
- cmdargs
- Common Command Line Options
- foreign
- Foreign Data Objects
- operator
- Operators
- column
- Columns
- requires
- requires
- textsearch
- Text Search Objects
- rule
- Rules
- schema
- Schemas
- index
- index.rst
- install
- Installation
- function
- Functions
- conversion
- Conversions
- table
- Tables, Views and Sequences
- testing
- Testing
- dbconn
- Database Connections
- trigger
- Triggers
- top_level
- top_level
- operfamily
- Operator Families
- operclass
- Operator Classes
- SOURCES
- SOURCES
- database
- Databases
- indexes
- Indexes
- overview
- Overview
- cast
- Casts
- dbobject
- Database Objects
- entry_points
- entry_points
- issues
- Known Issues
- language
- Procedural Languages
- constraint
- Constraints
- type
- Types and Domains
README
Contents
======= Pyrseas ======= Pyrseas provides a framework and utilities to upgrade and maintain a PostgreSQL database. Features -------- - Outputs a YAML/JSON 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.