Documentation Index
Fetch the complete documentation index at: https://docs.aiparlance.org/llms.txt
Use this file to discover all available pages before exploring further.
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 | — |
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 |
snake_case, plural table names.
UUID and audit
id: uuid by defaulttimestamps: created_at, updated_atsoft_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
