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

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:

$ 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
    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