#2116 - PDO database drivers (beyond MySQL)

By Chris Graham
Added 13th Dec 2015, 11:12 AM
6 views

Identifier	#2116
Issue type	Feature request or suggestion
Title	PDO database drivers (beyond MySQL)
Status	Open
Handling member	Deleted
Addon	core_database_drivers
Description	Have a PDO database driver for MySQL, 'mysql_pdo'. Make it share the super class with 'mysql'. [EDIT: This now done] Then do: - postgresql_pdo - sqlserver_pdo (http://php.net/manual/en/ref.pdo-sqlsrv.php) - oracle_pdo
Steps to reproduce
Funded?	No

The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".

Rating

Unrated

Comments

By Guest posted 13th Dec 2015, 11:14 AM

This can replace DBX, which was taken out of the core PHP, and has not been updated since 2011.

https://pecl.php.net/package/dbx

Seems there was a battle between DBX and PDO that we didn't notice.

By Guest posted 17th Nov 2017, 8:27 PM

I don't think we really care about PDO, but I want to track this. I've never encountered a server without a native MySQL extension if it has MySQL on it. And for PostgreSQL or SQL Server or Oracle, you can expect to use the native extension also (with the exception that SQL Server accessed from a Linux or Mac box will have to use ODBC, which I have just implemented).

By Guest posted 5th Mar 2019, 8:08 PM

A user in here had a crash with mysqli https://compo.sr/forum/topicview/browse/deploying/error-503-showing-up.htm?post_id=5095&redirected=1#post_5095
This could not be resolved without forcing the code to not be type-strict (i.e. not reading in mysql field metadata).

Therefore I've now implemented a mysql_pdo database driver to see if this can work as a substitute on his server.

Server instability on particular DB client architectures is possible due to all the plumbing involved.

#2116 - PDO database drivers (beyond MySQL)

Rating

Comments

Statistics