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.
pg_collkey is a wrapper to use the collation functions of the ICU library with a PostgreSQL database server. Using this wrapper, you can specify the desired locale for sorting UTF-8 strings directly in the SQL query, rather than setting it during database installation. Default Unicode collation (DUCET) is supported. You can select whether punctuation should be a primary collation attribute or not. The level of comparison can be limited (in order to ignore accents, for example). Numeric sequences of strings can be recognized, so that 'test2' sorts before 'test10'. This library is dependent on ICU.
refbase is a Web-based bibliographic manager that can import and export references in various formats (including BibTeX, Endnote, ISI, RIS, PubMed, MODS XML, OpenOffice, and Word 2007 XML). It can make formatted lists of citations in HTML, RTF, PDF, or LaTeX, and offers powerful searching and RSS support. Its OpenSearch and SRU/W services and support for unAPI and COinS metadata allow for easy access by clients and search engines.
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.
bemDB is a PostgreSQL database designed to store benefit and enrollment information for members of group health insurance plans. Its main feature is the ability to output HIPAA-compliant 834 Benefit Enrollment and Maintenance EDI transaction sets with all required segments and situational segments for which there is data.
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.
DBAHelper is a collection of scripts to ease the daily maintenance work of Oracle database administrators. Examples are moving objects between tablespaces, analyzing schemata, and rebuilding invalid indices. Also included is a little framework to simplify the use of RMAN (this framework depends on the use of Oracle 10g with the Recovery Area enabled and properly sized, so all backups go there).