triad-drizzle

Drizzle bridge

The Drizzle bridge is not a migration tool. It reads .storage() hints on your models and emits a Drizzle schema file that you then check in. triad db generate regenerates the file when schemas change. You can hand-edit the generated file if you need features Triad doesn't model — but beware that running the generator again will overwrite it.

Marking a model as a table

Every field that should become a column must be on a t.model that has at least one field marked .storage({ primaryKey: true }). Models without a PK hint are not treated as tables and are skipped silently.

export const Pet = t.model('Pet', {
  id:        t.string().format('uuid').identity().storage({ primaryKey: true }),
  name:      t.string().minLength(1).maxLength(100).storage({ indexed: true }),
  species:   t.enum('dog', 'cat', 'bird', 'fish').storage({ indexed: true }),
  age:       t.int32().min(0).max(100),
  status:    t.enum('available', 'adopted', 'pending').default('available'),
  createdAt: t.datetime().storage({ defaultNow: true }),
});

.identity() is the DDD identity marker; .storage({ primaryKey: true }) is the persistence hint. They are different and most ID fields need both.

.storage() options

Option	Effect
primaryKey: true	Marks the field as the table's PK (required to become a table)
unique: true	Unique constraint
indexed: true	Secondary index
columnName: 'user_id'	Override the SQL column name
defaultNow: true	Default to CURRENT_TIMESTAMP
defaultRandom: true	Default to a random UUID
references: 'projects.id'	Foreign key reference
custom: { ... }	Dialect-specific hints

.storage() accumulates across calls — you can chain multiple to layer hints.

Dialects

sqlite, postgres, mysql. All three emit valid Drizzle sqliteTable/pgTable/mysqlTable definitions. Type mapping is logical:

Triad type	Drizzle (SQLite)	Drizzle (Postgres)	Drizzle (MySQL)
t.string()	text	text	text
t.string().format('uuid')	text	uuid	varchar(36)
t.datetime()	text (ISO)	text (ISO)	text (ISO)
t.int32()	integer	integer	int
t.int64()	integer	bigint	bigint
t.float64()	real	doublePrecision	double
t.boolean()	integer (0/1)	boolean	tinyint
t.enum(...)	text + CHECK	text (or pgEnum if configured)	text
t.array / t.record / ...	text JSON	jsonb	json