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.
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.
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.
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.
SPWrapper is a source code generator whose input is an SQL statement, or with some limitations the name of a stored procedure. Each SQL statement become a Java class, iterable to fetch results if the statement is a SELECT. It is possible to generate Python classes for the cx_Oracle module. SPWrapper is designed to require little configuration: it tries to automatically guess input parameters form SQL code, and output parameters from the SQL result set fetched. All the SQL statements can be translated to source code, even those with proprietary syntax. It currently supports 4 databases for Java (Oracle, PostgreSQL, MySQL and SQL Server) and Oracle with Python. A Netbeans plugin is also available (for stored procedures only).
pyswarm is planned as a holistic set of tools (especially a code generator) for model-driven software development (MDSD) of database-backed Web applications. It provides easily customizable business logic based on Python and PostgreSQL. As required by the MDA standard, pyswarm uses UML (version 2.0 stored as XMI 2.1).
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.
SQLizer is a utility library intended to be used in search applications. Given an input string, it builds an SQL select statement. It supports two types of input: numeric and string. The catch is that this library allows usage of operators in the input string. Supported operators are "and", "or", "not", and grouping by means of parentheses. It also supports the wildcards "*", "%", "?", and "_" in string searches as well as regular expressions enclosed in /.../.