MobileRead Forums - View Single Post

davidfor · 12-15-2013, 07:53 PM

A quick description of the tables and contents might be handy. I'll follow up with some ideas on the counts you are seeing in another post.

- contents - Contains all the details of the books. There is one row per book plus one row per chapter in the book. Except kepubs have two rows per chapter. It also has rows for recommendations. The books have "ContentType=6" and the chapters have "ContentType=9 or ContentType=899". And

- content_keys - I think this is a encryption key for purchased kepubs. There is one row per chapter in the kepubs.

- volume_shortcovers - Has a row for each chapter in the book. It is a cross-reference between the book and chapter rows in the contents table. Plus it has an index to order them.

- volume_tabs - This seems to be a cross reference between books and recommendations for them.

- Activity - One for for things that happen that could be a tile on the home screen. The main issue for size will be the "RecentBook" rows. There should be one per book. Deleting any rows with "enabled='false'" is safe.

- Event - This is one row for each event that happens that Kobo thinks is worth recording. For a book, there will be a row for when it was first seen, opened, closed, finished, a counter of page turns. There are also rows for non-book specific activities. I've posted a list of the events that I have decoded in the past. Clearing this is safe except that you lose stats like the number of finished books.

- Bookmark - A row for each bookmark, annotation or highlight. If you do a lot of annotating, this can be large in both the number of rows and the size of some of the columns. When you delete annotations, they don't get removed immediately. The column "Hidden" is changed to "true". Deleting these is safe.

- Shelf - One row for each shelf. Doesn't tend to have many rows.

- ShelfContent - One row for each book that is on a shelf.

12-15-2013, 07:53 PM	#6
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Tables in device database A quick description of the tables and contents might be handy. I'll follow up with some ideas on the counts you are seeing in another post. - contents - Contains all the details of the books. There is one row per book plus one row per chapter in the book. Except kepubs have two rows per chapter. It also has rows for recommendations. The books have "ContentType=6" and the chapters have "ContentType=9 or ContentType=899". And - content_keys - I think this is a encryption key for purchased kepubs. There is one row per chapter in the kepubs. - volume_shortcovers - Has a row for each chapter in the book. It is a cross-reference between the book and chapter rows in the contents table. Plus it has an index to order them. - volume_tabs - This seems to be a cross reference between books and recommendations for them. - Activity - One for for things that happen that could be a tile on the home screen. The main issue for size will be the "RecentBook" rows. There should be one per book. Deleting any rows with "enabled='false'" is safe. - Event - This is one row for each event that happens that Kobo thinks is worth recording. For a book, there will be a row for when it was first seen, opened, closed, finished, a counter of page turns. There are also rows for non-book specific activities. I've posted a list of the events that I have decoded in the past. Clearing this is safe except that you lose stats like the number of finished books. - Bookmark - A row for each bookmark, annotation or highlight. If you do a lot of annotating, this can be large in both the number of rows and the size of some of the columns. When you delete annotations, they don't get removed immediately. The column "Hidden" is changed to "true". Deleting these is safe. - Shelf - One row for each shelf. Doesn't tend to have many rows. - ShelfContent - One row for each book that is on a shelf.