Re: [Re: Native versus socket interface]

Russ Tyndall <[email protected]> Thu, 01 Dec 2011 11:56:42 -0500
Newsgroups gmane.lisp.clsql.general
Message-ID <[email protected]>
> So the older socket interface supports streaming, but the new one does not?

It is a deficiency that I would like to correct, but have not had the 
time to do so yet.

The socket3 interface *does* support streaming but you must fall back to 
the underlying cl-postgres method of doing so rather than using cl-sql's 
streaming constructs.  Cl-sql's streaming constructs really need some 
refactoring that I just haven't had the time to do.  You do get command 
objects / parameters with socket3 which are unavailable from socket. 
(There are also some differences in type handling, but in common usage, 
you shouldn't notice those.  IIRC Socket3 does a little bit better job 
of coercing db-types to lisp-types.)

Cheers,
Russ Tyndall
Acceleration.net