Xyndravandria Dyverath composes and executes MySQL database queries programmatically. It represents a database system with PHP classes. Other classes are available to compose other parts of the queries like conditions, fields, values, limit clauses, etc. A separate class can also query database table metadata like table fields and primary keys.
PHPGrid generates fully-functional grids with minimal coding, with add, edit, del, auto-filter, search, sort, page, grouping, export, custom add/del calls, grid-subgrid, multiple databases, multiple themes, and much more. It saves development time and effort for creating repetitive CRUD functions. The custom SELECT query option is useful for cross table data and report generation. It supports all major databases.
univis2typo3 is a tool to import data from UnivIS into a TYPO3 Web site. This lets you create a Web site for a university department with a few clicks. It automaticaly imports information about people, lectures, projects, publications, and other department information. It has a user-friendly interface to create and edit personal and course Web pages. It can automatically backup and update the data. The Web site will remain available even if the UnivIS server becomes unavailable.
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.
TIPP is an IP planning application for network departments of organizations with medium- to large-sized networks. While providing all the necessary functions for keeping track of your IP and network allocations, it combines simplicity of design and use with a clean and thoroughly modern look and feel.
Uhura is a Web console for databases. It works with MySQL, PostgreSQL, and FirebirdSQL. It presents trees that let you browse databases, tables, columns, constraints, triggers, views, and procs. It has panels for history and fragments. Its editor features autocompletion and autoindenting. It is easy to install.
as_nightjobs is a PHP class that can be used to perform several site maintenance tasks. It can take backups of database tables to compressed XML files, rotate backup files while deleting files older than a given number of days, remove files from given directories that match certain name patterns or time periods, delete obsolete records from certain database tables, check and optimize MySQL database tables, calculate space occupied by site files and data in MySQL tables, and estimate the number of days before the site files exceed a given disk space limit.
Lumbricidae WORM (Widget Object Relational Mapper) is an SQLAlchemy binding for Webwidgets. SQLAlchemy presents database tables and rows as Python classes and objects. Webwidgets is a framework for writing Web applications as if they were desktop applications. WORM lets you easily map Webwidgets input fields, tables, and other widgets to database mapped classes, instances, and attributes. It requires the Argentum SQLAlchemy convenience library.