Configuration

perClass Mira currently supports 2 database types, MySQL and SQLite. The database can be configured by selecting Database from the Operator menu in developer mode, or by selecting Database in the toolbar in operator mode.

MySQL


For MySQL a server is required, this can be a local or remote, MySQL or MariaDB server. Host and Port should point to the server where the database is running, User and Password should be the credentials for the user to sign in as. Database should be the name of the database where the data should be stored, preferably a not yet existing database.


NOTE: Password will be stored encrypted in the mira.ini file.

SQLite


For SQLite no external software is required, the main database file itself will be "%APPDATA%/perClassBV/mira.db". Each session will also get its own database, called "session.db" in the session output directory.

Setup

Once the database is configured, press Save, for MySQL it will attempt to connect and sign in, if it succeeds the next popup will show, for SQLite it will always be shown.



Pressing No will return to the configuration dialog, pressing Yes will attempt to create the initial database structure. If the database is created successfully, then the following dialog will be shown.



A user is required to use a database, so one needs to be created, pressing No will return to the configuration dialog, pressing Yes will show the following dialog.



For more explanation, see the Users section, the only difference is that the first user will always have Developer permissions.