Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:85938
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain beberlei.de from 74.125.82.44 cause and error)
MIME-Version: 1.0
In-Reply-To: <CAL0xaBGV1rC1uudiMamTB6DXe9QnaCrK9Z7qee_MT2-V_iSYjw@mail.gmail.com>
References: <CAMc0WS6q49-+ThWftnPwsb5ZMT_m3EVi1Eik_mO5WvtqmhBjeA@mail.gmail.com>
	<5537826A.9010209@gmx.de>
	<CAMc0WS4a_aqqeqHPccyFwKQYwngbP6BziqsjGzbmxQOp6sw2pg@mail.gmail.com>
	<5538881C.8010502@oracle.com>
	<5538C2A7.4050600@lsces.co.uk>
	<CAL0xaBHDZdveGO+38MqRad2eUux-k8+oAc09GjVGKWuD5QqgfQ@mail.gmail.com>
	<5538CF4B.5090401@beccati.com>
	<5538D9B0.5020507@lsces.co.uk>
	<CAL0xaBEix5PnetE-EhPVJc36SrXkH6kqi2EQXPOdnt-AsnRe_g@mail.gmail.com>
	<CAEPJdukVGuue2JF3oWtAPWvk8AUSO8ac==LmNMSnJ6vRbBYRow@mail.gmail.com>
	<CAL0xaBGV1rC1uudiMamTB6DXe9QnaCrK9Z7qee_MT2-V_iSYjw@mail.gmail.com>
Date: Fri, 24 Apr 2015 10:00:41 +0200
Message-ID: <CAEPJdukX3gJJRqdOis_4OkxcV=RT9+_gLAGnSh1LHUOC7G-c-Q@mail.gmail.com>
To: Arvids Godjuks <arvids.godjuks@gmail.com>
Cc: PHP internals <internals@lists.php.net>
Content-Type: multipart/alternative; boundary=089e01419d1cf0af27051473ca53
Subject: Re: [PHP-DEV] Re: PDO Oracle driver
From: kontakt@beberlei.de (Benjamin Eberlei)

--089e01419d1cf0af27051473ca53
Content-Type: text/plain; charset=UTF-8

On Fri, Apr 24, 2015 at 8:16 AM, Arvids Godjuks <arvids.godjuks@gmail.com>
wrote:

> 2015-04-24 4:42 GMT+03:00 Benjamin Eberlei <kontakt@beberlei.de>:
>
>> On Thu, Apr 23, 2015 at 3:45 PM, Arvids Godjuks <arvids.godjuks@gmail.com
>> >
>> wrote:
>>
>> > PDO is everywhere. Doctrine? Based on PDO.
>>
>>
>> You can use mysqli, oci8 or sqlsrv for example without problems in
>> Doctrine.
>>
>> Exposing some of the internal api of PDO as php functions (SQL Parser) I
>> would bet it is possible to reimplement PDO in PHP code using mysqli etc..
>> as "drivers".
>>
>> I think we could discuss going that road as well and we could save
>> ourselves maintaining some thousands of lines of C code.
>>
>
> May I question the sanity of the words written in this email? :D (it's a
> joke).
>

You may question my sanity, but I am totally serious.


>
> The whole point of mysqlnd drivers and other improvements was to cut down
> on data copying, improving performance and doing a lot of other stuff.
> Moving PDO to a PHP implementation will kill it all: preformance will
> suffer, memory usage will skyrocket, dealing with charsets - I don't even
> wana pretend I understand how to deal with that part in a proper fasion.
> Doesn't it require access to internal PHP api's to do a lot of what PDO and
> other native drivers do?
> Well, the Zephyr could pitch in here, MAYBE, depending on how good it
> actually is and what it can do, but still, it feels more like a cruch to me.
>

None of these will happen, because PDO doesnt add much value on top of what
the libraries already provide. For example MySQLi, pgsql, oci8 allready
handle charsets, we only need to delegate correctly.

See this very hacky prototype for PDO::prepare/query/bindValue/execute
using a to be exposed API for emulated prepares in PHP code (extracted from
existing PDO code).

https://gist.github.com/beberlei/3dfa960901533e859c02

This is a very thin layer of PHP and given PHP7 is already twice as fast as
PHP5 i don't think anyone would suffer.

--089e01419d1cf0af27051473ca53--