Projects / Pyrseas / Releases

All releases of Pyrseas

  •  05 Dec 2013 20:10
Avatar

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

    •  25 Nov 2013 20:52
    Avatar

      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
      Avatar

        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 setup.py install_requires.

        •  26 Oct 2012 20:25
        Avatar

          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
          Avatar

            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.

            •  27 Oct 2011 17:18
            Avatar

              Release Notes: This is a maintenance release. The initial SET search_path is persistent. Exclusion of PG internal schemas in various queries has been fixed. Generation of COMMENTs with single quotes in the text has been fixed. For inherited tables, this release will only generate constraints that are defined locally. Generation of ALTER TABLE ADD/DROP COLUMN when input columns are in a different order than the original has been corrected (issue #8). Support has been added for PG 9.1 (a description for the PL/pgSQL language has been added).

              •  27 Sep 2011 02:09
              Avatar

                Release Notes: Pyrseas now supports the following additional DDL features: CASTs, CONSTRAINT TRIGGERs. CONVERSIONs, dynamically loaded C language functions, OPERATORs, OPERATOR CLASSes and OPERATOR FAMILies, and composite and base TYPEs. Other changes include a cleanup and enhancement of the documentation, removal of redundant methods, and the use of obj_description/col_description functions instead of querying pg_description directly.

                •  26 Aug 2011 17:57
                Avatar

                  Release Notes: This release adds a workaround for the incorrect assumption that 'public' schema is always present (issue #4). It adds support for delimited (or quoted) identifiers, e.g., those with embedded spaces, upper case characters, etc. (except for SQL keywords) (issue #5).

                  •  30 Jun 2011 19:35
                  Avatar

                    Release Notes: Support was added for DOMAINs and ENUMerated TYPEs, rewrite RULEs and TRIGGERs, INDEXes on expressions, AGGREGATE functions, functions returning table row types, and SECURITY DEFINER functions. Host/port defaults were enhanced to use sockets, resulting in a noticeable performance improvement.

                    •  07 Jun 2011 20:59
                    Avatar

                      Release Notes: This release fixes a problem with mapping a foreign key in a table with a dropped column (issue #2).

                      Screenshot

                      Project Spotlight

                      episoder

                      A tool to tell you about new episodes of your favourite TV shows.

                      Screenshot

                      Project Spotlight

                      BalanceNG

                      A modern software IP load balancer.