Lloyd Dupont wrote:
But to my disbelief there is (apparently) no way to get the size of a blob (other than loading it :-()
I'd like to be corrected if I am wrong, but I don't think there is anyway to do this in SQLite, besides simply storing the size of the blob with the blob when you write it into the database. SQLite stores BLOBS 'in-row' so it has to read the entire BLOB into memory before it figures out the size. I believe even the 'column_bytes' function 'suffers' from this. Tried to find out the feasibility of 'out-of-row' BLOB in SQLite once, but I don't think there was much interest in that. Regards, Kervin