Aleksander,
my problem would be solved if the patch I sent to Maciej Sobczak
2010-03-01 would be applied to the soci- sources.
I haven't got any feedback from Maciej so far. That patch only modifies
the postgresql backend and allows
transfer of binary data with BYTEA, and does not touch mysql backend.
Regards Gerwin
PS: By the way, the problem I had when reading the documentation was, that
the term 'blob' means very different
things in the sql context: For mysql it means data type TINYBLOB,
MEDIUMBLOB etc, but SOCI it describes the access
method to long binary data that looks like a stream as implemented in
postgresql. To help others not to fall into
the same trap: Is it possible to add small comment in the documentation
that describes the blobs?
Pawel Aleksander Fedorynski <[email protected]> schrieb am 25.03.2010
04:37:51:
> On Fri, Feb 26, 2010 at 8:43 AM, <[email protected]> wrote:
> >
> > Hi soci-team, Aleksander
> >
> > meanwhile I tried to solve the problem by my own by modifying the soci
> > postgresql backend:
> >
> > - added possibility to transfer distinct columns to the server in
binary
> > format. So I don't need to PQexcapeByteAConn / PQescapeStringConn
which
> > would be very ineffectiv in my case.
> > - x_stdstring is now transfered binary to the server, but fetched as
and
> > therefore PQunexcapedByteaConn()ed if it came from a bytea column.
> > - added additional postgresql backend test11 similar to mysql backend
test6
> > to demonstrate functionality.
> > - modified postgresql packend test10, I think the assumption that a
> > use(string) for that select works is implicit knowledge.
> >
> > Result: now I can use a BYTEA and bind it to a std::string in the same
way
> > the mysql backend can bind a BLOB or LONGBLOB to std::string.
>
> Hey Gerwin,
>
> Sorry for the delay in answering. Can you confirm my understanding
> that your problem is solved, i.e., you don't need a change to the
> MySQL backend any more?
>
> Thanks,
>
> Aleksander
>
>
------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
> _______________________________________________
> Soci-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/soci-users
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
