Pyrseas 0.7.0 is now available

From: Joe Abbate <jma(at)freedomcircle(dot)com>
To: pgsql-announce(at)postgresql(dot)org
Subject: Pyrseas 0.7.0 is now available
Date: 2013-11-25 20:08:59
Message-ID: 5293AE5B.2090309@freedomcircle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Pyrseas 0.7.0, a framework for upgrading/migrating a Postgres
database, has been released. It is available from:

GitHub: https://github.com/pyrseas/Pyrseas (CHANGED)
PyPI: https://pypi.python.org/pypi/Pyrseas
PGXN: http://pgxn.org/dist/pyrseas/
PgFoundry: http://pgfoundry.org/projects/pyrseas

Updated documentation is viewable at:

Read the Docs: http://pyrseas.readthedocs.org/en/latest/
Python Hosted: http://pythonhosted.org/Pyrseas/

Pyrseas now supports the following additional Postgres features:

- Postgres 9.3, specifically
- EVENT TRIGGERs
- 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,
function source text and object comments

In addition, this release includes:

* Configuration files

All Pyrseas utilities can now use YAML-formatted configuration
files, in addition to command line options

* Multiple-file input or output

Spread database object information across a version control
repository

* Data export/import

Load a database with static data in production or data subsets
for testing

* dbtoyaml/yamltodb

- Added --quote-reserved option to yamltodb
- Exclude arguments from sfunc and finalfunc attributes of
aggregate functions (#54)
- Correct generation of SQL for functions with DEFAULT
arguments (#52)

* Augmenter

New utility (dbaugment) to consistently add objects to an
existent database. This is currently an experimental
feature and covers adding audit columns to tables.

* TTM-inspired relational interface

A new interface to Postgres, inspired by *The Third Manifesto*

I'd like to thank Adam Cornett, Andrey Popp, Antti Jokipii,
barkingfoodog(at)GH, Jesse Denardo, Josep Martinez, Mephysto666(at)GH, Roger
Hunwicks and anyone else who contributed time to test, open issues,
submit pull requests or otherwise helped make this release possible.

Best regards,

Joe Abbate

Browse pgsql-announce by date

  From Date Subject
Next Message Tony Locke 2013-12-01 17:29:15 pg8000 1.9.0 Released
Previous Message Tatsuo Ishii 2013-11-25 10:46:17 pg_monz released