Projects

SchemaSpy

SchemaSpy analyzes database metadata to reverse engineer dynamic Entity Relationship (ER) diagrams. It works with just about any JDBC-compliant database (Oracle/MySQL/DB2/SQL Server/PostgreSQL/Sybase/etc.) and can identify Ruby on Rails as well as other implied relationships.

jOOQ

jOOQ effectively combines complex SQL, typesafety, source code generation, active records, stored procedures, advanced data types, and Java in a fluent, intuitive DSL.

Business Logic Toolkit for .NET

Business Logic Toolkit is a set of components to simplify .NET application development. BLToolkit is provided as source code that you can use "as is" or customize for your applications. It is written in C# and compatible with .NET Frameworks 3.5 and 4.0, Silverlight 4, and Mono.

SchemaCrawler

SchemaCrawler is an open-source Java API that makes working with database metadata as easy as working with plain old Java objects. SchemaCrawler is also a database schema discovery and comprehension, and schema documentation tool. You can search for database schema objects using regular ... [More] expressions, and output the schema and data in a readable text format, and find potential design issues with lint . The output is designed to be diff-ed against other database schemas. SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. SchemaCrawler works with any operating system that supports Java. [Less]

xlg

XLG is a pipeline based code generator that walks meta sources (database tables, folder/files, or XML), turns that structure into XML and then transforms the XML using XSL. That process defines a step in the pipeline where each additional step take additional actions, perhaps walking additional ... [More] databases (SQL Server, Sybase, and MySQL are currently supported) or perhaps walking other meta data sources (such as a folder/file hierarchy or the contents of a pre-existing XML file or the result of a web service call) for additional transformations to occur. Batch files can be called and the output gathered as XML. Currently, XLG is great for generating multiple DAL layers. Read the release notes for Gamma 2 for a much more in depth explanation and partial walk through. An excellent C# LINQesque DAL code library XSLT is included. XLG uses the wonderful NXLT2.exe. Additionally, the original code base was drawn from the original SubSonic release code (about 2 years ago). While there is little resemblance to either the original or the current SubSonic code base, it should be said that XLG would not exist without the fine work of the SubSonic team. [Less]