05-06-2010, 05:14 PM | #16 | |
Member
Posts: 18
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
Quote:
There is also an XML file that contains the id's of book on the device but I haven't looked into that yet. While the Kobo and the desktop software *should* work with a out if sync database having cluttering entries in the database is less than optimal. |
|
05-06-2010, 11:43 PM | #17 |
Addict
Posts: 324
Karma: 25168
Join Date: May 2010
Device: kobo
|
Deleting the book and chapter entries in the "content" table does give a pleasing result, i.e. the books no longer show up in the directory on the Kobo. However, since the stuff is still in there, the database doesn't get any smaller. I don't know much about databases; I'm trying to figure out some sqlite routine that will get all of the linked chapter and page entries to go away (because doing it manually sure would take time -- well maybe not for a single book).
|
05-07-2010, 12:21 AM | #18 |
Member
Posts: 12
Karma: 10
Join Date: May 2010
Device: Kobo Reader, iPhone
|
And, if this is a stupid question as well, I apologise.... When you are finished will it be fairly easy for techno-wienies to figure out? And, I have a Mac.
Last edited by karenv; 05-07-2010 at 12:24 AM. Reason: Forgot something |
05-07-2010, 01:04 AM | #19 | |
Member
Posts: 11
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
Hi karenv,
Quote:
|
|
05-07-2010, 10:54 AM | #20 |
Enthusiast
Posts: 36
Karma: 10
Join Date: May 2010
Location: Nova Scotia
Device: Kobo Version 1 firmware v 1.8.3
|
kobo sqlite db
I am not in the db mode , looked at the db with Sqlite Expert
Not sure what to delete , I would like to tidy bu the db and my 'I am reading' page ... Have found this forum interesting Impressed with the Kobo , but as mentioned , needs some fine tuning Harry |
05-07-2010, 12:02 PM | #21 |
Grand Sorcerer
Posts: 12,154
Karma: 73448616
Join Date: Nov 2007
Location: Toronto
Device: Nexus 7, Clara, Touch, Tolino EPOS
|
I removed a lot of stuff from the "I'm Reading" view by the following SQL
Code:
update content set readstatus = 2 where ReadStatus = 0 and Publisher = 'Gutenberg' and booktitle is null |
05-07-2010, 03:39 PM | #22 | |
Member
Posts: 18
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
Quote:
I'm not sure why they use both ReadStatus and FirstTimeReading but they do. You can try queries like this: Code:
UPDATE content SET ReadStatus=0, FirstTimeReading='True' WHERE BookTitle is NULL and Title like '%A Book Title%' This will set the book as completely unread and new to the kobo. |
|
05-10-2010, 05:25 PM | #23 |
Member
Posts: 18
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
I've moved the wiki for Koboko to http://wiki.durbn.net/koboko/index.php/Main_Page. Anyone can edit it.
|
05-12-2010, 09:22 AM | #24 |
Enthusiast
Posts: 39
Karma: 10
Join Date: May 2010
Location: Toronto, Canada
Device: Kobo
|
Another tool for editing Sqllite databases
For anyone who wants to try, here's an open-source tool for editing Sqllite databases:
http://sqlitebrowser.sourceforge.net/ But I feel it's only fair to note that you can probably render your Kobo totally unuseable if you screw up the database on it. You should back it up before making any changes to it yourself. I haven't tried this myself, although I would like to reverse-engineer the thing a little, just out of curiosity. |
05-12-2010, 09:37 AM | #25 | |
Member
Posts: 18
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
Quote:
|
|
05-13-2010, 12:38 AM | #26 |
Enthusiast
Posts: 41
Karma: 52
Join Date: May 2010
Location: Victoria, BC, Canada
Device: Kobo, Kobo for iPhone, Aluratek Libre
|
Awesome info darkadapt - it helped me to remove a lot of the kruft books I didn't want and get some 60mb of storage back. I have figured out the format of the .parsed files and posted a quick description here. Feel free to add it to your site
|
05-13-2010, 09:52 AM | #27 | |
Member
Posts: 18
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
Quote:
|
|
05-13-2010, 11:35 AM | #28 |
Addict
Posts: 324
Karma: 25168
Join Date: May 2010
Device: kobo
|
Firefox SQLite add-on
I have been finding this Firefox SQLite manager add-on very useful and speedy:
https://addons.mozilla.org/en-US/firefox/addon/5817/ |
05-18-2010, 01:53 PM | #29 |
Enthusiast
Posts: 36
Karma: 10
Join Date: May 2010
Location: Nova Scotia
Device: Kobo Version 1 firmware v 1.8.3
|
hi
I have a sqlite database browser om my linux machine , it opens in a three tab window (KoboReader.sqlite), structure , browse data and execute sql.. in the first tab is the sql tree , the second the contents data, all 4737 entries.. there is a delete record item on the upper right .. The file is a copy on my HD , not on my reader, If I mess it up not a problem .. Looking for a few ideas on what to do ... And if it is possible to remove/ edit all the entries... how is or what happens if it is copied on the Kobo reader Harry |
05-18-2010, 10:46 PM | #30 |
Member
Posts: 18
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
I've expanded on my initial findings at my wiki (http://wiki.durbn.net/koboko/index.php/DBSchemaV2). Feel free to add what you know as well.
|
Thread Tools | Search this Thread |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sqlite database replacement instructions | pholy | Kobo Reader | 62 | 10-11-2012 09:19 AM |
Koboreader.sqlite gundged | maxwelledison | Kobo Reader | 21 | 01-12-2011 08:24 AM |
Calibre and Kobo database | crowez | Calibre | 1 | 10-15-2010 08:24 PM |
Kobo Database Browser - SQLite | JBlyth | Kobo Reader | 2 | 06-06-2010 09:27 PM |
sqlite samba lock | rootto | Calibre | 4 | 09-27-2009 02:03 PM |