Database

Infra extensions on the entity model. Base: crm-reference.aip. Spec: Specification.

Supported databases (v0.1)

Database	Language (`app`)	Transpiler v0.1
PostgreSQL	`postgres`	Planned (primary)
MySQL	`mysql`	Planned
SQLite, MariaDB, MongoDB, …	Roadmap	—

You can declare database mysql in the spec today; DDL generation is not shipped yet (transpiler matrix).

app CRM @0.1 {
  database postgres
}

Migrations

Generated from entity with implicit fields in DDL.

CREATE TABLE users (
  id UUID PRIMARY KEY,
  name TEXT NOT NULL,
  email TEXT UNIQUE NOT NULL,
  created_at TIMESTAMPTZ NOT NULL,
  updated_at TIMESTAMPTZ NOT NULL
);

`seed`

seed User {
  name: "Administrator"
  email: "admin@example.com"
  role: admin
}

Indexes and constraints

index Lead {
  status
  created_at
}

Modifier	SQL
`required`	`NOT NULL`
`unique`	`UNIQUE`
`belongs_to`	`REFERENCES …`

Naming

Entity	Table	FK
`User`	`users`	`user_id`
`SalesOrder`	`sales_orders`	`sales_order_id`

Rules: lowercase, snake_case, plural table names.

UUID and audit

id: uuid by default
timestamps: created_at, updated_at
soft_delete: nullable deleted_at

Semantic types → PostgreSQL

AI Parlance	PostgreSQL
`email`	`TEXT` + app validation
`json`	`JSONB`
`datetime`	`TIMESTAMPTZ`
`phone`	`TEXT` + normalization

Flow

entity / index / seed (.aip)
↓
AST
↓
Database Generator
↓
DDL / migrations / ORM

​Database

​Supported databases (v0.1)

​Migrations

​seed

​Indexes and constraints

​Naming

​UUID and audit

​Semantic types → PostgreSQL

​Flow