Aura H2O sqlite collections

[elwyn5150]

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?

[oren64]

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).

[tshering]

Originally Posted by elwyn5150

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.

[davidfor]

Originally Posted by elwyn5150

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.

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.

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.

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".

[elwyn5150]

Originally Posted by oren64

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.

Originally Posted by tshering

There are two databases, one is encrypted and the other is not. For your purposes only the unencrypted is needed.

Both copies were encrpted.

Originally Posted by davidfor

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.

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

[DNSB]

Originally Posted by elwyn5150

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.