SQLite is a small, fast, embeddable SQL database engine that supports most of SQL92, including transactions with atomic commit and rollback, subqueries, compound queries, triggers, and views. A complete database is stored in a single cross-platform disk file. The native C/C++ API is simple and easy to use. Bindings for other languages are also available.
SLOCCount is a suite of programs for counting physical source lines of code (SLOC) in possibly large software systems. It can count physical SLOC for a wide number of languages. It can take a large set of files and automatically categorize their types using a number of different heuristics, and also comes with analysis tools.
YaaCs (Yet Another Advanced Cati system) is written in Tcl/Tk to manage and realize computer assisted telephone interviewing (CATI) and telemarketing. It make easy monitoring survey progress (giving several information), and it allows the management of the the survey with several administration tools. It simplifies the interviewer's work reading all contact's data from an easy and functional GUI. It can send faxes via hylaFAX and save all contact's data in a PostgreSQL database.
OpenACS (Open Architecture Community System) is a mature toolkit for building scalable, community-oriented Web applications. Significant functionality is built-in, including user management, user group management, permissions, discussion forums, FAQ management, e-commerce, file storage, content management, and more. OpenACS is the foundation for many products and Web sites, including the .LRN e-learning platform.
Dragon Breath is the name of a generic development and application framework that is heavily based on PostgreSQL and PHP. It contains different layers which wrap business logic, data, and any graphical interface. It opens up and eases development in the field of graphical user interfaces and data management. The interface layer is built upon XSLT rendering, which allows the rendering of displays for different interfaces like Web browsers, PDAs, mobile phones, and others. The database layer depends on PostgreSQL's features and allows a common exchange of data with any kind of data structure. It even contains built in sanity checks for data integrity.
Dragon Lair is a knowledge base system based on Topic Maps Technology. Data Elements are represented as topics and subjects and put into relationships with each other. Since these relations are data independent, Dragon Lair can be put on top of an existing database or be used as a graphical representation of a new data source. Dragon Lair "sits" directly upon the Dragon Breath framework for reliable and easy data manipulation, sanity check, and data exchange.
The Modular Application Engine (MAPE) allows programmers to write multi-tier applications in multiple programming languages, using different GUIs for the clients, and accessing multiple database systems. Whole applications are stored in the MAPE system catalog which is stored in a supported SQL database server. XML is used for application description. The applications are generally run on the server, but some parts can run on the client.
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.