If you need to handle large objects, you should look into DBAPI drivers that can stream results. The only drivers i know that can handle a stream are psycopg2 (postgres) and oursql (mysql).
There have been a handful of recipes/threads of people using streams for blobs in the archives. I would still do a filesystem based approach. You wouldn't have to b64 your files, and could use external tools to compress (ie, bzip2 which would take longer, but compresses more). Your users should never know where this data is, it should be treated as a hidden/secure storage area that only the app uses -- just like your mysql. -- 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. For more options, visit https://groups.google.com/d/optout.
