Appaserver is an application server that allows you to build commercial-quality, multi-user database applications quickly and completely. It runs on any UNIX^®-flavored operating system, including Linux ^®. Appaserver implements the relational model, coupling MySQL with a browser.

Appaserver was born at the research center of the Everglades National Park as DataForEVER. While running Appaserver, a Ft. Lauderdale seagrass lab received a call from a marine biologist. The marine biologist asked to examine the stomach contents of any Crested Gobys the lab may have caught. The seagrass lab's director reported back they had 15 of them caught between 2005 and 2009, averaging 34 1/4 millimeters in length. This information was produced in only six clicks. Moreover, by clicking the detail button next to each of the 15 measurement records, the director was able to determine in which bucket each fish was stored. Appaserver easily produced this random data request.

Appaserver is a MySQL user interface. Its forte is to build database applications without painting or programming the user interface. Once you've conceptualized your database, simply insert the elements — tables, columns, relations, and roles — into the Appaserver engine, then log in.

Web forms are created dynamically, allowing you to select, insert, update, and delete everything in your database. But this is only the tip:

• Top/bottom, one-to-many screens are automatically produced.
• Query screens are automatically produced.
• With a push of a button you can compute statistics on numeric fields. (e.g., avg, min, max, standard deviation, etc.)
• With a push of a button you can create time charts and histograms on numeric fields.
• Relations are maintained from within.
  • You can update primary keys. Then the update cascades throughout the foreign keys across related tables.
  • You can delete rows without creating orphans.
  • Surrogate keys are no longer necessary! And because they are not natural to real-world phenomena, they are undesirable anyway. Instead of surrogate keys, Appaserver uses each table's natural primary key.

Appaserver is flexible. Because ideas inspire ideas, Appaserver was designed for expansion. New elements are easily added to the engine, and residual elements are easily removed.

Appaserver is secure. You group users into roles, and then provide table-level access (select, insert, update, and delete) to each role. However, table-level access may be insufficient; therefore, row-level and column-level access can further be restricted. Finally, Appaserver supports the Secure Socket Layer (SSL).

After building your database, you need to write the processes that do your customer's work. To help you, Appaserver comes with a rich set of libraries from which you can build upon. Alternatively, any process using the Common Gateway Interface (CGI) will seamlessly migrate.

The following powerpoint tutorials are available:

1. Structured Database Running on Appaserver
2. Create Purchase Order Application Using Appaserver
3. Install Appaserver

For a technical overview, view the Appaserver Database Schema.

Appaserver is freely available under the GNU software license, and free (limited) support is available. The download site is here.