View Single Post
Old 12-13-2011, 02:23 PM   #3
Junior Member
Fizzblizz began at the beginning.
Posts: 8
Karma: 10
Join Date: Dec 2011
Device: Kindle Touch 3G
Ok, it seems that Amazon has used the sqlite3 API to add some native functions to the used SQL dialect. From the start, I wasn't been able to delete rows from either the Entries nor the Collections tables.

sqlite> delete from Collections where i_member_uuid='c061612a-03fa-42b5-a089-0fc41de2f791';
Error: no such function: is_journaling_enabled
I am more into PostgreSQL. Maybe someone here can identify the needed external functions to be present from the schema description which can be downloaded from here.

Caution: the file contains only the schema and some example inserts. I would like not to disclose my reading interests to the world ;-) So don't expect to get a consistent database when importing this to sqlite.

Maybe someone else can provide a direct dump of the cc.db file from a vanilla Kindle.
Fizzblizz is offline   Reply With Quote