Internal data format of a module
Posted: Fri Apr 05, 2013 6:55 pm
Hello forum, my first post here.
I'm looking at your AV1611 module, which is the best that I have found because it is in database format (sqlite), and it has all the original references, italics etc.
After looking at the module with sqlite3, sqlitebrowser, etc., it seems the structure is intact, with both "ref" and "verse" data in its "bible" table. However the "verse" data seems to be in binary BLOB format. Its my understanding that this is not necessarily the fault of sqlite, as it happily stores the data in the format the application sent it. So I want to know what is this format and/or how to convert the data out of blob format and into text.
(The "Export Copy/Verse(s)" feature did not help because it dropped all the references (they are not actually being exported). I've verified this in the Linux build and observed the same in the MSWIN build on Wine.)
Ultimately, using the module text of this bible, with some additional formatting, dropcaps, leaf numbers and repagination, perhaps a way could be developed for anyone to make a full-size printing of the KJB. I feel it could be easily done if I had the text to work with.
Mark
I'm looking at your AV1611 module, which is the best that I have found because it is in database format (sqlite), and it has all the original references, italics etc.
After looking at the module with sqlite3, sqlitebrowser, etc., it seems the structure is intact, with both "ref" and "verse" data in its "bible" table. However the "verse" data seems to be in binary BLOB format. Its my understanding that this is not necessarily the fault of sqlite, as it happily stores the data in the format the application sent it. So I want to know what is this format and/or how to convert the data out of blob format and into text.
(The "Export Copy/Verse(s)" feature did not help because it dropped all the references (they are not actually being exported). I've verified this in the Linux build and observed the same in the MSWIN build on Wine.)
Ultimately, using the module text of this bible, with some additional formatting, dropcaps, leaf numbers and repagination, perhaps a way could be developed for anyone to make a full-size printing of the KJB. I feel it could be easily done if I had the text to work with.
Mark