Migrations

The website is currently built from a GraphQL schema that is derieved from a homegrown Directus endpoint. While Directus uses SQL internally to provide its database management capabilities, it also exposes its own custom schema format.

Since tables and their dimensions are managed with Directus, it appears to also use it for schema management. An SQL-based approach would have to mimic this, and account for Directus specifities.

It is possible to use the schema in two ways:

• programmatically with the Directus CLI
• for ClickOps via an extension

–

Here we would like to:

• establish a basic understanding of how schema management works with Directus
• sketch a workflow for ad-hoc schema management via the extension, eventually aiming at local development
• sketch a workflow for programmatic schema management, which allows for versioning and migrations