We have are developing an internal application to store documents and images in the postgresql db. After struggling with escaping the low order characters for including in the bytea field, we hit upon the idea of simply using the python base64 modules to encode files as base64 strings and store the string in the database.
We think that the benefit is doing this is; 1) using an industry standard encoding mechanism so they could be decoded with another application if desired. 2) the images/documents are "web/email ready", so storing and encoding stage will encur a penalty hit, hwoever, the retreival will not. If any one on this list has suggestions/comments or can see a problem with this strategy, we would appreciate comment. BTW, we have already wrestled with the "store in db vs store in filesystem" and we think that this is the best way to go. Thanks in advance. Geoff.
_______________________________________________ PyGreSQL mailing list [email protected] http://mailman.vex.net/mailman/listinfo/pygresql
