25th November, 2009

Gerald release 0.3.1

Filed under: database,python — admin @ 3:25 pm

Everyone, say hello to version 0.3.1 of gerald. This is a minor update that fixed some issues introduced in release 0.3 In summary these are:

  • Ticket 17 – Views have been converted to dictionaries from tuples
  • Ticket 18 – Reading an Oracle sequence updates it’s current value
  • Ticket 19 – Postgres primary keys were not represented properly when read from the database

Development, bug and issue tracking and the project wiki are available on the project Trac site. Source code and distribution files are available at the sourceforge page.

The next release will be 0.3.5 and will introduce the concept of a ‘User’. This is similar to a ‘Schema’ but will reference all of the objects a database user can see even if they don’t own them. You can track progress for the release using the version 0.3.5 roadmap.

2 Comments

  1. Have you considered making use of SQLAlchemy’s schema reflection features as the basis for how Gerald extracts this information ? 0.6 has a fine grained interface for this called the “Inspector”, agnostic of SQLA’s usual “Table” and “Column” constructs and instead returning plain list/dict structures. The API is not in the docs yet but can be reviewed here: http://www.sqlalchemy.org/trac/browser/sqlalchemy/trunk/lib/sqlalchemy/engine/reflection.py . You’d get support for PG, Oracle, MySQL, Firebird, SQLite, MS-SQL and any new dialects added (like DB2, sybase) for free, support for a wide variety of DBAPIs for each including Jython support, and improvements to Gerald and SQLAlchemy would benefit each other.

    Comment by mike bayer — 27/11/2009 @ 1:29 pm

  2. Have you considered making use of SQLAlchemy’s schema reflection features as the basis for how Gerald extracts this information ? 0.6 has a fine grained interface for this called the “Inspector”, agnostic of SQLA’s usual “Table” and “Column” constructs and instead returning plain list/dict structures. The API is not in the docs yet but can be reviewed here: http://www.sqlalchemy.org/trac/browser/sqlalchemy/trunk/lib/sqlalchemy/engine/reflection.py . You’d get support for PG, Oracle, MySQL, Firebird, SQLite, MS-SQL and any new dialects added (like DB2, sybase) for free, support for a wide variety of DBAPIs for each including Jython support, and improvements to Gerald and SQLAlchemy would benefit each other.

    Comment by mike bayer — 27/11/2009 @ 1:29 pm

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Powered by WordPress