Storing files in a BLOB field via SQL
Irmen de Jong
irmen at -nospam-remove-this-xs4all.nl
Sun Jun 6 23:07:57 CEST 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
More information about the Python-list