The Information System Development Kit gives the developer a platform-independent method of creating Information Systems with data forms, SQL database access, database-browsing support, report generator and many other useful features. ISDK is now in a development stage and it is available only for the Linux operating system. The form module now works on text terminals using the ncurses library (not functional right now), and on the X-Window system using the GTK+ toolkit.
Aubit 4GL compiler is a programming language based on (and compatible with) Informix-4GL. It provides an easy way to generate screen/form based programs, since statements for handling Windows, Forms, Menus, SQL, and similar are built-in. With support for SQL statements forming an intrinsic part of the language, it's especially suitable for developing database-oriented applications. Database connectivity is provided for PostgreSQL, MySQL, Informix, and others via ODBC. It supports both ncurses (console mode) and GTK+ (GUI mode) output.
The GCC XML Tree Node Introspector project consists of a patch to the gcc compiler to output the internal compiler tree nodes in RDF/XML and programs to process that RDF/XML. The tree nodes are complex data structures which represent the source code inside the compiler. Through these tree nodes, users are able to extract information from their programs that would be otherwise very difficult to obtain. Modules exist to store these nodes in Redland RDF using a Berkley database. The long-term goal of the project is create a high-level API that will make the programmatic manipulation of programs easier than it is now.
pgdiff compares the structures of two PostgreSQL databases and returns the differences as a sequence of SQL commands which can be fed to psql to transform the structure of the first to be identical to the second (analagous to diff and patch). There is an advanced Web interface that makes testing and exploration easy. Database schemas can come from live databases, SQL files, or direct input.
PyDBDesigner is an entity-relation (ERW) database modeling tool for both Windows and Unix/Linux. It is similar to Power Designer or Erwin, and both physical and logical models are supported. Its main features are database modeling, SQL generation, documentation generation, and reverse engineering. PyDBDesigner is intended to be a GUI design tool for the ERW (entities and relations on the Web) project.
FireStorm/DAO is a Java Code Generator that can import existing database schemas (from a SQL script or from a live JDBC connection) and can then generate a complete persistence tier. It generates Java source code and configuration files that developers would otherwise have to write by hand, and that is compliant with the Data Access Object (DAO) design pattern.
The QueryDOM library is a DOM-based technology whose purpose is the generation of SQL queries at runtime. It's based on a single model representation of the query to be rendered. To represent the SQL query, QueryDOM elements are linked to each other to form a data structure known as the QueryDOM graph, which models the structure of the SQL grammar. The QueryDOM defines types representing the logical structure of the query string in a way that is independent from the specific DBMS. The object model is simple to extend for specific database features.
Cordova is a solution to source code and database schema generation. Its focus is on MySQL, Java, and OJB. It provides tools and plugins to assist in operations of the database, compilation of code, and code generation. Each module has been created out of need, where no tool has cleanly existed before. Its direction is towards 2 modes: an ANT task, and command line without ANT dependencies.
XML to DDL is a set of Python programs that converts an XML representation of a database into a set of SQL or DDL (Data Definition Language) commands. In addition, it can examine the difference between two XML files and output a sequence of SQL statements (normally ALTER statements) to bring one database up-to-date with the XML schema. You can also download the XML schema directly from the database. Finally, there's a tool to convert your schema into HTML for documentation purposes. XML to DDL currently supports the most recent versions of PostgreSQL, MySQL, Oracle, and Firebird databases.