12-16-2016, 08:40 AM | #1 |
Addict
Posts: 225
Karma: 15318
Join Date: Nov 2015
Device: Kobo Glo HD
|
Kobo database
Some quick questions. Only because i am a bit lazy i am afraid.
1. Is there any -obviously unofficial - documentation anywhere? 2. If i wanted to sync reading position between multiplr devices without kobo desktop or calibre, are the two columns chapteridbookmarked and __percentread minimally sufficient? 3. Is there any big reason why device level reading defaults are in conf but book level overrides indatabase? Why not all in db? Cheers Steve Last edited by Stevex; 12-16-2016 at 08:43 AM. |
12-16-2016, 02:16 PM | #2 |
Addict
Posts: 225
Karma: 15318
Join Date: Nov 2015
Device: Kobo Glo HD
|
Skip that third question...
On q2 a quick test has shown i'm completely off the mark! Last edited by Stevex; 12-16-2016 at 03:09 PM. |
Advert | |
|
12-16-2016, 07:31 PM | #3 | ||||
Grand Sorcerer
Posts: 24,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
Quote:
The ChapterIDBookmarked and adobe_location depend on the format. For epubs and PDF, ChapterIDBookmarked contain a reference to the current chapter file. adobe_location contains the reference to the location in the file. But, these are in different rows in the database. The ChapterIDBookmarked is the key For kepubs, just the ChapterIDBookmarked is needed. It contains the reference to the file and the location within. Quote:
Quote:
As to why, it's probably simpler. Kobo would need to add a table for these sort of configuration. Or a special entry in one of the existing tables. There is enough other configuration that the the file is suitable for, so they use it here. |
||||
12-16-2016, 09:12 PM | #4 |
Addict
Posts: 225
Karma: 15318
Join Date: Nov 2015
Device: Kobo Glo HD
|
David thanks so much! That's brilliant information (like always).
For the location it was the adobe_location i was missing. Everything, reading settings and location, works how I expected now. |
12-16-2016, 09:21 PM | #5 |
Grand Sorcerer
Posts: 24,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Glad I can help. And, if you look at the top of action.py in the Kobo Utilities plugin, you will see the SQL statements I use to fetch the reading positions. That should help to see what I am doing.
|
Advert | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Glo Kobo glo and calibre 1.25.0 : kobo database version not suported ? | gperrot | Kobo Reader | 2 | 07-13-2014 10:24 AM |
Kobo sqlite database | darkadept | Kobo Reader | 38 | 09-08-2013 08:12 PM |
help: 'malformed database' with kobo | prairiegal | Devices | 2 | 03-10-2011 09:50 PM |
Kobo desktop v1.7.5 corrupts database on original Kobo | Greenmantle | Kobo Reader | 5 | 11-24-2010 07:23 PM |
Calibre and Kobo database | crowez | Calibre | 1 | 10-15-2010 08:24 PM |