Andromeda's full set of database programming features
includes dozens of automations, switches, and flags
that, when taken together, can be used to fully specify
a database and its application logic together in a single
place. The Andromedda builder program then builds the
database and generates code that enforces the entire
Andromeda database programming
features fall into these categories:
- Database Structure - the basic definition of tables,
columns, keys and indexes.
- Automations - automatically generating values
from other values, copying values from one table to
another, generating histories.
- Security - restricting which groups can
access which tables, and restricting which groups
can access specific columns or rows within a table.
- Constraints - Preventing an update or delete
under certain conditions, or disallowing certain
values in columns.
- Extensions - extensions to basic database
concepts, such as ranged primary key (begin and end values
that may not overlap), and additional foreign key
- UI Information - additional information
that is used by the user interface.
The following pages detail how to make use of these features.