What is BookReader.sqlite database file?

codychan · 09-01-2021, 09:59 PM

I got BookReader.sqlite, BookReader.sqlite-shm and BookReader.sqlite-wal in my .kobo device directory:

Quote:

-rw-r--r-- 1 user user 429M Dec 9 2020 BookReader.sqlite
-rw-r--r-- 1 user user 32K Dec 9 2020 BookReader.sqlite-shm
-rw-r--r-- 1 user user 0 Dec 9 2020 BookReader.sqlite-wal

I got another database file KoboReader.sqlite, the modified time is new.

As you can see, BookReader.sqlite* files haven't been modified for a while.

So what are BookReader.sqlite* files? And can I just delete all three of them?

DNSB · 09-01-2021, 10:02 PM

No, you shouldn’t delete them. Though I am rather surprised by the shm and wal files since they are used during a database update and should disappear after the update is finished.

Edit: Just checked on my Forma and the BookReader.sqlite file is the only one in place and it is a massive 894KB compared to your 429MB. I now suspect that back in Dec., 2020, your BookReader.sqlite file was damaged. A signout/signin should fix this though I'd suggest grabbing a copy of your KoboReader.sqlite file and restoring it after the signin.

BTW, the predictive keyboard app I was testing is a piece of crap and has now been removed from my iPhone.

davidfor · 09-02-2021, 05:18 AM

BookReader.sqlite is largely used for some of the information related to Kobo Plus and library borrowing. I understand it gets used for other things, but, I don't know what they are. From my experience, it should be fairly small. I would only expect a large size like that if you are borrowing books from Kobo Plus. Removing it isn't a real problem. But, if the sync fails afterwards, using the account repair should fix it.

And as @DNSB added, with the timestamp and the existence of the two extra files, that database is almost definitely broken. The two extra files should only exist for a short time as changes are made to database. When they are committed they should disappear. Delete the three files and let the device recreate them.

codychan · 09-03-2021, 10:44 AM

Quote:

Originally Posted by davidfor

BookReader.sqlite is largely used for some of the information related to Kobo Plus and library borrowing. I understand it gets used for other things, but, I don't know what they are. From my experience, it should be fairly small. I would only expect a large size like that if you are borrowing books from Kobo Plus. Removing it isn't a real problem. But, if the sync fails afterwards, using the account repair should fix it.

And as @DNSB added, with the timestamp and the existence of the two extra files, that database is almost definitely broken. The two extra files should only exist for a short time as changes are made to database. When they are committed they should disappear. Delete the three files and let the device recreate them.

Yes, thank you, I deleted the three files, rebooted the device, and now only BookReader.sqlite file of 14kb is created.

09-01-2021, 10:02 PM	#2
DNSB Bibliophagist Posts: 45,719 Karma: 168959600 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos	No, you shouldn’t delete them. Though I am rather surprised by the shm and wal files since they are used during a database update and should disappear after the update is finished. Edit: Just checked on my Forma and the BookReader.sqlite file is the only one in place and it is a massive 894KB compared to your 429MB. I now suspect that back in Dec., 2020, your BookReader.sqlite file was damaged. A signout/signin should fix this though I'd suggest grabbing a copy of your KoboReader.sqlite file and restoring it after the signin. BTW, the predictive keyboard app I was testing is a piece of crap and has now been removed from my iPhone. Last edited by DNSB; 09-02-2021 at 01:04 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What is the password for BookReader.sqlite?	xpirad	Kobo Reader	2	10-07-2017 07:32 AM
hours read - where in sqlite-Database	SONOiO	Kobo Reader	1	11-06-2013 04:41 AM
Kobo sqlite database	darkadept	Kobo Reader	38	09-08-2013 08:12 PM
Sqlite database clean up	mapline	Kobo Reader	2	08-01-2012 11:12 PM

09-02-2021, 05:18 AM	#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	BookReader.sqlite is largely used for some of the information related to Kobo Plus and library borrowing. I understand it gets used for other things, but, I don't know what they are. From my experience, it should be fairly small. I would only expect a large size like that if you are borrowing books from Kobo Plus. Removing it isn't a real problem. But, if the sync fails afterwards, using the account repair should fix it. And as @DNSB added, with the timestamp and the existence of the two extra files, that database is almost definitely broken. The two extra files should only exist for a short time as changes are made to database. When they are committed they should disappear. Delete the three files and let the device recreate them.

Advert