Appaserver
Appaserver DFD

Appaserver is a application server that allows you to build commercial-quality, multi-user database applications. It runs extremely well on Linux. Appaserver implements the relational model, coupling MySQL with a browser.

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.

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

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.

After building your database, you need to write the processes that do your customers' 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.

Appaserver was originally written to store measurements and related meta-data for the Everglades National Park. The hydrology measurement table currently has 748 million rows and grows 45,000 per day. Here is the Hydrology Database Schema. The water quality results table has 5.1 million rows. Here is the Waterquality Database Schema.

The following tutorials are available:

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

For a technical overview view the:

  1. Appaserver Database Schema
  2. Appaserver Data Structure

Appaserver is freely available under the GNU software license. Free (limited) support is available. The source code is hosted at Github.