MobileRead Forums - View Single Post

Fizzblizz · 12-13-2011, 02:23 PM

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.

Code:

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.

12-13-2011, 02:23 PM	#3
Fizzblizz Junior Member 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. Code: 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.