I was excited as I recently discovered Backdrop and I'm now evaluating it as potential upgrade for several Drupal 7 sites - some of them need access to a PostgreSQL database (in custom modules).
I understood that Backdrop core only works on MySQL, but the documentation suggests that it is possible to use other external databases (see https://docs.backdropcms.org/documentation/database-configuration#other-...).
However, I did not succeed in accessing my external database. If I follow the documentation exactly, I get the following error message:
$result = db_query("SELECT * FROM mytablename", array('target' => 'mydatabase')); SQLSTATE[42S02]: Base table or view not found: 1146 Table 'backdrop.mytablename' doesn't exist: SELECT * FROM mytablename; Array ( [target] => mydatabase )
It seems that the target option is completely ignored, as it tries to access the backdrop core database.
It seems that the given example for db_query is wrong, as options should be the third, not the second parameter.
But even when I change the call to db_query and add an empty array as the second (args) parameter, the result is the same (only that the array in the error message is empty).
Has anybody succeeded in connecting Backdrop to an external database? Looking at the code, it does not look like it is possible. But I was just hoping for it as the documentation clearly provides this option.