calibre friday preview releases - Page 20

beedaddy · 03-19-2025, 03:35 AM

Quote:

Originally Posted by kovidgoyal

https://github.com/kovidgoyal/calibr...28dfb6a93e516a

Regarding the Tolinos, "Color" was correct.
https://mytolino.com/products/tolino-vision-color/

PeterT · 03-19-2025, 05:02 PM

This is quite weird, and I'd appreciate if other folks could experiment. (Of course, I somehow doubt the issue will happen on a platform that doesn't require a copy / restore of the Kobo database).

I find that the reading position of the current book gets "lost" after I perform a connection / disconnect cycle of the folder. It appears to get restored to a previous save point.

kovidgoyal · 03-19-2025, 10:17 PM

@PeterT: Is the reading position stored in the db? If so do you know where? You can check the value using the sqlite command line tool or sqlitebrowser after a connect/disconnect cycle. See if this helps as well:
https://github.com/kovidgoyal/calibr...7635c94d3092a1

Majutsushi · 03-20-2025, 12:38 AM

Quote:

Originally Posted by PeterT

This is quite weird, and I'd appreciate if other folks could experiment. (Of course, I somehow doubt the issue will happen on a platform that doesn't require a copy / restore of the Kobo database).

I find that the reading position of the current book gets "lost" after I perform a connection / disconnect cycle of the folder. It appears to get restored to a previous save point.

Does the reading position get changed by the KoboUtilities plugin in between, and you don't see it "sticking"? That would be the kind of situation that my test build in the plugin thread is supposed to address.

PeterT · 03-20-2025, 12:51 AM

I'm officially going crazy. I decided to move from reading a LIBRARY book fufilled by the Kobo store to trying a side-loaded ePub. Simpler right?

Well I open the book, head to a random page (Chapter 10, and a few page turns). Return to the Kobo home screen and as expected, the book is now the first book on the home display. Reopening the book returns to the correct page.

Now I connect the USB cable, eject the device from Chrome, (note calibre was NOT connected). The Kobo does NOT go through its importing content stage and as expected, my book is still the first book on the home screen, and opening it heads to the correct page.

Now reconnect the USB cable and connect to folder as a Libra Colour. No books added / deleted. Ehect from calibre; disconnect from chromebook. This time the Kobo goes through it's importing content screen and my book is no longer the first book on the home screen. Now it just struck that metadata management is set to automatic; so let me disable that and try one more time.

Additionally I've tried making copies of the KoboReader sqlite database at various points and done a sqldiff on the various copies; no differences found

-----

OK. Opened "Promises Greater than Darkness" as an ePub. Moved to Chapter 3 - Page 6 of 7" and set a bookmark.

Stayed in book and connected to ChromeBook, copied the database as "01-Promises.sqlite".

Connected calibre and then copied the /tmp database to "02-temp.sqlite".

01 and 02 are identical.

Eject device from calibre and took another copy of the database from the Kobo "03-after-eject.sqlite".

All db's are still identical.

Ejected device from chromebook and removed USB cable.

Get an IMPORTING CONTENT message; Promises is no longer listed on the home screen. In the My eBooks screen, the book shows as UNREAD and opens to the start. BUT the bookmark is still present.

------

Unfortunately my detailed knowledge of the database schema is minor; this is where the knowledge of @davidfor would be invaluable.

I do know that the Kobo Utilities can retrieve reading location; this is done from the CONTENT table. (This testing on Promises was done WITHOUT Utilities installed).

Majutsushi · 03-20-2025, 01:16 AM

Good to know that the Utilities plugin is not involved, that removes one variable.

According to the man page sqldiff has some limitations, it might be a good idea to do a complete dump of each database copy and do a normal text diff between them.

kovidgoyal · 03-20-2025, 04:14 AM

Doesnt look like its database related in that case. If the .sqlite files are indentical and there is no .sqlite-wal file then I dont see how there could be a db related issue.

PeterT · 03-20-2025, 02:49 PM

I've found a workaround that seems to work perfectly for me
- rclone the kobo to the chromebook storage
- calibre open folder on the cloned copy
work as usual
- calibre eject the device
- rclone back to the kobo

With this solution all works as expected.

gabryele · 03-21-2025, 04:53 AM

after update to calibre 8.
The program no longer starts and now what can I do?

kovidgoyal · 03-21-2025, 05:36 AM

Quote:

Originally Posted by gabryele

after update to calibre 8.
The program no longer starts and now what can I do?

Update to 8.0.1

