Re: [SQLObject] PickleCol+SQLite size problem/question

[Bart <sca...@gm...>]

On 10/26/07, Oleg Broytmann <ph...@ph...> wrote:
> Hello!
>
> On Fri, Oct 26, 2007 at 05:06:21AM +0200, Bart wrote:
> >  DataError: String or BLOB exceeded size limit
>
>    What version of SQLite are you using? Could it be you've just bumped
> into SQLite limits: http://sqlite.org/limits.html ? The limits are actual
> from the version 3.4.0 and up: http://sqlite.org/changes.html#version_3_4_0 ,
> the actual limits depend on how your installation is compiled.

I've got 3.4.1 installed, and while I don't know or don't know how to
inspect these values for my specific installation, I doubt that it
matters.


It seems to me SQLObject doesn't actually use BLOBs at all - on
SQLite. That page states the BLOB size is 1GB (default) and isn't a
separate size just for show - as long as the library uses the API
right (apparently meaning sqlite3_bind_blob and related functions), it
can use it regardless of the 1MB (default) SQL statement limit, or row
limit (not sure how/whether that one applies, but it's likely besides
the point too).


My question is another one - since by default SQLObject uses VARCHAR
to support BLOBCol and PickleCol on SQLite, it's not likely to use its
specifc BLOB API. It looks like pysqlite is up to using it, so the
real question seems to be whether SQLObject can be made to use it,
because without using it you're likely going to run into the much
lower non-BLOB limits.


'course, I could be wrong:)

--Bart