Thread: Aura H2O sqlite collections
View Single Post
Old 03-07-2017, 04:54 AM   #3
tshering
Wizard
tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.tshering ought to be getting tired of karma fortunes by now.
 
Posts: 3,489
Karma: 2914715
Join Date: Jun 2012
Device: kobo touch
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).

I am experienced in using SQL and sqlite.

I have read this:
http://shallowsky.com/blog/tech/kobo-hacking.html


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.

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?
There are two databases, one is encrypted and the other is not. For your purposes only the unencrypted is needed.
tshering is offline   Reply With Quote