Projects / SchemaCrawler / Releases

All releases of SchemaCrawler

  •  11 May 2009 10:47
Avatar

    Release Notes: This release adds a pre-packaged SchemaCrawler for SQLite. There is also an improved algorithm to find weak associations, and a new command-line switch to sort columns alphabetically.

    •  07 May 2009 02:57
    Avatar

      Release Notes: grep functionality was built into the command line. This means that all of the SchemaCrawler commands, including graphing, can use filtering and grep options. The command line option help has been re-written. If no commands are specified, it defaults to standard_schema, a new command that provides the most commonly needed details of the schema. Graphviz DOT files are now produced as one of the native output formats for generating schema diagrams.

      •  09 Apr 2009 02:27
      Avatar

        Release Notes: This version has a new feature that infers weak associations between tables, even if there is no foreign key. Ruby on Rails table schemes are supported, as well as other simple relationships. Table name prefixes are automatically detected. There is now database diagram support using Graphviz. Primary keys are indicated in a darker color than other columns. Foreign keys are indicated with arrow connectors. Weak associations between tables are shown in dashed lines. Multiple output formats are supported. Support for Jung is dropped.

        •  29 Mar 2009 20:08
        Avatar

          Release Notes: SchemaCrawler does a better job of reporting ascending and descending index columns. This is an API change. There are better grep options, to allow searching through both tables and stored procedures. This release includes minor bugfixes for Sybase, including generating warnings when obtaining table column privileges instead of failing. There is a new Windows script file for locating Java and launching SchemaCrawler. There is a reorganization of the distribution so that only a single SchemaCrawler jar file is distributed in all distributions.

          •  29 Nov 2008 07:02
          Avatar

            Release Notes: This release fixes an issue with MySQL schemas.

            •  07 Nov 2008 05:06
            Avatar

              Release Notes: Bugfixes for recognizing -schemapattern on the command line, and data types with the Oracle driver.

              •  17 Oct 2008 04:55
              Avatar

                Release Notes: This release introduces a number of API changes and new features. Notable among these is full support for multiple schemata in a catalog. The SchemaCrawler API returns a catalog as the top level object, which contains schemata. Another change is that SchemaInfoLevel is an option, not a CrawlHandler property, to allow for better separation of concerns. Finally, SchemaCrawler has support for JavaScript scripting with J2SE 6 and above.

                •  27 Feb 2008 12:00
                Avatar

                  Release Notes: SchemaCrawler for Microsoft SQL Server shows details of procedures and triggers. The basic SchemaCrawler distribution is simple to use for any database, because all you need to do is add the database driver. Bug fixes include correctly reporting an index as unique and correctly reporting primary key columns.

                  •  05 Feb 2008 02:07
                  Avatar

                    Release Notes: This release provides JDBC driver metadata, including driver properties. A new command line switch, -schemapattern, is available for specifying schema patterns when a connection is specified from the command line. Object attributes are added automatically from unused columns in the metadata calls.

                    •  16 Nov 2007 07:39
                    Avatar

                      Release Notes: New features include the ability to get result-set metadata. The schema info level is no longer an enumeration, but a class that is used to specify details on what aspects of the schema need to be retrieved. There is now an easier way to access foreign keys from the foreign key column itself, via isPartOfForeignKey(), and getReferencedColumn() on the Column class. Bug fixes were made to delivering all relevant license files, the way foreign key update and delete rules on Oracle are reported, and the "equals" comparison on all schema objects.

                      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.