05-03-2010, 03:55 PM | #1 |
Member
Posts: 18
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
Kobo sqlite database
Both the eReader and the desktop software stores it's books and meta information in sqlite databases.
Books that are bought from the Kobo book store are not stored as epub files but are stored in a sqlite database. (on the kobo reader it's under the hidden folder .kobo) Plus, any epub or pdf's you add to the kobo including any that are stored on an sd-card are loaded into this sqlite database. NOTE: The entire epub/pdf is not stored in the database, but things like title, author, chapters, read status, etc are. I've started analyzing this database format and plan to write a little program to help manage things like cover images, read status (read, unread, finished), etc. Is anyone interested in something like this? Plus if anyone wants, I'll post my documentation on the sqlite database schema. |
05-03-2010, 04:02 PM | #2 |
Connoisseur
Posts: 51
Karma: 12
Join Date: May 2010
Device: Kobo EReader
|
Yes, it's an excellent idea!
|
Advert | |
|
05-03-2010, 05:16 PM | #3 |
Zealot
Posts: 108
Karma: 188
Join Date: May 2010
Location: Montreal, QC
Device: Kobo,Nokia N900
|
Indeed a good idea.. post your findings.
Thanks |
05-03-2010, 05:38 PM | #4 |
Enthusiast
Posts: 35
Karma: 64
Join Date: Apr 2010
Device: none
|
I like it. You could easily write your own desktop syncing application that way.
|
05-03-2010, 07:01 PM | #5 | |
Member
Posts: 11
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
Kobo manager program
Quote:
|
|
Advert | |
|
05-03-2010, 07:48 PM | #6 |
Grand Sorcerer
Posts: 12,634
Karma: 74500000
Join Date: Nov 2007
Location: Toronto
Device: Libra H2O, Libra Colour
|
Fantastic idea! I had done some snooping through the database; both the one stored on the Kobo and the local copy on the PC (under Vista it's in the
Code:
%LOCALAPPDATA%/Kobo/Kobo Desktop Edition |
05-03-2010, 08:29 PM | #7 |
Member
Posts: 18
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
Yup I have a user on launchpad. I'll create a project either later tonight or tomorrow morning/
I prefer C++ with Qt as that is what i'm most familiar with. |
05-03-2010, 11:42 PM | #8 |
Member
Posts: 11
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
Koboko?
I assume this is it: https://launchpad.net/koboko
Downloading Bzr on my Mac now :-) Oh, and Qt/C++ sounds good. Cheers |
05-04-2010, 01:08 AM | #9 |
Member
Posts: 20
Karma: 10
Join Date: May 2010
Location: North Vancouver, BC
Device: Kindle 2
|
Hmm, not Python, eh?
|
05-04-2010, 11:13 AM | #10 | ||
Chief Inspector Gamache
Posts: 123
Karma: 12
Join Date: May 2010
Location: Canada eh!
Device: Viewsonic
|
Quote:
Quote:
Thanks |
||
05-04-2010, 12:04 PM | #11 |
Member
Posts: 18
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
Ok I set up a project on launchpad and created a team. It's my first launchpad project so if I configured something not your liking let me know.
Project is found here: https://launchpad.net/koboko Team is found here: https://launchpad.net/~koboko My next question is what do people want/need? Some of the things I have thought of is:
I don't really intend to create a Calibre clone or to completely replace the Kobo desktop software. any ideas? |
05-04-2010, 06:36 PM | #12 | ||
Member
Posts: 11
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
Quote:
+ Maintain a master copy of the SQLite database on the user's hard disk, so all changes (books/documents added/removed/edited) are made into that first and then sent to the Kobo device's copy of the database (or maybe it's done simultaneously). + Wish list: if only there were some way to prevent the device from locking and updating its database on disconnect--seems like bad design. Maybe that'll change if smarter software comes along to manage the DB while it is connected. Quote:
Design-wise, the simplest thing I can think of is a list-detail view where the list of books/documents is on top and the detail (a data entry form) is at the bottom. Is anything else needed? I doubt it.... Thanks for setting up. I'm joining right now. |
||
05-05-2010, 05:48 AM | #13 |
Chief Inspector Gamache
Posts: 123
Karma: 12
Join Date: May 2010
Location: Canada eh!
Device: Viewsonic
|
From a USER point - Thanks guys.
What will happen IF Kobo decides to change their db structure (can they do that) when releasing a new firmware? Is that a stupid question - sorry. |
05-06-2010, 03:42 PM | #14 |
Member
Posts: 18
Karma: 10
Join Date: May 2010
Device: Kobo eReader
|
They absolutely can change their db structure. From what it looks like they use a table called "DBVersion" that contains a single number that would be increased when they change formats. We'll just have to make sure we watch that number and not allow writes if the schema is different. Backups are always a good thing too!!!!!
I've got a few notes here -> https://sites.google.com/a/durbn.net...atabase-schema. I know it's not an open wiki. My webserver is down at the moment but the second I get it up I'll set up a proper mediawiki for it. Hopefully after this weekend sometime. I've been adding a bit of code to the app. It's still to early for any real use yet. |
05-06-2010, 05:09 PM | #15 |
Addict
Posts: 324
Karma: 25168
Join Date: May 2010
Device: kobo
|
I just used SQLite Expert -- free graphical sqlite program -- and opened up the database to delete dozens of the freebie books -- worked great.
(But does this actually get rid of the book data itself??) (Oops. How embarrassing.) Last edited by corona; 05-06-2010 at 05:55 PM. |
|
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 |