One piece of extra information I forgot to mention in my original email
is that the myobject.uploaded_file LargeBinary column attribute maps to
a Postgresql bytea column.
Best regards,
Andre
On 13-02-12 03:22 PM, Andre Charbonneau wrote:
> Greetings everyone,
> I have a piece of code in a web app where I need to store a large binary
> file (uploaded file stored on disk by Apache server), into an object's
> LargeBinary attribute.
>
> That's pretty easy to do with a syntax like:
>
> myobject.uploaded_file = xyz.file.read()
>
>
> The problem is that I don't want to load the entire file into memory
> when I set the LargeBinary attribute.
>
>
>
> If my understanding is correct, the above call will first cause the
> entire content of the uploaded file to be loaded into memory and then
> that is assigned to the myobject.uploaded_file LargeBinary attribute.
> Correct?
>
> (Then when sqlalchemy eventually issues the INSERT statement to store
> the data in the database... But then I don't really know how the data
> transfer is done...)
>
>
> I have tried to find another way of passing the data to the LargeBinary
> object that would not have to load the entire file into memory at once,
> but stream it in chunks during the INSERT statement, but I was not able
> to find anything. :-(
>
>
> Anyone managed to implement something like this before, or know where I
> can read some more info about possible ways of doing this with sqlalchemy?
>
>
> Thanks a lot,
> Andre
>
>
>
--
André Charbonneau
Research Computing Support Analyst
Shared Services Canada | National Research Council Canada
Services partagés Canada | Conseil national de recherches Canada
100 Sussex Drive | 100, promenade Sussex Ottawa, Ontario K1A 0R6
Canada
andre.charbonn...@ssc-spc.gc.ca
Telephone | Téléphone: 613-993-3129
--
André Charbonneau
Research Computing Support Analyst
Shared Services Canada | National Research Council Canada
Services partagés Canada | Conseil national de recherches Canada
100 Sussex Drive | 100, promenade Sussex
Ottawa, Ontario K1A 0R6
Canada
andre.charbonn...@ssc-spc.gc.ca
Telephone | Téléphone: 613-993-3129
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
