OraRep is a PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance, providing you with an overview on your instance(s), some hints for performance tuning, and more. It has been tested with Oracle 8.1.7, 9.0.1, and 9.2. The script easily fits into a cron task to be run on a regular basis. Sample output (HTML) is included. OSPRep does the same job for Oracle StatsPack Reports based on SnapShot Levels up to 7, and provides additional "plugins" for more detailed reporting on special issues. It also optionally creates a separate page with charts to visualize the results and more.
AGENCY is software that allows non-profit organizations to track data and manage operations. It is a fork and continuation of CHASERS. AGENCY aims to become a collectively-maintained and developed project that puts organizations in charge of their data systems. There are currently two “flavors” of AGENCY: one for managing clients and services, case management, and such (think “social service”); and one for managing donations and volunteers (think “fundraising”). Features include a report generator, permissions and access control, the ability to merge reports to OpenOffice documents, a log system, and real-time alerts with email notification. In the client version, many tables and data structures are already set up for organizations doing human service, homeless services, or HMIS. The donor version is set up to track donors, addresses, gifts (cash and inkind), flags, volunteers, volunteer activities, and more.
TOra is a Toolkit for Oracle that helps the DBA or developer of a database application. It features an SQL worksheet with PL/SQL block parsing, a PL/SQL debugger and editor with syntax highlighting, a Schema browser, Unicode support, printing, and a full suite of DBA management tools.
xmltvdb creates a database from a set of xmltv listings and then provides a Web interface to view the TV listings in a grid format similar to many Web-based listings providers, but with user customization and no advertising. It supports explicit and bayesian classification of shows to highlight items you like and de-emphasize ones you don't.
Babase is a baboon data management system. It is designed to facilitate the retrieval, storage, maintenance, and analysis of the following broad data categories: group membership, social status (dominance rank), life events, sexual cycle events (including progeny), sexual cycle day-to-day status, dyadic social interactions, focal animal samples, and multi-party social interactions. Integration of other data is supported. Babase is designed for Web access.
GNU EPrints is a solution for sites wanting to set up archives. By default it is configured to be an archive of research publications but can be easily altered. It is scalable and robust; all metadata is stored in UTF-8 rather than ASCII, and all "phrases" the system uses in user interaction are stored in an XML file for easy editing or translating. The system is built around Apache, mod_perl, and MySQL. Submissions are made via the Web and not entered into the main archive until approved by an editor.
C-Cramp (the C-Cramp College Radio Audio Management Program) is a Web-based frontend to MySQL for managing the types of things that small radio stations might need: audio files, data, and "metadata"; DJ and staff information, schedules, live music and program logs, and all sorts of other data. Currently, a cross-platform PHP application is the focus of the project, but more features and types of programs are planned that will hopefully enable easier playback, storage, loading, and entering for all types of applicable data.
Zephyr Basecamp is a functioning GTK frontend and PostgreSQL backend enterprise project that gives small and midsize businesses the same level of inventory, order entry, sales tracking, and accounting functionality as would be expected from commercial applications. It has interfaces for both X11/GNOME/Linux and Windows.
XMLDB uses an RDBMS to persist arbitrary XML documents. Due to its storage mechanism, searching for and recalling documents is extremely quick. You can also perform XSL translation on documents with surprising speed. The library can be used in any program to store libxml2 documents. A PHP module is also included, making XMLDB into a complete three-tier Web application development suite.
Enzyme is an architecture for creating user-searching-user applications. Right now, it is primarily useful as a resume create/search and HR management system. However, it's potential uses are wide-ranging, and it offers PHP developers an alternative to relying on simple "keyword" searching systems.