User:Timhowardriley/Appaserver

Appaserver is a web-based, Mysql user interface. Appaserver allows programmers to build computer applications without programming. Programmers configure screens by inserting tables, columns, and relations into tables.


 * Surrogate keys are not used. Instead, Appaserver uses each table's natural primary key — mitigating data duplication.
 * Appaserver enforces data integrity. No more mismatched identifiers.
 * Relations are maintained from within. When a primary key is changed, the update cascades throughout the foreign keys across related tables. Deletes also cascade.
 * Appaserver supports inheritance.

Generally speaking, Appaserver is machine that generates computer screens. The screens allow you to select, insert, update, and delete every column in every row in every table.

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 columns. With a push of a button you can create time charts and histograms on numeric columns.

Appaserver is secure. Group your 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.