Hi,
I'm playing around with SQlite in PHP 5 and as far as I can see, the
row size is limited to 1 MB, even it's possible to set it up to 16
MB. What's the reason for it? I know I can change it for myself when
I recompile the extension, but that's quiet hard on Windows without a
compiler and without the required knowledge...
Andreas
Just because it is the library default; the intention is to make php
generate sqlite files compatible with other applications that use
sqlite.
IIRC, you can happily exceed this "limit", it'll just be slower to
access such a row.
To be honest, support for blob style data in sqlite 2 and below is
pretty crappy; if you're serious about it, I'd suggest upgrading to
PHP 5.1 and using PDO SQLITE instead. SQLite 3 (which it uses)
actually has a concept of binary data.
--Wez.
Hi,
I'm playing around with SQlite in PHP 5 and as far as I can see, the
row size is limited to 1 MB, even it's possible to set it up to 16
MB. What's the reason for it? I know I can change it for myself when
I recompile the extension, but that's quiet hard on Windows without a
compiler and without the required knowledge...Andreas
Am 19.07.2005 um 22:23 schrieb Wez Furlong:
Just because it is the library default; the intention is to make php
generate sqlite files compatible with other applications that use
sqlite.
Ah, that makes sense :)
To be honest, support for blob style data in sqlite 2 and below is
pretty crappy; if you're serious about it, I'd suggest upgrading to
PHP 5.1 and using PDO SQLITE instead. SQLite 3 (which it uses)
actually has a concept of binary data.
I'll think about it - does the row size limit still exist in SQLite 3?
Andreas