Can't work with BLOB

[stevensotelo]

Hello everyone

I watched that this plugin has one limitation with the blob field. I want to know what I can do to work with this type field. I am working with a Android. Thanks

[brody4hire]

The BLOB feature is for future consideration. Ref: storesafe/cordova-sqlite-storage#263

Some alternatives:

• Convert the binary data back and forth to Base64 string before storing. You may be interested in: nolanlawson / blob-util
• Store your binary data in a flat file using the File API, and simply keep the file reference in the database

It is also theoretically possible to store your binary data as a string by simple character replacement transformations to deal with \u0000 (\0) bytes, as described in section 3 of http://pouchdb.com/2014/10/26/10-things-i-learned-from-reading-and-writing-the-pouchdb-source.html and done in apache/pouchdb#2900 (you may want to see apache/pouchdb#2900 (comment)). But both Android and iOS versions do have problems with certain UNICODE characters (TBD I will add references when I get a chance).

Ref(s) for additional reading:

• https://github.com/nolanlawson/state-of-binary-data-in-the-browser/blob/master/README.md

This will be documented when I get a chance.

[trevorpowell]

I'm wondering, is this something that changed when cordova-sqlite-ext was cut from cordova-sqlite-storage? I have an example that used to work in cordova-sqlite-storage where it would select a blob value with a query and then convert the data for display. Now it seems when it tries the select query, the value for the blob column is not returned but those for integer columns in the same row are. The only thing that's changed in my example is replacing cordova-sqlite-storage with cordova-sqlite-ext.

[trevorpowell]

Looks like reading blob columns was removed in version 0.7.11 due to this issue:
https://issues.apache.org/jira/browse/CB-9638

[stevensotelo]

Hi @trevorpowell

I have a problem with cordova-sqlite-storage, because it doesn't work very good with pre-populated database,

[trevorpowell]

I use a pre-populated database in my use case too, and using version 0.7.10 of cordova-sqlite-storage is working okay for me right now. That version was before the support for pre-populated databases was moved to cordova-sqlite-ext. That seems like the only solution for me right now, at least until the ability to read blob type fields is added back into cordova-sqlite-ext.