As per this ADR, the application must store data in the 'Academies Database' which runs on Microsoft SQL Server.
As this setup is relatively unconventional, this documentation may be of use.
See the Setup Microsoft SQL Server in the getting started documentation for more information.
As SQL Server does not run natively on macOS we use the Azure SQL Edge image. See this ADR for the reasons behind this choice.
The script/server script will create the appropriate containers for you.
See the getting started and developer scripts documentation for more.
Azure Data Studio is a native application to connect to the local SQL server.
In an unfortunate naming collision, the term 'schema' is used in SQL Server to allow:
...for more flexibility in managing database object permissions.[1]
In production, the application only has access to a single schema (complete)
and creates all database tables within that schema.
Locally, the overhead of creating and maintaining the login, users, schemas and
permissions was felt to be to high and so we do not use a custom schema in our
development setup, creating tables in the default dbo schema.