Sqlite database clean up

mapline · 08-01-2012, 03:51 PM

Hi
My Sqlite database has many books in it that I have never loaded.
Can I clean it up (if so how) or are they there for a purpose?

taming · 08-01-2012, 04:30 PM

Check to see if they are actually books, or if they are the recommendations etc. See if there is a match between the things you are seeing in the sqlite file and the marketing pieces Kobo loads in. I would just ignore them unless they really are books.

davidfor · 08-01-2012, 11:12 PM

You can, but personally I wouldn't. If you make a mistake and leave the database in an inconsistent state, it might cause problems.

If you want to continue, as taming said, the "extra" books in the database are probably the listings for the previews. In the "content" table, have a look at the "IsDownloaded" column. From what I can see:

- "false" means book hasn't been put on the KT. These are appearing in the "Reccommended" section.
- "1" or "true" means there is a book on the device.
- All the sideloaded books appear to be "true"
- "1" is used for the chapter entries
- If a kepub has 1 it appear to be preview that is on the device
- If a kepub has "true", it appear to be a book that I bought.

The above is from the 2.0.2 firmware. But, I don't think this has changed from previous versions.

08-01-2012, 03:51 PM	#1
mapline Enthusiast Posts: 44 Karma: 31594 Join Date: Jul 2012 Location: Essex,UK Device: Kobo Touch	Sqlite database clean up Hi My Sqlite database has many books in it that I have never loaded. Can I clean it up (if so how) or are they there for a purpose?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Kobo sqlite database	darkadept	Kobo Reader	38	09-08-2013 08:12 PM
Sqlite database replacement instructions	pholy	Kobo Reader	62	10-11-2012 09:19 AM
Short Fiction Martinez, Brian: A Good Clean, A Harsh Clean. v1. 13th Dec 2010	BrianMartinez	ePub Books	0	12-13-2010 09:23 PM
Database snafu, way to clean it up?	Gwen Morse	Calibre	14	08-06-2010 11:48 PM
Kobo Database Browser - SQLite	JBlyth	Kobo Reader	2	06-06-2010 09:27 PM

08-01-2012, 04:30 PM	#2
taming Trying for calm & polite Posts: 4,012 Karma: 9455193 Join Date: May 2010 Location: Mostly in Canada Device: kobo original, WiFI, Touch, Glo, and Aura	Check to see if they are actually books, or if they are the recommendations etc. See if there is a match between the things you are seeing in the sqlite file and the marketing pieces Kobo loads in. I would just ignore them unless they really are books.

08-01-2012, 11:12 PM	#3
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	You can, but personally I wouldn't. If you make a mistake and leave the database in an inconsistent state, it might cause problems. If you want to continue, as taming said, the "extra" books in the database are probably the listings for the previews. In the "content" table, have a look at the "IsDownloaded" column. From what I can see: - "false" means book hasn't been put on the KT. These are appearing in the "Reccommended" section. - "1" or "true" means there is a book on the device. - All the sideloaded books appear to be "true" - "1" is used for the chapter entries - If a kepub has 1 it appear to be preview that is on the device - If a kepub has "true", it appear to be a book that I bought. The above is from the 2.0.2 firmware. But, I don't think this has changed from previous versions.

Advert