03-19-2025, 10:17 PM	#288
kovidgoyal creator of calibre Posts: 45,110 Karma: 27110892 Join Date: Oct 2006 Location: Mumbai, India Device: Various	@PeterT: Is the reading position stored in the db? If so do you know where? You can check the value using the sqlite command line tool or sqlitebrowser after a connect/disconnect cycle. See if this helps as well: https://github.com/kovidgoyal/calibr...7635c94d3092a1 Last edited by kovidgoyal; 03-19-2025 at 11:00 PM.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dockerise multiple Calibre releases for plugin development	wolf123	Related Tools	1	02-06-2021 03:12 AM
[Q] How can I check for new releases in a series in calibre or goodreads?	lambstone	Kobo Reader	1	09-09-2016 12:04 AM
CC B4.0.X beta (all releases)	chaley	Calibre Companion	41	07-21-2015 06:53 AM
CC beta releases 3.4.4j, 3.4.4k, 3.4.4l	chaley	Calibre Companion	33	10-21-2014 06:19 AM
dotReader releases first public beta	Alexander Turcic	Reading and Management	4	11-23-2006 01:40 AM

03-19-2025, 05:02 PM	#287
PeterT Grand Sorcerer Posts: 13,235 Karma: 78869092 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	This is quite weird, and I'd appreciate if other folks could experiment. (Of course, I somehow doubt the issue will happen on a platform that doesn't require a copy / restore of the Kobo database). I find that the reading position of the current book gets "lost" after I perform a connection / disconnect cycle of the folder. It appears to get restored to a previous save point.

03-20-2025, 12:51 AM	#290
PeterT Grand Sorcerer Posts: 13,235 Karma: 78869092 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	I'm officially going crazy. I decided to move from reading a LIBRARY book fufilled by the Kobo store to trying a side-loaded ePub. Simpler right? Well I open the book, head to a random page (Chapter 10, and a few page turns). Return to the Kobo home screen and as expected, the book is now the first book on the home display. Reopening the book returns to the correct page. Now I connect the USB cable, eject the device from Chrome, (note calibre was NOT connected). The Kobo does NOT go through its importing content stage and as expected, my book is still the first book on the home screen, and opening it heads to the correct page. Now reconnect the USB cable and connect to folder as a Libra Colour. No books added / deleted. Ehect from calibre; disconnect from chromebook. This time the Kobo goes through it's importing content screen and my book is no longer the first book on the home screen. Now it just struck that metadata management is set to automatic; so let me disable that and try one more time. Additionally I've tried making copies of the KoboReader sqlite database at various points and done a sqldiff on the various copies; no differences found ----- OK. Opened "Promises Greater than Darkness" as an ePub. Moved to Chapter 3 - Page 6 of 7" and set a bookmark. Stayed in book and connected to ChromeBook, copied the database as "01-Promises.sqlite". Connected calibre and then copied the /tmp database to "02-temp.sqlite". 01 and 02 are identical. Eject device from calibre and took another copy of the database from the Kobo "03-after-eject.sqlite". All db's are still identical. Ejected device from chromebook and removed USB cable. Get an IMPORTING CONTENT message; Promises is no longer listed on the home screen. In the My eBooks screen, the book shows as UNREAD and opens to the start. BUT the bookmark is still present. ------ Unfortunately my detailed knowledge of the database schema is minor; this is where the knowledge of @davidfor would be invaluable. I do know that the Kobo Utilities can retrieve reading location; this is done from the CONTENT table. (This testing on Promises was done WITHOUT Utilities installed).

03-20-2025, 01:16 AM	#291
Majutsushi Connoisseur Posts: 84 Karma: 8592 Join Date: Aug 2023 Location: New Zealand Device: Kobo Clara HD, Kobo Libra Colour	Good to know that the Utilities plugin is not involved, that removes one variable. According to the man page sqldiff has some limitations, it might be a good idea to do a complete dump of each database copy and do a normal text diff between them.

03-20-2025, 04:14 AM	#292
kovidgoyal creator of calibre Posts: 45,110 Karma: 27110892 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Doesnt look like its database related in that case. If the .sqlite files are indentical and there is no .sqlite-wal file then I dont see how there could be a db related issue.

03-20-2025, 02:49 PM	#293
PeterT Grand Sorcerer Posts: 13,235 Karma: 78869092 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	I've found a workaround that seems to work perfectly for me - rclone the kobo to the chromebook storage - calibre open folder on the cloned copy work as usual - calibre eject the device - rclone back to the kobo With this solution all works as expected.

03-21-2025, 04:53 AM	#294
gabryele Connoisseur Posts: 59 Karma: 10 Join Date: Sep 2016 Device: Kobo Aura one	after update to calibre 8. The program no longer starts and now what can I do?

Advert

Advert