Hi Matteo,

2013/6/26 Matteo Beccati <p...@beccati.com>

> I have mixed feelings... I see where this might come in handy, but I
> think it would be a bit too user-unfriendly.
>

I have mixed feelings for supporting direct binary support, too.

Main intension is faster bytea(binary) handling.

Without binary support, client has to encode binary via pg_escape_bytea
and server decode it before saving bytea data. When selecting, server encode
it by using PQescapeByeta algorithm, then client decode it by
pg_unescape_bytea.


> 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.

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.

Regards,

--
Yasuo Ohgaki
yohg...@ohgaki.net

Reply via email to