I have a sqlite database from a iphone chat app which I would like to present in a human readable format either csv, html or other. The database has over 600 tables with multiple rows of conversation, the fields are: sender (text) - servertime (blob) – localtime (blob) – type (text) – data(blob) – discontinuity (integer)
The servertime and localtime blobs hold the date time as an epoch in hex The type field holds information relating to the format of the data in the data (blob), either “text” or “jpeg”. And the discontinuity field holds data relating to whether this conversation is live or not. Basically my problem is exporting the database so the time stamps appear in hex the data blobs appear in either text (ascii) or as a jpeg image depending on the data in type field. I have tried numerous sqlite browsers without success. I would appreciate if anyone could contribute some possible solutions for achieving this. Thanks for any help -- View this message in context: http://old.nabble.com/Export-Blob-data-from-sqlite-database-to-html-tp32853385p32853385.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users