"D. Richard Hipp" <[EMAIL PROTECTED]> writes:

> [...]
>>      - page size
> 512 to 64K selectable at compile-time.  Default: 1K
> [...]
>>      - max blob size
> Adjustable at compile-time up to 2^64 bytes. Performance for large
> BLOBs is not good and it is recommended that large BLOBs be stored
> in separate files. The default compile-time limit will be 1MB.

It would be nice to be able to define the above sizes at database
creation time instead of compile-time. My use case is that I would
like to link a program against a prebuilt libsqlite distributed by an
OS vendor, but I also want to increase both page size and max blob
size. (The program I have in mind is Monotone,

I have a similar problem with character encoding in the current SQLite
versions, by the way. I store UTF-8 encoded data from a Python program
using PySQLite using a prepackaged SQLite, but since the prepackaged
libsqlite is built without SQLITE_UTF8, I can't use LIKE et.al. in the
way I want to. It's good to hear that this will be improved in SQLite


Joel Rosdahl <[EMAIL PROTECTED]>
Key BB845E97; fingerprint 9F4B D780 6EF4 5700 778D  8B22 0064 F9FF BB84 5E97

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to