Solved Local and external database connections in Joomla 5.x

[Trembowiecki]

Hi,

regarding Joomla 5, when I want to connect to a local database, I can use:

1) $db = Joomla\CMS\Factory::getContainer()->get('DatabaseDriver');
$query = $db->createQuery();

or

2) $db = FabrikWorker::getDbo();
$query = $db->getQuery(true);

because

3) $db = JFactory::getDbo();
$query = $db->getQuery(true);

is deprecated, right? So... what's the status of 2)? Will it be deprecated too in near future, as 3) has been? To avoid that I switched to 1), BUT the problem is: with 2) I could easily connect to external database, I just had to add another connection to Fabrik and use:

$db = FabrikWorker::getDbo(false, 2);
$query = $db->getQuery(true);

I don't know how to do this with 1). So, in Joomla 5 what is the best way to connect to local and external databases?

 

[achartier]

You should probably continue to use #2 if you are using additional Fabrik connections. This function (or some equivalent) is never going away. Also, you can use createQuery in #2 and it is the correct call going forward.

 

[Trembowiecki]

Thank you very much! At last I know what I'm doing.