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
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 |