![]() |
#1 |
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? |
![]() |
![]() |
![]() |
#2 |
I need a chapter break
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 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. |
![]() |
![]() |
Advert | |
|
![]() |
#3 | |
Wizard
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 3,489
Karma: 2914715
Join Date: Jun 2012
Device: kobo touch
|
Quote:
|
|
![]() |
![]() |
![]() |
#4 | ||||
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 24,906
Karma: 47303822
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
|
Quote:
Quote:
Quote:
Quote:
There is also a mod to build collections from the folder structure. It's in the developers for and is called something like "autoshelf". |
||||
![]() |
![]() |
![]() |
#5 | ||||
Junior Member
![]() Posts: 3
Karma: 10
Join Date: Mar 2017
Device: Kobo Aura H20
|
Quote:
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:
![]() Quote:
Quote:
Ah. Thanks! I probably should have checked for an update. My work still uses 3.6.x |
||||
![]() |
![]() |
Advert | |
|
![]() |
#6 | |
Bibliophagist
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 36,990
Karma: 148318166
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
|
Quote:
|
|
![]() |
![]() |
![]() |
|
![]() |
||||
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 |