View Issue Details

IDProjectCategoryView StatusLast Update
0002116Composrcore_database_driverspublic2019-11-15 19:55
ReporterChris GrahamAssigned To 
Severityfeature 
Status non-assignedResolutionopen 
Product Version 
Fixed in Version 
Summary0002116: PDO database drivers (beyond MySQL)
DescriptionHave 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
TagsNo tags attached.
Attach Tags
Time estimation (hours)6
Sponsorship open

Activities

Chris Graham

2015-12-13 16:14

administrator   ~0003247

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.

Chris Graham

2017-11-18 01:27

administrator   ~0005216

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).

Chris Graham

2019-03-06 01:08

administrator   ~0005932

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.

Issue History

Date Modified Username Field Change
2017-11-06 12:05 Chris Graham Additional Information Updated View Revisions
2017-11-06 12:09 Chris Graham Description Updated View Revisions
2017-11-06 12:09 Chris Graham Additional Information Updated View Revisions
2017-11-06 19:46 Chris Graham Description Updated View Revisions
2017-11-18 01:18 Chris Graham Additional Information Updated View Revisions
2017-11-18 01:26 Chris Graham Additional Information Updated View Revisions
2017-11-18 01:27 Chris Graham Note Added: 0005216
2019-03-06 01:08 Chris Graham Note Added: 0005932
2019-11-15 19:55 Chris Graham Summary PDO database driver for MySQL => PDO database drivers (beyond MySQL)
2019-11-15 19:55 Chris Graham Description Updated View Revisions
2019-11-15 19:55 Chris Graham Additional Information Updated View Revisions