Storing files in a BLOB field via SQL

Irmen de Jong irmen at -nospam-remove-this-xs4all.nl
Sun Jun 6 17:07:57 EDT 2004


Juergen Gerner wrote:

> field. It is planned to split large files in 64k-parts and sort these
> parts by the ORDER field.

Is there a special reason why you can't store the whole file in a
single BLOB? That's what it's a BLOB for, after all... L=Large :-)


> Additionally, I want to compress the data and store a checksum
> somewhere. Any hint (links, sites, ...) is welcome...!

Compress: look at the zlib module (gzip-style compression)
Checksum: what kind? 32 bit-crc: zlib.crc32   md5: md5.md5

--Irmen



More information about the Python-list mailing list