mysql connection, transactional, pdo or mysqli??

Hello, I remember once Albert said always use mysql transactional connection, there was a lot of discussion, but that was the conclusion, hence since then I’m using this always transactional and avoid using PDO…

now i see no more transactional in sc9? only PDO and the new mysqli… anybody or Albert please explain which one to to use and simply what is the difference in scriptcase??

thanks in advance

Yes, I know that SC had issues with PDO, but nowadays I would go for PDO.

thanks Albert, will try it and see if any issue
cheers

My thoughts are to go with Mysqli - “I” is for improved and what stuff like Joomla uses as standard, just be sure it is turned on in your config.php when you deploy