I am creating decent-sized amounts of data (currently strings since they probably picke better, order of magnitude of a few MB repr-wise) and want to pickle them using PickleCol. I am running into the following error when I try to create objects/rows, though: DataError: String or BLOB exceeded size limit
It seems like SQLObject defaults to using VARCHAR for BLOBCol and PickleCol, which seems to imply a SQLite 1MB row limit. However, forcing sqlType='BLOB' doesn't help, and I don't get why. Am I right to doomily assume that the current SQLObject version won't handle this with SQLite at all, or is there some magic I still need to sprinkle in? (I've also read that since SQLite doesn't want SQL statements larger than 1MB, nonparametrized BLOB inserts would still fail at that limit - but I assume I'd get a different error if that were the problem) Regards, --Bart Alewijnse ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
