Maximum record size / Maximum data table size / Maximum data base size

[dorianrod]

Hello, What's the maximum record size ? I tried to insert a file but it failed, and the documentation says it's not supported. Is it dependant of the platform ? Are there some limitations for data base or a data table as well ?

Thanks,

Dorian

[brodycj]

What's the maximum record size ?

Maximum record size still needs to be tested (was also asked in #474)

I tried to insert a file but it failed, and the documentation says it's not supported.

I do not understand what you meant by "tried to insert a file", have never tried this kind of thing myself.

Is it dependant of the platform ?

Possibly, still needs to be tested.

Are there some limitations for data base or a data table as well ?

AFAIK the database size should only be limited by the space available on the file system. I think the same would be true for any individual table. I would have to test to give absolutely certain answers.

I am in the middle of a customer driven release right now, can take a look sometime later. Priority goes to paid support users, please contact sales@litehelpers.net for more information.

[brodycj]

FYI SQLite itself (NOT this plugin) supports up to 1GB record size, excellent discussion at: http://sqlite.1065341.n5.nabble.com/About-storage-of-large-amounts-of-image-data-td101757.html

Marking this as a highly desired item for a possible redesign discussed in #548.

Some other relevant links:

• https://stackoverflow.com/questions/4580862/large-scale-image-storage
• http://sqlite.1065341.n5.nabble.com/Effect-of-blobs-on-performance-td19559.html
• https://www.sqlite.org/fasterthanfs.html - "35% Faster Than The Filesystem"

[brodycj]

This issue is now transferred to cordova-sqlite-help.