Michael Bayer wrote:
> 
> cx_oracle's blob object is able to stream out blobs like filehandles,  
> since thats how OCI wants it to be done.  Im not sure if it only  
> allows sequential access or access to any range.  As far as other  
> DBAPIs like psycopg2 and MySQLDB, you'd have to dig into the docs/ 
> mailing lists/source code of those to see what resources are  
> available.  Another way might be some SQL function available within  
> the database that truncates the binary stream to a certain portion of  
> itself before selecting, but Im not aware of any function which does  
> that (havent checked tho).

Ah well, this is better than I was expecting :-)

> Current SA behavior is to abstract away the "streamingness" of  
> cx_oracles binary objects, but theres no reason we couldnt expose this  
> functionality through something like a StreamingBinary type or similar.

Cool, if I run into it, I'd be interesting in helping to work on this!

cheers,

Chris

-- 
Simplistix - Content Management, Zope & Python Consulting
            - http://www.simplistix.co.uk

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to