Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:100806
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)
Date: Sun, 1 Oct 2017 20:41:31 +1300
To: Matteo Beccati <php@beccati.com>
Cc: Lester Caine <lester@lsces.co.uk>, internals@lists.php.net
Message-ID: <20171001204131.4079c882@platypus>
In-Reply-To: <afdf566e-d6a7-eb11-ad62-f727e4a11bfb@beccati.com>
References: <25903b1e0fc5a726e44b1e3a5ab4aec4@bohwaz.net>
	<CA+kxMuQ0p9qwCkxaUFQuR4C_JrPb1RtAguY3su3TvPsiUxOGEw@mail.gmail.com>
	<ee76dfe0-8bda-086a-33cd-d0f8c33aa071@lsces.co.uk>
	<86cad23e-a50b-515e-bc94-f98f813f1b05@beccati.com>
	<d35cd77f-84ec-aefa-7cfe-d6ad78747e56@lsces.co.uk>
	<afdf566e-d6a7-eb11-ad62-f727e4a11bfb@beccati.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] [RFC] [Discussion] Implement SQLite "openBlob"
 feature in PDO
From: php@bohwaz.net (BohwaZ)

On Wed, 27 Sep 2017 11:47:21 +0200 / Matteo Beccati <php@beccati.com>
said :

> On 27/09/2017 11:34, Lester Caine wrote:
> > openBlob is a specific feature of SQLite so the decision to use it
> > already rules out any other database. IN PDO access to it via the
> > generic blob functions is the proper way forward so that a call for
> > a blob gives a blob what ever the underlying datbase.
> 
> Seeing the RFC, I gave for granted that SQLite couldn't use the
> standard LOB api provided by PDO, but maybe that isn't the case? I'll
> leave the OP to reply.

I wasn't aware of that API, I saw what the postgreSQL driver was doing
and assumed it was the only way.

See my response to @cmb but it seems like a nice option, I'll assess
next week whether it can fit with the SQLite C API or not. Hopefully
it will!