Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 03-07-2017, 03:52 AM   #1
elwyn5150
Junior Member
elwyn5150 began at the beginning.
 
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?
elwyn5150 is offline   Reply With Quote
Old 03-07-2017, 04:27 AM   #2
oren64
I need a chapter break
oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.oren64 ought to be getting tired of karma fortunes by now.
 
oren64's Avatar
 
Posts: 4,042
Karma: 56058267
Join Date: Mar 2015
Location: Israel
Device: Kobo Glo
You can also use AutoShelf to make collections based on folder structure.
that way you don't need to have copies of the books on your hard drive.
(although it's good to have copies of the books on hard drive, in case of device lose/brick).

Last edited by oren64; 03-07-2017 at 05:44 AM.
oren64 is offline   Reply With Quote
Advert
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,486
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
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: 22,088
Karma: 40026751
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 online now   Reply With Quote
Old 03-07-2017, 06:40 AM   #5
elwyn5150
Junior Member
elwyn5150 began at the beginning.
 
Posts: 3
Karma: 10
Join Date: Mar 2017
Device: Kobo Aura H20
Quote:
Originally Posted by oren64 View Post
You can also use AutoShelf to make collections based on folder structure.
that way you don't need to have copies of the books on your hard drive.
(although it's good to have copies of the books on hard drive, in case of device lose/brick).
Thanks. I'll try that link.

I have one portable hard drive for my ebooks and other media and another portable hard drive which I only ever take out of the box to backup the other.

Quote:
Originally Posted by tshering View Post
There are two databases, one is encrypted and the other is not. For your purposes only the unencrypted is needed.
Both copies were encrpted.

Quote:
Originally Posted by davidfor View Post
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.
Backed up on portable hard drive and a backup of the backup.

Quote:
You need to update your version of SQLite. Kobo have set the journal mode to WAL. This needs at least SQLite 3.7.
Once you fix the SQLite version, you will be OK.

Ah. Thanks! I probably should have checked for an update. My work still uses 3.6.x
elwyn5150 is offline   Reply With Quote
Advert
Old 03-07-2017, 05:22 PM   #6
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 14,475
Karma: 72185627
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Forma, Clara HD, Nexus 7 HD, iPad Pro, Tolino epos
Quote:
Originally Posted by elwyn5150 View Post
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?
From what I've seen, the KoboReader.sqlite database file is the only one you need to worry about. The BookReader.sqlite is encrypted and I'm not sure what it is used for.
DNSB is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQLite version davidfor Development 5 07-03-2016 09:37 AM
Sqlite on Kobo Lucas Malor Kobo Developer's Corner 6 03-26-2014 08:06 AM
SQLite Meeky Kindle Developer's Corner 2 01-01-2013 11:02 AM
Kindle SQLite DB akira.spb Kindle Developer's Corner 2 10-18-2010 10:20 PM


All times are GMT -4. The time now is 09:06 AM.


MobileRead.com is a privately owned, operated and funded community.