SEARCH:

Defining a Database

Andromeda places a very high emphasis on the database. This emphasis is very much greater than any other web framework or database framework that we know of.

Most of the advantages of Andromeda come from knowing how to use its very powerful database specification language to put all (or nearly all) of your business rules into the database specification. When this is done, you get synchronization for free – the structure of your tables exactly matches your code and the specification can be used to generate database technical documentation.

Table of Contents

YAML Syntax Primer
Columns and Tables
The Smallest Possible Andromeda Specification
Column Types
Predefined Columns
Reusing and Renaming Columns
Foreign Keys
Fetching a Price
Calculating Extended Price
Summing an Order
Many-to-Many
Cross References
The Upsave
History Tables
Constraints
Basic Security
Row-Level Security
Database Conclusion