MySQLi or MySQL(PDO) when installing Joomla ?

[joomiro]

Hi.

I am about to ask a stupid question, but I hope there are people that also have this issue and are afraid to ask such a stupid thing

Which database option is better to choose during Joomla! installation process? MySQLi ot MySQL(PDO)? Is the second option better and more SECURE, because of its prepared statements?

MySQL is deprecated. Does this mean that MySQL(PDO) will not work properly? (Why its not MySQLiPDO)

I can switch the options after installation, but will this cause problems with my site in the future?

This issue may sound stupid and not so significant, but for me is important to know which option to choose, especially if I will not be able to switch the options later without bad consecuenses.

Thanks for your time devoted and commitment in advance I appretiate every answer

[astridx]

You should use MySQLi.
Here you can finde more informations about this topic: http://php.net/manual/en/mysqli.overview.php

[joomiro]

Thanks for your quick reply @astrdix. But why? What's wrong with the PDO option up to you? The link you've posted gives definition for mysqli and pdo, but doesn't point which is better.

In fact I am asking this question in Joomla context? Not which is better in general (mysqli ot pdo)

[astridx]

Please use "mysqli" because this method is new, more powerful and safer. The I is standing for improved. You could also use "mysql" directly. There should not be an difference in the operation of Joomla!. You should easily can switch between settings.
But I have no experience in swithing between the settings.

[joomiro]

I think you don't get my question. There are 3 options: Mysql, Mysqli and MysqlPDO. I am asking about the difference between mysqli and mysqlPDO. I know that Mysql is deprecated as I mentioned it in mu question

[fcoulter]

Hi.

I am about to ask a stupid question, but I hope there are people that also have this issue and are afraid to ask such a stupid thing

It is not a stupid question, you should not be afraid to ask.

Which database option is better to choose during Joomla! installation process? MySQLi ot MySQL(PDO)? Is the second option better and more SECURE, because of its prepared statements?

Both are secure.It is not a reason to choose between them. Insecurities tend to creep in if they are used improperly eg in a badly coded 3rd party extension. The solution is to be careful which extensions you use

MySQL is deprecated. Does this mean that MySQL(PDO) will not work properly? (Why its not MySQLiPDO)

No, MySQL and MySQL(PDO) are different PHP extensions.

I can switch the options after installation, but will this cause problems with my site in the future?

No, it should make no difference whatsoever. The point about the Joomla database drivers is that they provide a way for programmers to write database queries that should work on any supported database, regardless of the database type or the API used. From the point of view of a site owner these issues should be invisible.

The only time the choice might matter that I can see is if the PHP on your server did not include a particular extension, in which case it would force your choice.

[joomiro]

@fcoulter, thank you for the PERFECT and detailed answer. I appretiate your effort and time