IRM is a Web-based asset tracking and help desk/work request system built for IT departments and help desks. It keeps detailed information about each computer, as well as a complete history of work requests. It keeps track of detailed computer information such as CPU type/speed, amount of RAM, Hard Drive Size, serial numbers, etc. The system includes the ability to track networking hardware and any type of software. Also included is support for email notification of both users and technicians, and some support for monitoring computer systems via SNMP.
Jacquard is a Web-database integration toolkit, written as a Java Servlet package. It is designed to make it extremely easy to build two- and three-tier client-server applications which will be completely portable to any hardware platform and operating system which supports a Java 1.2-compliant JVM or a JDBC 2.0-compliant database management system, or any Web server or Web Application Server which supports the JSDK 2.0 API.
Metabase is a DBMS-independent PHP API to access SQL databases. It supports MySQL, PostgreSQL, Oracle, Microsoft SQL server, Microsoft Access, ODBC, Interbase, Informix, MiniSQL, and SQLite. It supports nested transactions, blobs, and prepared queries. It can install database schemas defined in a DBMS independent XML format that describe tables, indexes, primary keys, and auto-increment sequences. It is also able to upgrade a database to a new schema without affecting the data that was stored since it was installed or upgraded for the last time. There is also schema reverse engineering support.
Database Abstraction Layer is a project to produce a general way to access databases from within PHP. The DAL class takes care of the administration involved with the different kinds of databases. DAL is extendible via plugins so support for different dbms' can be added dynamicly. Also switching from one DBMS to another is simple because not very much has to be altered to support the new DBMS.
phpSQLGen provides functions for generating SQL queries, HTML tables, and XML documents. It consists of two classes and a set of utility functions. SQLGen provides PHP functions for generating SQL query strings from arrays, and TableMaker generates an HTML table or XML document from an ADOdb result set or an array. Since the output of each SQLGen method is a SQL query string, the library is compatible with ADOdb, PEAR DB, PHPLib, and any other database abstraction layer that can execute SQL query strings. This is useful for constructing complicated SQL queries that vary according to the situation. Different if-then clauses can push items onto from the argument array - SQLGen will take care of inserting commas and "ands" into the query string as necessary. This can be used together with the ability to populate an array directly from a form for the automatic generation of SQL queries from form variables.