[root:dev_tempstorage_db] select length(value) from caches;
+---+
| length(value) |
+---+
| 67694 |
+---+
The problem was not caused by a distinction between text and blob
cols, but rather by the maximum colsize of these types.
Changing to either
On Sep 16, 2007, at 1:01 PM, Robert Ian Smit wrote:
[root:dev_tempstorage_db] select length(value) from caches;
+---+
| length(value) |
+---+
| 67694 |
+---+
The problem was not caused by a distinction between text and blob
cols, but rather by the
Changing to either longtext or longblob will equally solve the
problem.
Ah, I'll change it to longblob then, does this limitation of blob
size apply to all db's?
My sqlalchemized db code is 90% database independent.
Right now I don't have time to port the app or extract a useful
On Aug 28, 2007, at 2:17 PM, Robert Ian Smit wrote:
File '.../Beaker-0.7.5-py2.4.egg/beaker/ext/database.py', line 94 in
__getitem__
return cPickle.loads(str(rows[0]['value']))
ValueError: insecure string pickle
On other pages caching works as expected.
When I look at the contents of the
After lots of attempts at changing the the to be pickled contents, I
modified the columntype of value to be longtext instead of blob.
This solved all caching problems.
That's rather odd, perhaps the MySQL connector is doing something
funky with the formatting when its a blob that
On Aug 29, 2007, at 3:56 PM, Robert Ian Smit wrote:
Yes. I suppose that the problem was the cut off issue. I am not
actually caching the html body. I am storing the entire response
object like beaker_cache does. A Response object whose pickled
representation is truncated can not be restored to
