MOT

MOT is long since obsolete -- it hasn't run on php or mysql for serveral major versions. This web page is still here only for historical purposes. -hal

Introduction

Features

Requirements

Download

Documentation

Resources

Demonstration

Development

Introduction

MOT is a generally useful web database that can be used to create web-based databases without writing a single line of code (sql, php, or html!). It is my hope that mot will be used to create anything from job and project tracking systems, to inventories, to catalogues and pretty much anything else for which relatively simple databases are used.

Best of all, MOT is free software, released under the GPL. This basically means you are free (even encouraged) to take and use MOT however you want. The only restriction is that you have to share any changes you make under the GPL as well. See the COPYING file for a detailed explanation of the GPL.


Features

MOT's features include:

  • The ability to create and modify databases, tables, fields, and permissions, all from a point and click, web interface.
  • Support for links between tables. Jobs may be linked to users, equipment, and software. People may be linked to department, companies, contacts, and machines.
  • Support for multiple users and read, add, and modify permissions for each user for each table.
  • Support for sorting and restricting every table to a fully configurable set of fields (sort a list of jobs by priority, close date, or tech, or restrict the same list of jobs to a specified contact).
  • Support for actions, which are custom scripts automatically fired by specified database actions (adds, modifications, etc.). This is immensely helpful for implementing things like email notification and timestamping.
  • Basic support for writing custom sql queries. This will eventually include a custom query page but is very helpful now in the creation of actions. A sample mot_sql query that joins three tables together and grabs a value from the third table looks like:
    select {People}.[email] from {Jobs} <Users> <Personal Information> where {Jobs}.[id] = $row_id
  • Support for importing and exporting database schemas.
  • Support for database-specific help files. All you have to do is write the text.
  • Basic searching capabilities.
  • CSS support for configuring the interface.

Requirements

MOT relies on the following programs. You must acquire and install these programs before installing MOT:


Download

Go to the Source Forge download page:


Documentation

View the MOT adminsitration help pages:


Resources

MOT has a mailing list. To subscribe, send a message to mot-request@listserv.nvgc.vt.edu with a line of 'subscribe mot'.

In case you're looking for the old home page, you can find it here:


Demonstration

Of course, the best way to see what MOT is about is to try it out ! Here are some screenshots that'll give you an idea of what it looks like in the meanwhile:


Development

MOT's development site is hosted by Source Forge. Follow the below link to access MOT's CVS archive, bug and project tracking systems, public forums, and lots of other great development tools.

Many thanks to the great folks at Source Forge and VA Linux, who are hosting not only this web site, but also the whole devlopment infrastructure (CVS, mailing lists, etc.) for MOT.


Hal Roberts Last modified: Tue Mar 9 08:49:00 EST 1999