Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:100820
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain bohwaz.net designates 5.135.163.151 as permitted sender)
To: Adam Baratz <adambaratz@php.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 8bit
Date: Wed, 04 Oct 2017 11:49:23 +1300
Cc: internals@lists.php.net
In-Reply-To: <CADxrgCMmPw84Kj9nYAs6LNcXDFoupFR2F_wog2--E02Bcra3gw@mail.gmail.com>
References: <25903b1e0fc5a726e44b1e3a5ab4aec4@bohwaz.net>
 <0607d622-caa9-ae1d-33db-1958a0ff0500@gmx.de>
 <20171001185540.5e572e58@platypus>
 <dc5f105093c2613e5cde97f9eb4833ce@bohwaz.net>
 <CADxrgCMmPw84Kj9nYAs6LNcXDFoupFR2F_wog2--E02Bcra3gw@mail.gmail.com>
Message-ID: <ac9c676fe548a6a00608d318e986b474@bohwaz.net>
User-Agent: Roundcube Webmail/1.1.5
Subject: Re: [PHP-DEV] Re: [RFC] [Discussion] Implement SQLite "openBlob"  feature in PDO
From: php@bohwaz.net (BohwaZ/PHP)

> I believe that's how PDO::PARAM_LOB is intended to work (based on my
> reading of the docs and implementations for other drivers). It seems 
> like
> more of a convenience than anything, though maybe someone had more 
> ideas
> for how it should work across drivers and never got to follow through 
> on it.

This is not how I understand the documentation:

"PDO::PARAM_LOB tells PDO to map the data as a stream, so that you can 
manipulate it using the PHP Streams API."

But this seems to be quite chaotic, reading 
https://secure.php.net/manual/en/pdostatement.bindcolumn.php

"Since information about the columns is not always available to PDO 
until the statement is executed, portable applications should call this 
function after PDOStatement::execute().

However, to be able to bind a LOB column as a stream when using the 
PgSQL driver, applications should call this method before calling 
PDOStatement::execute(), otherwise the large object OID will be returned 
as an integer."

This is quite confusing.

And as stated above, with MySQL and SQLite it returns the LOB content as 
a string on PHP 7+ but a stream handle on PHP 5.6…

To me it seems that the LOB handling of PDO via bindColumn/bindParam is 
completely broken and inconsistent currently :(

If I have more time available after this RFC I'll look into fixing it 
for PHP 7.3.

> I'd love it if PDO had better BLOB/LOB types and if we had a better
> pattern for driver-specific APIs, but I'm comfortable lumping those 
> goals
> under "future scope." Getting parity with ext/sqlite3 will make 
> pdo_sqlite
> more usable, which will help grow its community, and the number of 
> people
> who are able to contribute to these bigger projects. Deprecating the
> current set of driver-specific APIs in the future, if we have 
> functional
> equivalents, isn't an impossible project.

Yeah sounds good to me :)