Re: pgsql: Binary data support improvement

On 26/06/2013 11:51, Yasuo Ohgaki wrote: > Hi Matteo, > > PDO_pgsql on the other hand, when used with explicit parameter binding, > could automatically use binary format for LOB fields. > > AFAIK, PDO doesn't handle bytea data natively. It does, as far as I remember. See PDO::PARAM_LOB We could easily (and transparently) use binary for the parameters explicitly bound as LOB, but I see no way we can use binary for results -- which usually is the most common operation. Maybe it's better than nothing though? > There may be clever usage, but binary support is only for faster bytea > handling. > API isn't great, so if there are objections, I'll spend time rather than > this. I think the API would become cumbersome and error-prone, although I see the benefits in bytea-intensive scenarios. My vote is: +0 If we only could figure out a better API, that could turn into a +1... Cheers -- Matteo Beccati Development & Consulting - http://www.beccati.com/