Everything

php

SQlite row size

php.internals

Andreas Ahlenstorf

21 years ago

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

Wez Furlong

21 years ago

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.

On 7/19/05, Andreas Ahlenstorf <lists@ahlenstorf.ch> wrote:

Andreas Ahlenstorf

21 years ago

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