MobileRead Forums - View Single Post

elwyn5150 · 03-07-2017, 03:52 AM

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?

03-07-2017, 03:52 AM	#1
elwyn5150 Junior Member Posts: 3 Karma: 10 Join Date: Mar 2017 Device: Kobo Aura H20	sqlite collections 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?