Projects / Pyrseas


Pyrseas provides a framework and utilities to upgrade and maintain a relational database. It currently includes the dbtoyaml utility to create a YAML description of a PostgreSQL database's tables, and the yamltodb utility to generate SQL statements to modify a database to match an input YAML specification. It also aims to develop data administration tools to supplement an agile database development process.

Operating Systems

Recent releases

  •  05 Dec 2013 20:10

    Release Notes: 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 install"). In addition, yamltodb output is now encoded using UTF-8 when writing to a file or pipe.

    •  25 Nov 2013 20:52

      Release Notes: This release added support for Postgres 9.3, specifically EVENT TRIGGERs and MATERIALIZED VIEWs, CLUSTER, partial indexes, storage parameters in CREATE and ALTER TABLE, ALTER COLUMN SET STATISTICS, LEAKPROOF qualifier for FUNCTIONs, YAML multi-line string formatting for view definitions, and function source text and object comments. It also includes configuration files, multiple-file input or output, data export/import, a new dbaugment utility that consistently adds objects to existing databases, and a new interface to Postgres, inspired by *The Third Manifesto*.

      •  31 Jan 2013 21:10

        Release Notes: This is a maintenance release. It adds support for INSTEAD OF triggers on views; eliminates yamltodb generation of spurious REVOKE/GRANT commands; and removes setuptools from install_requires.

        •  26 Oct 2012 20:25

          Release Notes: This release supports the following additional DDL features: EXTENSIONs, COLLATIONs, OWNER information, access privileges (GRANT and REVOKE), TABLESPACEs for tables, primary keys and indexes, MATCH attributes for foreign keys, ALTER composite TYPE ADD/DROP/RENAME ATTRIBUTE, ENUMs with no labels, UNLOGGED tables, and the CREATE FUNCTION SET configuration_parameter. It also support PostgreSQL 9.2.

          •  10 Mar 2012 18:59

            Release Notes: This release supports the following additional DDL features: TEXTSEARCH parsers, dictionaries, configurations, and templates; FOREIGN DATA WRAPPERs, SERVERs, USER MAPPINGs, and FOREIGN TABLEs; a ROWS clause in set-returning functions; deferrable/deferred constraints; CATEGORY and PREFERRED clauses for TYPEs; a SORTOP clause for AGGREGATEs; HASHES and MERGES clauses for OPERATORs; and operator class qualifiers for INDEXes.


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.