01-19-2019, 12:31 PM | #1 |
Grand Sorcerer
Posts: 5,278
Karma: 98804578
Join Date: Apr 2011
Device: pb360
|
KUAL "listing bump" proof of concept
The list view listing for the KUAL booklet drifts down the screen and eventually off the first page as other books are opened even if KUAL has been used in the meantime. That is, the access time for the booklet KUAL does not get updated, unlike the kindlet KUAL.
The good news is that updating p_lastAccess for the KUAL record in cc.db raises KUAL to the second entry of the list view listing with the Recent filter after another book is opened and closed. The bad news is that the sqlite3 on board the kindle can not update cc.db (See post #1862 in https://www.mobileread.com/forums/sh...03326&page=125 ) Proof that there is hope: Code:
mkdir local sshfs root@oasis:/var/local local NOW=`ssh root@oasis date '+%s'` sqlite3.26 local/cc.db "SELECT icu_load_collation('en_US.utf8', 'icu'); update Entries set p_lastAccess = $NOW where p_titles_0_nominal = 'KUAL';" fusermount -u local So, with a kindle sqlite3 binary that speaks icu, it would be straightforward to make a KUAL extention that bumps KUAL's listing. This has been implemented as a KUAL extension. See https://www.mobileread.com/forums/sh...63#post3803463 Last edited by j.p.s; 01-27-2019 at 12:16 PM. Reason: Add URL to point to KUAL extension. |
01-19-2019, 12:45 PM | #2 | |
Going Viral
Posts: 17,212
Karma: 18210809
Join Date: Feb 2012
Location: Central Texas
Device: No K1, PW2, KV, KOA
|
Quote:
If not, then I have a build linked to the entire Uncode data library - as in: everything. If NiLuJe's does not do the trick, post in this thread and I will attach my build. PS: There is another db there, with one entry, which holds the collation value setting to execute in sqlite3 to modify and delete of cc.db. (maybe: locale.db ??) Last edited by knc1; 01-19-2019 at 12:47 PM. |
|
Advert | |
|
01-19-2019, 01:25 PM | #3 | ||
Grand Sorcerer
Posts: 5,278
Karma: 98804578
Join Date: Apr 2011
Device: pb360
|
Quote:
I dumped the SS tar.xz but didn't think to dump the update.bin I'll have to grab kindletool and have a look. Quote:
I guess there will need to be two versions. One for those (including me) who don't like case insensitive order anyway and another for those that don't mind using space on another copy of sqlite3. (I prefer not to make it dependent on SS, but I guess that those with SS can have the best of both.) |
||
01-19-2019, 01:44 PM | #4 | |
Going Viral
Posts: 17,212
Karma: 18210809
Join Date: Feb 2012
Location: Central Texas
Device: No K1, PW2, KV, KOA
|
Quote:
The content collections data base is set to the collation determined by the language question's answer when powering up the Kindle for the first time. Your choice of English UTF8 just happens to be what yours is set for. Other countries, probably not. But I think the various UTF8 'space' types appear in the same position in all collation orders. |
|
01-19-2019, 02:10 PM | #5 |
curly᷂͓̫̙᷊̥̮̾ͯͤͭͬͦͨ ʎʌɹnɔ
Posts: 3,002
Karma: 50506927
Join Date: Dec 2010
Location: ♁ ᴺ₄₅°₃₀' ᵂ₇₃°₃₇' ±₆₀"
Device: K3₃.₄.₃ PW3&4₅.₁₃.₃
|
My (very simple) trick to access KUAL without scrolling.
Since the KUAL Doc does indeed drift down, I placed it in a collection "Jeux & Applications" with very few items showing on a single page. I also choose the collection name to sort hi on page one of my Kindle list view. Two taps and I can launch KUAL. |
Advert | |
|
01-19-2019, 02:26 PM | #6 |
Grand Sorcerer
Posts: 5,278
Karma: 98804578
Join Date: Apr 2011
Device: pb360
|
|
01-19-2019, 02:31 PM | #7 | |
Grand Sorcerer
Posts: 5,278
Karma: 98804578
Join Date: Apr 2011
Device: pb360
|
Quote:
That sounds like the way to go for anyone using collections. I gave up trying to use collection years ago in frustration. |
|
01-19-2019, 04:28 PM | #8 |
BLAM!
Posts: 13,477
Karma: 26012494
Join Date: Jun 2010
Location: Paris, France
Device: Kindle 2i, 3g, 4, 5w, PW, PW2, PW5; Kobo H2O, Forma, Elipsa, Sage, C2E
|
@j.p.s: It's in the Python package (which is a recommended dependency of the SS package ).
FWIW, that's also how I used to handle Kindlets back in the day: put 'em in a dedicated collection . |
01-19-2019, 05:12 PM | #9 | |
hopeless n00b
Posts: 5,111
Karma: 19597086
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9
|
Quote:
|
|
01-19-2019, 07:23 PM | #10 | |
Grand Sorcerer
Posts: 5,278
Karma: 98804578
Join Date: Apr 2011
Device: pb360
|
Quote:
I'll probably put together a KUAL package next weekend. I'm open to suggestions for name, including capitalization. If I don't hear anything better, I'll probably use bump-kual If that violates some naming convention, please let me know. |
|
01-20-2019, 12:00 AM | #11 |
BLAM!
Posts: 13,477
Karma: 26012494
Join Date: Jun 2010
Location: Paris, France
Device: Kindle 2i, 3g, 4, 5w, PW, PW2, PW5; Kobo H2O, Forma, Elipsa, Sage, C2E
|
I like Title Case for stuff like that, but that's just me .
|
01-21-2019, 10:39 AM | #12 |
Going Viral
Posts: 17,212
Karma: 18210809
Join Date: Feb 2012
Location: Central Texas
Device: No K1, PW2, KV, KOA
|
Why not use a stored procedure to update last used time of KUAL, triggered on open, close, or 'home' button press?
Hint: dump the schema of the various tables to see how stored procedures are being used now (expect firmware version variations but we don't really need to support anything older than 5.2). |
01-21-2019, 04:41 PM | #13 | |
Grand Sorcerer
Posts: 5,278
Karma: 98804578
Join Date: Apr 2011
Device: pb360
|
Quote:
Shouldn't exiting KUAL generate a close event and shouldn't that already trigger an access time update? Is this a kindlet vs booklet thing, an amazon bug, or a missing piece in KUAL? |
|
01-21-2019, 05:45 PM | #14 | |
Going Viral
Posts: 17,212
Karma: 18210809
Join Date: Feb 2012
Location: Central Texas
Device: No K1, PW2, KV, KOA
|
Quote:
Closing KUAL **should** make it the most recently used already. I thought you wanted to prevent the opening/closing of anything else from moving KUAL from "most recent" position. So where ever the system records how recent something is used, the stored procedure should modify that field for KUAL, for anything opened/closed OTHER THAN KUAL. (Don't want to loop when changing KUAL use time (whatever it is named) by letting it trigger the procedure again.) I admit, I am not looking at a Kindle db at the moment and not even I trust my memory (which is why I no longer answer questions). In fact, I am going through my stack of Kindles, looking for the one with the sql stuff on it. It is here, somewhere. .... |
|
01-21-2019, 05:58 PM | #15 |
hopeless n00b
Posts: 5,111
Karma: 19597086
Join Date: Jan 2009
Location: in the middle of nowhere
Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9
|
|
Tags |
kual, sqlite, sqlite3 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Recovering KUAL after 5.9.5.1 upgrade? ";log mrpi" has no effect | gwynevans | Kindle Developer's Corner | 7 | 06-03-2018 06:45 AM |
The concept of the "finished" text | teh603 | Writers' Corner | 6 | 05-11-2012 07:20 AM |
"Burden of Proof" thriller only $1.99 | yellowstonegirl | Deals and Resources (No Self-Promotion or Affiliate Links) | 1 | 01-31-2010 01:07 PM |
Most "future proof" format? | Shiren | Sony Reader | 21 | 12-12-2008 02:31 PM |
"Concept Readius": rollable electronic paper ready for prime time | Colin Dunstan | News | 5 | 02-05-2006 01:52 AM |