Linux Software / Programming / Database Tools

SchemaSpy 3.1.1

Date Added: January 11, 2010 | Visits: 1.292

Report Broken Link
Printer Friendly Version

Product Homepage
Download (98 downloads)

SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships. The browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. Its also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints. SchemaSpy is free software, distributed under the terms of the Lesser GNU Public License. Your donations are, however, greatly appreciated. SchemaSpy uses the dot executable from Graphviz to generate graphical representations of the table/view relationships. This was initially added for people who see things visually. Now the graphical representation of relationships is a fundamental feature of the tool. Graphvis is not required to view the output generated by SchemaSpy, but the dot program should be in your PATH (not CLASSPATH) when running SchemaSpy or none of the graphs will be generated. Some Linux users have experienced problems with dot version 2.6. Version 2.6 (or higher) is preferred, but if it doesnt work then try 2.2.1. Note that SchemaSpy takes advantage of some dot 2.6+ features so graphs wont be as well formed when using 2.2.1. SchemaSpy uses JDBCs database metadata extraction services to gather the majority of its information, but has to make vendor-specific SQL queries to gather some information such as the SQL associated with a view and the details of check constraints. The differences between vendors have been isolated to configuration files and are extremely limited. Almost all of the vendor-specific SQL is optional. Whats New in This Release: - 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)..

Requirements: No special requirements

Platforms: Linux

Keyword: Database, Database Apis, Dot, Java-based, Metadata, Relationships, Schema, Schemaspy, Sql, Tool

Users rating: 0/10

License: Freeware

Size: 122.88 KB

USER REVIEWS

More Reviews or Write Review

SCHEMASPY RELATED

Database Tools - CsvToSql 3.1.0 CsvToSql a java based highly configurable and expandable conversion tool and library. You can define the structure of data how render and where write it through a descriptor. CsvToSql project is compatible with the most common rdbms. csvToSql...	1.7 MB
Games - JabaMud - Java based role playing game 0.0.4 JabaMud is an attempt to build a Java based multiuser reality. The goal is a graphically stunning massively multiplayer RPG that is completely OS independent and relatively quick. JabaMud runs as an application and uses Java3D to render scenes.	1.07 MB
Security Tools - Java based IP load balancer 1.0 The project is a fully functional Java based IP load balancer. It has a web based admin UI to setup the configuration such as the number of real servers and their addressess, ping times to monitor the health of each of the real servers, the...	879.21 KB
Development Tools - Java-based data table 1.0 createTable creates a 2D java-based table that enables display, editing and sorting of 1D and 2D data using familiar look-and-feel. Columns can be resized and sorted; data can be selected, printed, copied, pasted etc., including to/from Excel;...	40.96 KB
Database Tools - MyJSQLView 2.72 MyJSQLView provides an easy to use Java based user interface frontend for viewing, adding, editing, or deleting entries in a MySQL database. MyJSQLView is the result of a condensed version of a larger project that was needed to access an...	1.4 MB
Database Tools - JDOInstruments 2.9.2 JDOInstruments is an embedded object oriented database programmed in java, it is also an implementation of Suns Java Data Objects (JDO) specification for the transparent persistence of Java objects. Because of this, it doesnt need a JDBC driver...	6.3 MB
Finance - jBooks 0.1.1 JBooks is a Java-based personal finance application. The main interface of jBooks is a checkbook-like view, which allows you to enter and see your transactions. It is based around an SQL relational database, using a double-entry system for all...	1.4 MB
Programming - BasicQuery 01.03.01 BasicQuery is a Java-based application used to access databases through JDBC. It features a Swing-based GUI and includes capabilities useful to developers when testing SQL statements against a database. BasicQuery also produces timing information,...	1.3 MB
Security Tools - Password Safe SWT 0.6.000 Password Safe SWT is Java-based Password Safe version. Password Safe is a password database utility. Users can keep their passwords securely encrypted on their computers. A single Safe Combination unlocks them all. Originally created by Bruce...	4.4 MB
Database Tools - Trading-shim 70529 Trading-shim is a database driven connector API that provides a persistent store SQL backend database. The trading shim is a command-line and dbms controlled interface to the socket-based API of Interactive Brokers Trader Workstation,...	368.64 KB

NEW DOWNLOADS IN PROGRAMMING, DATABASE TOOLS

Programming - Cedalion for Linux 0.2.6 Cedalion is a programming language that allows its users to add new abstractions and define (and use) internal DSLs. Its innovation is in the fact that it uses projectional editing to allow the new abstractions to have no syntactic limitations.	471.04 KB
Programming - Math::GMPf 0.29 Math::GMPf - perl interface to the GMP library's floating point (mpf) functions.	30.72 KB
Programming - Net::Wire10 1.08 Net::Wire10 is a Pure Perl connector that talks to Sphinx, MySQL and Drizzle servers. Net::Wire10 implements the low-level network protocol, alias the MySQL wire protocol version 10, necessary for talking to one of the aforementioned...	30.72 KB
Programming - logilab-common 0.56.2 a bunch of modules providing low level functionnalities shared among some python projects devel Please note that some of the modules have some extra dependencies. For instance, logilab.common.db will require a db-api 2.0 compliant...	174.08 KB
Programming - OpenSSL for linux 1.0.0a The OpenSSL Project is a collaborative effort to develop a robust, commercial-grade, full-featured, and Open Source toolkit implementing the Secure Sockets Layer (SSL v2/v3) and Transport Layer Security (TLS v1) protocols as well as a...	3.83 MB
Database Tools - mel, XML Data Binding for C 2 Language: C, XMLLibrary: libxml2OS: AnyXML Databinding for C similar to JAXB, including but not limited to:.dtd to .[ch] production..xsd to .[ch] production (in progress)	53.07 KB
Database Tools - CitrusDB 1.1.4 CitrusDB is an open source customer database application that uses PHP and a database back-end (currently MySQL). This software can keep track of customer information, CRM, services, products, billing, and customer service information. The...	1.1 MB
Database Tools - MyJgui 0.5.5.1 MyJgui is a light-weight graphical user interface for MySQL databases. It aims to be easy to use for new users as well as experts. Motivation: After the MySQL Front project went commercial, there was no light weight, feature rich and free...	21.5 KB
Database Tools - PHPCoder 1.4 PHPCoder is a web based front-end to the Turck MMCache encoding functions, which are similar to the Zend Encoder product. Turck MMCache is a free open source PHP accelerator, optimizer, encoder and dynamic content cache for PHP. It increases...	16.38 KB
Database Tools - Rekall 2.2.6 Rekall is a database front-end, somewhat in the style of MicroSoft Access. However, Rekall is not itself a database, and does not include a database. By this we mean that data is stored somewhere else in an SQL server, and Rekall is fundementaly...	4.9 MB

Windows Software	BeOS Software
Macintosh Software	Linux Software
PDA Software	OS/2 Software
Mobile Software	Scripts