Thread: [SQLObject] Is it possible to stream an INSERT or UPDATE to a BLOB column?
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: John R. <joh...@gm...> - 2005-06-29 23:41:32
|
Hi. I'm using SQLObject 0.6.1. Is there another release coming soon? I keep hearing a lot about new features in SVN. I was wondering if there was any way to create or update a row containing a BLOB column without having to read the entire content of the BLOB into memory. For example, if I could pass a file handle in and have the file data read in and sent over the wire (I'm using mysql) a chunk at a time. |
From: Oleg B. <ph...@ma...> - 2005-06-30 09:54:55
|
On Wed, Jun 29, 2005 at 04:41:21PM -0700, John Reese wrote: > Hi. I'm using SQLObject 0.6.1. Is there another release coming soon? > I keep hearing a lot about new features in SVN. Yes, the version in the repository is much more advanced. > I was wondering if there was any way to create or update a row > containing a BLOB column without having to read the entire content of > the BLOB into memory. There is no, becuase there is no sense. Most databases requires a BLOB in a single INSERT/UPDATE, and anyway they read the entire BLOB in memory on SELECT. Do not use too big BLOBs. The better approach is to store BLOBs in the filesystem, and store metadata in the database. Thus you can upload/download BLOBs using streaming protocols (http, ftp, rsync). Oleg. -- Oleg Broytmann http://phd.pp.ru/ ph...@ph... Programmers don't die, they just GOSUB without RETURN. |