View Single Post
Old 12-13-2011, 03:12 PM   #1
Fizzblizz
Junior Member
Fizzblizz began at the beginning.
 
Posts: 8
Karma: 10
Join Date: Dec 2011
Device: Kindle Touch 3G
Kindle Touch Collections Database

Quote:
Originally Posted by nynaevelan View Post
Out of curiosity has this hack revealed any collections files that the Touch uses to store collections data??
The file /var/local/cc.db seems like the collections store. It is a simple sqlite3 database with ~3 tables and a few triggers. Should be a piece of cake to write a management application:

Code:
$ sqlite3 ./cc.db 
SQLite version 3.7.7 2011-06-23 19:49:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema Entries
CREATE TABLE Entries
(
    p_uuid PRIMARY KEY NOT NULL,       -- ID of entry (UUID)

    p_type,                            -- App-defined type (string)
    p_location,                        -- Location (URI to content)
    p_lastAccess,                      -- Last access (datetime)
...
It even has field documentation! Every attribute is described, sometimes with multiple lines of documentation...
Fizzblizz is offline   Reply With Quote