LiveCode Forums.

Hi
I am struggling with this. Need to store data in sqlite as blob entities and for some reason, any file bigger that 8MB causes the application in IDE and in standalone to crash. file type is .zip and have used same list of files to create varying size of the zip and anything more than 8.15 fails on two of my machines, just wondered if there is a file limit with BLOB that you have encountered.

Have read through http://www.sqlite.org/limits.html but not sure what runrev has implemented in the product hence needing assistance.

Thanks
kotikoti

Dear kotikoti,

That limits site mentions 2MB as a maximum length for strings and blobs. 8MB is well over this number. Perhaps, the RunRev people have set a higher limit, which might not always be a good thing. If it is absolutely necessary to put these 8MB+ files into the database, use a command line utility and see if it doesn't crash. If it doesn't the problem might be in RunRev's library, although it is not clear that this would be a bug. Can't you save the (compressed) pictures in a folder save the path to the pictures in the database?

Best regards,

Mark

Thanks Mark for reply,
I was just puzzled because my implementation was going through a save of all resources to the database when I encountered this "limit". smaller files have no problems at all. I have reworked the implementation whereby I now store these bigger files as customproperties.

Thanks
Kotikoti