Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Firefox OS sqlite databases with blob type

183 views
Skip to first unread message

Nino Vranešič

unread,
Oct 17, 2014, 12:43:59 PM10/17/14
to mozilla...@lists.mozilla.org
I have pulled some databases from Firefox OS device (SMS, Contacts) and I've opened them in SqliteBrowser.
in table "object_data" there is a "data" with blob type. My question is: Is there a way to convert this blob to a plain text? Which decoding is used?

Thanks for your help.
Regards,  Nino V. 

bent.m...@gmail.com

unread,
Oct 17, 2014, 12:53:16 PM10/17/14
to mozilla...@lists.mozilla.org
Hi,

Unfortunately there is no way to do this easily. The blob in the 'data' column is an internal encoded representation of a JavaScript object/value that is then compressed.

The only way that I know of to look at this data is to import the sqlite database (and its corresponding files directory) into a local Firefox profile. Then you can use the built-in Developer Tools Storage Inspector to look at the database.

Cheers,
-bent
0 new messages