10-03-2011, 05:37 PM | #16 |
<Insert Wit Here>
Posts: 1,017
Karma: 1275899
Join Date: Jan 2008
Location: Puget Sound
Device: Kindle Oasis, Kobo Forma
|
Yeah, good news is that the database of information is still there, and it's still easy to read if you know what you are looking at.
There is now a 'books.db' file which is a SQLite3 DB. This contains all the information on the books that are on the device, collections, current positions and so on. H:\Sony_Reader\database\books.db H:\Sony_Reader\database\media\books\* Rather interesting, though. The SQLite DB offers better speed, and it should be fairly straight-forward to talk to it from a Calibre plugin (seeing that the Kobo also uses a SQLite DB). Although it will definitely have to be done basically from scratch. Syncing of collections from tags should be fairly easy, as would be auto-generating thumbs like before. |
10-03-2011, 06:52 PM | #17 |
creator of calibre
Posts: 43,866
Karma: 22666666
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
Cool, hopefully someone with a T1 and the time to work on the plugin will turn up soon.
|
10-03-2011, 11:10 PM | #18 |
Groupie
Posts: 167
Karma: 2627964
Join Date: Aug 2010
Location: Alabama, USA
Device: Kobo Aura One, Kobo Libra 2
|
Kovid - Will the beta you've linked to above work with Linux?
|
10-04-2011, 12:20 AM | #19 |
creator of calibre
Posts: 43,866
Karma: 22666666
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
No, you will have to wait for the next release, or run from source as described here:
http://manual.calibre-ebook.com/develop.html |
10-04-2011, 12:45 AM | #20 |
Groupie
Posts: 167
Karma: 2627964
Join Date: Aug 2010
Location: Alabama, USA
Device: Kobo Aura One, Kobo Libra 2
|
Thank you, Kovid!
My reader should be here tomorrow so I think I'll just install the beta version on the Windows side of my laptop for now. I'll go back to Ubuntu + Calibre for syncing once there's a new release. |
10-05-2011, 12:23 AM | #21 | |
Grand Sorcerer
Posts: 11,742
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
I can set up a chip-in account if there is enough interest. Alternatively I can provide an appropriate Euro-denominated PayPal address, which would be better for people who don't live in US$ because we would avoid double currency conversions. If I take the latter approach I would post progress here. In both cases I would refund all the contributions if the goal is not reached, as happened with my proposed Android project some time back. Note that I can't commit that the T1 will integrate to the same level as the previous Sonys until I see it. Assuming kolenka is correct it should be possible, but the devil will be in the details (Kindle collections are a great example of ways to break integration). Also note that I expect to support the device using the cable, not over WiFi. |
|
10-05-2011, 12:46 AM | #22 |
<Insert Wit Here>
Posts: 1,017
Karma: 1275899
Join Date: Jan 2008
Location: Puget Sound
Device: Kindle Oasis, Kobo Forma
|
I can give you a copy of the SQLite DB to investigate yourself if you like. I haven't seen anything at this point that creates a technical hurdle
The DB is relational, which will help a bit with collection management. Thumbnail file paths are stored in the books table. I haven't dived in to try to find a pattern to Sony's own choice of where to put thumbnails. I also haven't yet checked to see if Sony uses a single DB or if it has one DB in main memory and another on the SD card. I'm doing a little work getting accustomed to the Calibre plugin model and the existing PRS and Kobo plugins (since the Kobo plugin uses SQLite). But it is a little slow simply from lack of knowledge of the code, and having to fit it in with what little free time I have. EDIT: Doesn't help when Bazaar isn't Lion compatible out of the box. Took me a bit to actually read the warning on that one. Last edited by Kolenka; 10-05-2011 at 12:49 AM. |
10-05-2011, 01:09 AM | #23 | ||
Grand Sorcerer
Posts: 11,742
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
- time zone management. Current sony devices do very strange things with timestamps and timezones, usually resulting in throwing away the info in the database. - Resetting their reader app. There might be issues with getting the device to actually re-read the database. For example, you must actually reboot a kindle to get it to read changes to the collection database. I truly hope that Sony hasn't done something equally silly. - Interactions with the device's book management. I have had difficulties in the past trying to convince the Sony not to reread metadata from books when the DB changes. This is similar to the timezone problem. - Collection management of removable memory. You allude to this problem. - Android partition protection may get in the way, but I am less concerned about this because the Sony app must be able to talk to the database. - Interactions with Sony software. My biggest concern here is any over-the-air purchase features they might have added. Quote:
There are a lot of pieces to understand in addition to the DB, such as job sequencing, plugboard interactions (there are special 'features' for sony devices), collection sorting, collection name rewriting, and thumbnail regeneration. No surprise at all that it is taking you some time. |
||
10-05-2011, 02:32 AM | #24 | |||||
<Insert Wit Here>
Posts: 1,017
Karma: 1275899
Join Date: Jan 2008
Location: Puget Sound
Device: Kindle Oasis, Kobo Forma
|
Couple comments...
Quote:
Quote:
Quote:
Quote:
Quote:
Part of what makes it take time is the inheritance that plugins have. While somewhat documented, inheritance tends to mask what a plugin really does. So it takes longer for the bigger picture to snap into focus. At least the thumbnail paths make sense now. The path just points into the cache, into a folder whose name is the id # for the row in the book table. So if a book has an _id of 89, then the thumbnail will be under the 89 folder in the cache folder. That makes it fairly easy to figure out where to put a thumbnail without clashing with Sony's software. |
|||||
10-05-2011, 02:57 AM | #25 | |
US Navy, Retired
Posts: 9,864
Karma: 13806776
Join Date: Feb 2009
Location: North Carolina
Device: Icarus Illumina XL HD, Nexus 7
|
Quote:
So no regression in behavior. Last edited by DoctorOhh; 10-05-2011 at 06:54 AM. |
|
10-05-2011, 06:36 AM | #26 |
Wizard
Posts: 4,552
Karma: 950151
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
|
Duplicate collections also seems to be the case on my 950 where I have a memory stick plugged in (although I normally use that for audiobooks rather than ebooks). I might plug in a SD card as well to see if it is possible to get 3 copies of a collection in such a case.
|
10-05-2011, 06:38 AM | #27 | |
Zealot
Posts: 108
Karma: 17102
Join Date: Sep 2010
Location: San Diego, CA
Device: PRS-505 600 300 350 T1 T2 Kindle PW1 PW2 KV Clara 2E Libra 2 Leaf 2
|
Hi Kolenka,
Quote:
I also have a question for you. I download kovidgoyal's calibre version that supports the T1 and am able to load files onto my reader using it. Switching over to the "Device" view I see the newly added books. However when I disconnect from my PC then reconnect, the "Device" view is empty, although I can still add new books. Am I missing something to make this work correctly? Thanks a lot! |
|
10-05-2011, 12:55 PM | #28 | ||
<Insert Wit Here>
Posts: 1,017
Karma: 1275899
Join Date: Jan 2008
Location: Puget Sound
Device: Kindle Oasis, Kobo Forma
|
Quote:
Quote:
|
||
10-05-2011, 01:21 PM | #29 | |
creator of calibre
Posts: 43,866
Karma: 22666666
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
Quote:
|
|
10-05-2011, 01:32 PM | #30 |
<Insert Wit Here>
Posts: 1,017
Karma: 1275899
Join Date: Jan 2008
Location: Puget Sound
Device: Kindle Oasis, Kobo Forma
|
Then I'm at a loss as to what the bug would be. You know the code a lot better than me, and the reader still behaves like a standard USB Mass Storage device. It isn't interfering with the generic driver.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Prs 505 Sony and calibre 0.8 | duduche33 | Devices | 3 | 05-12-2011 10:50 AM |
Calibre for Sony prs 350 | Rick1971 | Calibre | 4 | 12-26-2010 12:27 PM |
Calibre and Sony PRS-600 | Archergal5219 | Calibre | 2 | 07-25-2010 12:32 AM |
Sony PRS-505/Sony Connect/Calibre | thesweetone | Sony Reader | 26 | 09-30-2009 03:00 PM |
Calibre and Sony PRS-600 | lukasfikr | Calibre | 10 | 08-26-2009 09:11 PM |