Pyrseas

Pyrseas includes the dbtoyaml utility to create a YAML description of a PostgreSQL database's tables.

A similar, yet reverse tool, yamltodb, generates SQL statements to modify a database to match an inputted YAML file.

This way database setups can be easily migrated or upgraded via one single YAML file.

If various iterations of a YAML file are kept, than a basic database versioning system is created, which developers can use to go back and forward between various database states.

This can be useful in both development and production environments.

What is new in this release:

• This release changes the location of the system configuration file (config.yaml) so that it is accessible when installing via the Python installer (pip, as opposed to installing via "python setup.py install").
• In addition, yamltodb output is now encoded using utf-8 when writing to a file or pipe.

What is new in version 0.7.0:

• Added support for MATERIALIZED VIEWs, EVENT TRIGGERs, CLUSTER, configuration files, multiple-file input or output, data export and import and more.

What is new in version 0.6.1:

• This is a maintenance release of Pyrseas 0.6 to address some recently raised and fixed issues.

What is new in version 0.5.0:

• It now supports additional DDL features, including TEXTSEARCH parsers, dictionaries, configurations and templates; FOREIGN DATA WRAPPERs, SERVERs, USER MAPPINGs and FOREIGN TABLEs; and running under Python 2.6, 2.7, and 3.2.

What is new in version 0.4.1:

• Added support for PG 9.1.
• Fixed various issues raised via the GitHub tracker and the pyrseas-general mailing list.

What is new in version 0.4.0:

• It now supports additional DDL features, including CASTs, CONSTRAINT TRIGGERs, CONVERSIONs, OPERATORs, OPERATOR CLASSes and OPERATOR FAMILies, dynamically loaded C language functions, and composite and base TYPEs.

What is new in version 0.3.1:

• Added support for delimited identifiers and a workaround for databases without a 'public' schema.

What is new in version 0.3.0:

• It now supports additional DDL features, such as DOMAINs and ENUMs, rewrite RULEs, TRIGGERs, INDEXes using expressions and AGGREGATE functions.

What is new in version 0.2.1:

• Fixed problem with mapping a FOREIGN KEY in a table with a dropped column.

Requirements:

• PostgreSQL 8.4 or higher
• Python 2.6 or higher