Re: pgsql: Binary data support improvement
| From: | Yasuo Ohgaki | Date: | Tue, 02 Jul 2013 18:17:30 +0000 |
| Subject: | Re: pgsql: Binary data support improvement | ||
| References: | 1 2 3 4 5 6 7 8 | Groups: | php.internals |
| Request: | Send a blank email to internals+get-68039@lists.php.net to get a copy of this message | ||
Hi Matteo,
2013/7/2 Matteo Beccati <php@beccati.com>
> I'm talking about parameters, not results. The speedup would be only for
> inserts, not selects (which would require something that's not available
> in libpq).
>
For insert or update, binary can be inserted/updated directly.
If we do this transparently to users, we need additional select query to
system catalog to find field type.
Since pgsql is not a db access abstraction layer, adding a array parameter
that indicates which field is binary or text may be the way to go. Lack of
reverse operation would be problematic, though.
We may wait until PostgreSQL implements appropriate API.
Regards,
--
Yasuo Ohgaki
yohgaki@ohgaki.net