Multiple database connections #EnhancementRequest

[klor]

Say I have a MySQL database with main contents for the site and a secondary SQLite database with project-specific contents.

I want to be able to create a separate database connection for each database.

Currently this is not possible because the instance() method only takes one value (Line 36):

self::$instance = new PDO($dsn, DB_USER, DB_PASS, $opt);

The request could be resolved by introducing a $dbConnectionName variable that (optionally) allow programmers to name each connection. To support this, instance() can name the connection like so:

$dbConnectionName = isset($dbConnectionName) ? $dbConnectionName : 'default';
self::$instance[$dbConnectionName] = new PDO($dsn, DB_USER, DB_PASS, $opt);

Programmers can now maintain connections to multiple databases, using code like this:

// Query DB1
$sql  = 'SELECT return, fields  FROM table WHERE search_field = ?';
$data = DB('db1'):prepare($sql)->execute([$search_val])->fetchAll();

// Query DB2
$sql  = 'SELECT return, fields  FROM table WHERE search_field = ?';
$data = DB('db2'):prepare($sql)->execute([$search_val])->fetchAll();