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.
LiteSQL is a C++ library that integrates C++ objects tightly to a relational database and thus provides an object persistence layer. LiteSQL supports SQLite3, PostgreSQL, and MySQL as backends. LiteSQL creates tables, indexes, and sequences to database and upgrades schema when needed. In addition to object persistence, LiteSQL provides object relations which can be used to model any kind of C++ data structures. Objects can be selected, filtered, and ordered using a template- and class-based API with type checking at compile time.
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.
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.
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.
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.