Thread: Aura H2O sqlite collections
View Single Post
Old 03-07-2017, 05:41 AM   #4
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by elwyn5150 View Post
I want to sort my books into collections without using the reader (too slow) or without Calibre (I don't want to have to import everything into calibre and have copies of my books sit on my hard drive).
What are you doing for backup of the books? It's to easy to lose the device or need to do a factory reset. Plus calibre is superb for organisation and any needed conversions.
Quote:
I am experienced in using SQL and sqlite.

I have read this:
http://shallowsky.com/blog/tech/kobo-hacking.html
That looks OK as a starting guide.
Quote:
I am able to access the sqlite files in the .kobo directory. However, I get an error:
Error: file is encrypted or is not a database

I am running SQLite version 3.6.23.1 on Linux.
You need to update your version of SQLite. Kobo have set the journal mode to WAL. This needs at least SQLite 3.7.
Quote:
1) How do I access this database?
2) If the answer to #1 is "you can't", can I replace it with my own that is not encrypted?
3) If the answer to #2 is "yes", can somebody send me the SQL schema to use? Will I lose my reading history?
Once you fix the SQLite version, you will be OK.

There is also a mod to build collections from the folder structure. It's in the developers for and is called something like "autoshelf".
davidfor is offline   Reply With Quote