Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:100808 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 71424 invoked from network); 2 Oct 2017 08:47:36 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 2 Oct 2017 08:47:36 -0000 Authentication-Results: pb1.pair.com header.from=lester@lsces.co.uk; sender-id=pass Authentication-Results: pb1.pair.com smtp.mail=lester@lsces.co.uk; spf=pass; sender-id=pass Received-SPF: pass (pb1.pair.com: domain lsces.co.uk designates 185.153.204.204 as permitted sender) X-PHP-List-Original-Sender: lester@lsces.co.uk X-Host-Fingerprint: 185.153.204.204 mail4.serversure.net Linux 2.6 Received: from [185.153.204.204] ([185.153.204.204:41812] helo=mail4.serversure.net) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 43/6B-34435-52DF1D95 for ; Mon, 02 Oct 2017 04:47:35 -0400 Received: (qmail 5671 invoked by uid 89); 2 Oct 2017 08:47:30 -0000 Received: by simscan 1.3.1 ppid: 5665, pid: 5668, t: 0.4627s scanners: attach: 1.3.1 clamav: 0.96/m:52/d:10677 Received: from unknown (HELO ?10.0.0.7?) (lester@rainbowdigitalmedia.org.uk@81.138.11.136) by mail4.serversure.net with ESMTPA; 2 Oct 2017 08:47:30 -0000 To: internals@lists.php.net References: <25903b1e0fc5a726e44b1e3a5ab4aec4@bohwaz.net> <0607d622-caa9-ae1d-33db-1958a0ff0500@gmx.de> <20171001185540.5e572e58@platypus> Message-ID: Date: Mon, 2 Oct 2017 09:47:30 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: en-GB Content-Transfer-Encoding: 7bit Subject: Re: [PHP-DEV] Re: [RFC] [Discussion] Implement SQLite "openBlob" feature in PDO From: lester@lsces.co.uk (Lester Caine) On 02/10/17 01:48, BohwaZ/PHP wrote: > So for me the use case is quite different here, and openBlob allows > stuff that PDO::PARAM_LOB with bindColumn and bindParam cannot allow > currently. In conclusion openBlob is still useful as it allows accessing > a BLOB outside of a statement and allows to read and write at the same > time without having to load the blob in memory. This is where the limitations of some of the other database engines come into play. In many cases in shared hosting, the database is provided on another machine, so one has to transfer the data results between machines and do not have direct access to the data. PDO can't emulate this function so the question is still SHOULD something that can't be made generically functional be allowed in PDO. Personally I would prefer that for this sort of action the generic driver was used used rather than PDO and I have to do that for other functions in other databases currently anyway. So one does not have to overload PDO with more checks as to if your code will work on the different drivers. -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk