Engine - Database - Connections

[ollieread]

TheGamePanel needs to be able to connect to 1 or more separate databases.

Features

The following are features that the connection subcomponent should have.

Multiple Connection Support

There should be support for multiple separate connections. The core and first-party components/modules will only ever use one, but support can be added for multiple, with little extra effort, to support future situations where one is required.

Multiple Driver Support - Hidden

The panel will initially be built assuming MySQL or a compatible MariaDB, but internally, there should be support for multiple different types, PostgreSQL, MSSQL, etc. This should be exposed as yet, as everything should default to MySQL/MariaDB, but the inner workings should be present to better facilitate it in the future without the need for any large refactors.

Primary Connection

Of the connections, there should be the ability to designate one as the 'primary connection', meaning that it's used by default for anything that doesn't specify the connection needed.