Projects / SchemaSpy / Releases

All releases of SchemaSpy

  •  16 Aug 2010 23:51
Avatar

    Release Notes: SQL was added for querying view details for MySQL databases. On the tables tab, you can now view tables and views separately as well as hide comments. The columns page has been trimmed down to help resolve loading issues on large (e.g. 20,000 table) schemas. A -gv option was added to no longer require finding Graphviz on the path. Hooks were added to allow for custom formatting of view SQL. DB2 Materialized Query Tables (MQTs) are treated as views. A new option was added to prompt for the password, so it doesn't appear on the command line. Many additional bugs were fixed.

    •  20 Oct 2008 18:14
    Avatar

      Release Notes: This release resolves issues with the extends directive as well as null IDs on DB2 views.

      •  17 Oct 2008 23:01
      Avatar

        Release Notes: This release can fully evaluate Ruby on Rails databases that associate foreign keys to primary tables/keys with a translation of singular to plural form. It resolves a bug where SchemaSpy was using incorrect entity relationship diagram notation. It adds support for MS SQL Server 2005 with jTDS driver, including column comment retrieval for all of the MS SQL databases. You can now specify database connection properties on the command line. There is a new -sso option to support single sign-on databases.

        •  22 Sep 2008 23:41
        Avatar

          Release Notes: Many additional metadata settings can now be specified via XML. The compact view of the relationships page now hides non-PK/non-indexed columns to reduce clutter and clarify the relationships. jQuery is now used for DOM manipulation. Support has been added for Derby (JavaDB) databases, both embedded and network, along with SQL Server with the jTDS driver, SQL Server 2005, and MaxDB. A new option for evaluating multiples with databases like MySQL where a database isn't composed of multiple schemas. Significantly improved performance of generation of entity-relationship diagrams. Many additional bugs were fixed.

          •  18 Dec 2006 17:33
          Avatar

            Release Notes: This is a bugfix release primarily intended to address the Graphviz 2.9+ changes that broke SchemaSpy. It fixes bug 1602135 (an exception using dot version 2.9), bug 1571711 (failure to use a precompiled version of dot on Mac OS X), and bug 1597609 (quoting and Sybase ASE).

            •  05 Oct 2006 06:53
            Avatar

              Release Notes: The Columns page is now sortable by column, table, type, size, nullability, auto increment, default value, children, or parents. A new option (-desc) was added to provide a description of the schema that is displayed on the non-detail pages. The -notablecomments option was added for databases like MySQL that stuff unrelated data where comments belong. Many bugs were fixed, including support for Oracle 10g's recycle bin.

              •  08 May 2006 05:16
              Avatar

                Release Notes: SchemaSpy now generates an XML representation of the database's schema. A new -all option analyzes all schemas in the database with one command. Database table and row comments are now displayed. You can now specify a subset of tables/views to include in the analysis with the new -i option. Support for Firebird and Informix was added.

                •  28 Feb 2006 10:18
                Avatar

                  Release Notes: The tool now generates a relatively useful relationships page even if dot fails to build the larger (and more likely to break Graphviz's dot) images. Lots of minor code cleanups were made by cranking up Eclipse's warning levels.

                  •  06 Feb 2006 07:00
                  Avatar

                    Release Notes: MySQL's configuration file was updated to point to the latest JDBC drivers. The URL for the Connector/J drivers was also given. A more descriptive error message is shown when the correct version of Graphviz dot isn't installed. Some people were having problems by passing -cp to java and not to SchemaSpy. The classpath-related error messages now clearly specify where -cp belongs. The classpath-related error messages were revamped to include the classpath entries that weren't valid. This should make it easier to track down JDBC driver issues.

                    •  02 Dec 2005 07:38
                    Avatar

                      Release Notes: SchemaSpy can now analyze all of the schemas of a database with one command (-all). This feature should allow a DBA to do a bulk analysis, documenting every user schema with one command. The layout of the tab area is now significantly cleaner. The -rankdirbug option was added to deal with the dot bugs that invariably result from using a non-standard rankdir in .dot files. Several bugs regarding the new tab structure were resolved.

                      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.