Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Amazon Kindle > Kindle Developer's Corner

Notices

Reply
 
Thread Tools Search this Thread
Old 12-31-2012, 02:29 PM   #1
rah68
readaholic
rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.
 
rah68's Avatar
 
Posts: 28
Karma: 87602
Join Date: Dec 2012
Location: Connecticut
Device: Kindle Fire, Kindle Paperwhite, Kindle Fire HD 8.9
KPW.....collection.......question

When I add a book that i have finished to my "read books" collection, it stays in my list of books AND in the collection. So.....I tried "remove book from device" from the main list......and it deletes BOTH the main list one and the one in the "read books" folder. Anyone else have this problem ??

My solution atm is to go ahead and delete it.......If i need it, it is in Calibre anyway
rah68 is offline   Reply With Quote
Old 12-31-2012, 02:46 PM   #2
ixtab
(offline)
ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.
 
ixtab's Avatar
 
Posts: 2,903
Karma: 6677557
Join Date: Dec 2011
Device: K3, K4, K5, KPW, KPW2
Quote:
Originally Posted by rah68 View Post
When I add a book that i have finished to my "read books" collection, it stays in my list of books AND in the collection. So.....I tried "remove book from device" from the main list......and it deletes BOTH the main list one and the one in the "read books" folder. Anyone else have this problem ??

My solution atm is to go ahead and delete it.......If i need it, it is in Calibre anyway
Collections are not what you probably think they are. They are not folders, but only "tags" added to a book. A book can be in multiple collections at the same time, and unless you order the items on your device "by collection", books will appear both on the home screen, and in all the collections they have been "filed into"/tagged with.

Last edited by ixtab; 12-31-2012 at 02:50 PM. Reason: typos
ixtab is offline   Reply With Quote
Old 01-04-2013, 09:27 AM   #3
rah68
readaholic
rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.
 
rah68's Avatar
 
Posts: 28
Karma: 87602
Join Date: Dec 2012
Location: Connecticut
Device: Kindle Fire, Kindle Paperwhite, Kindle Fire HD 8.9
Excuse me but that's illogical.....( to quote Mr Spock )

A......it does it in my Kindle fire
B it does it in my Kindle keyboard
It does NOT do it in Paperwhite :-(

why bother making a collection at all if the book is to remain on the home screen.....the idea there was to unclutter the list on the home screen yet, still have the book on the device
rah68 is offline   Reply With Quote
Old 01-04-2013, 09:33 AM   #4
knc1
Helpdesk Junkie
knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.knc1 ought to be getting tired of karma fortunes by now.
 
knc1's Avatar
 
Posts: 6,676
Karma: 5850002
Join Date: Feb 2012
Device: Too many.
Quote:
Originally Posted by rah68 View Post
Excuse me but that's illogical.....( to quote Mr Spock )
Depends on which way your ears point.

This system allows a book to be included in multiple collections -
By author
By publisher
By genre
By publication date
By title
By <whatever floats your boat>
knc1 is online now   Reply With Quote
Old 01-04-2013, 10:12 AM   #5
HarryT
eBook Enthusiast
HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.
 
HarryT's Avatar
 
Posts: 64,023
Karma: 42472847
Join Date: Nov 2006
Location: UK
Device: PW2, iPad Retina Mini, iPhone 4, MS Surface Pro, Kobo H2O, N7
Quote:
Originally Posted by rah68 View Post
Excuse me but that's illogical.....( to quote Mr Spock )

A......it does it in my Kindle fire
B it does it in my Kindle keyboard
It does NOT do it in Paperwhite :-(

why bother making a collection at all if the book is to remain on the home screen.....the idea there was to unclutter the list on the home screen yet, still have the book on the device
You won't see the book on your home screen if you switch to "Collection" sort mode. That view will show you only collections, plus books which aren't in any collection.

But the important thing to stress is that a collection is not a folder, but a tag. A lot of people misunderstand this, and it's a very important distinction. It's the fact that it is a tag which allows the same book to appear in multiple collections, while at the same time only having a single copy of it on the device.

Last edited by HarryT; 01-04-2013 at 10:31 AM.
HarryT is offline   Reply With Quote
Old 01-05-2013, 10:46 AM   #6
rah68
readaholic
rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.rah68 knows better than to ask about the Gravitic Imploder Lance.
 
rah68's Avatar
 
Posts: 28
Karma: 87602
Join Date: Dec 2012
Location: Connecticut
Device: Kindle Fire, Kindle Paperwhite, Kindle Fire HD 8.9
Quote:
Originally Posted by HarryT View Post
You won't see the book on your home screen if you switch to "Collection" sort mode. That view will show you only collections, plus books which aren't in any collection.
Ahhh I see now ( said the blind man headed for the cliff)

thats much more betterer
rah68 is offline   Reply With Quote
Old 01-05-2013, 11:15 AM   #7
ixtab
(offline)
ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.
 
ixtab's Avatar
 
Posts: 2,903
Karma: 6677557
Join Date: Dec 2011
Device: K3, K4, K5, KPW, KPW2
Quote:
Originally Posted by HarryT View Post
You won't see the book on your home screen if you switch to "Collection" sort mode. That view will show you only collections, plus books which aren't in any collection.

But the important thing to stress is that a collection is not a folder, but a tag. A lot of people misunderstand this, and it's a very important distinction. It's the fact that it is a tag which allows the same book to appear in multiple collections, while at the same time only having a single copy of it on the device.
Thanks, Harry, for explaining this again in an easy-to-understand way

For the technically inclined: Think of the book <-> collection relation as an n:m relation in a database. And - guess what - that's exactly what it (logically) is in the underlying SQLite database. Except that the people who implemented it might want to revisit their cs1xx course material (Introduction to Databases), because they must have been in a coma during the normalization part of the lecture. The database actually does it in the worst possible way for an n:m relation, namely using NF² at both ends of the relation.
ixtab is offline   Reply With Quote
Old 01-05-2013, 11:17 AM   #8
HarryT
eBook Enthusiast
HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.
 
HarryT's Avatar
 
Posts: 64,023
Karma: 42472847
Join Date: Nov 2006
Location: UK
Device: PW2, iPad Retina Mini, iPhone 4, MS Surface Pro, Kobo H2O, N7
Quote:
Originally Posted by ixtab View Post
For the technically inclined: Think of the book <-> collection relation as an n:m relation in a database. And - guess what - that's exactly what it (logically) is in the underlying SQLite database. Except that the people who implemented it might want to revisit their cs1xx course material (Introduction to Databases), because they must have been in a coma during the normalization part of the lecture. The database actually does it in the worst possible way for an n:m relation, namely using NF² at both ends of the relation.
Probably more robust, though, than using the technically "better" solution of a link table. Link tables are prone to getting broken if things go awry. Performance is probably also better, because you can do queries without (or with fewer) table joins. A lot of my "day job" work is with databases, and we often end up with a certain degree of denormalisation for both the reasons I've mentioned.

Last edited by HarryT; 01-05-2013 at 11:21 AM.
HarryT is offline   Reply With Quote
Old 01-05-2013, 11:20 AM   #9
ixtab
(offline)
ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.
 
ixtab's Avatar
 
Posts: 2,903
Karma: 6677557
Join Date: Dec 2011
Device: K3, K4, K5, KPW, KPW2
Quote:
Originally Posted by HarryT View Post
Probably more robust, though, than using the technically "better" solution of a link table. Link tables are prone to getting broken if things go awry.
???

That's what databases are there for: they can maintain referential integrity by themselves. SQLite supports all of that - why not use it?
ixtab is offline   Reply With Quote
Old 01-05-2013, 11:23 AM   #10
HarryT
eBook Enthusiast
HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.
 
HarryT's Avatar
 
Posts: 64,023
Karma: 42472847
Join Date: Nov 2006
Location: UK
Device: PW2, iPad Retina Mini, iPhone 4, MS Surface Pro, Kobo H2O, N7
Quote:
Originally Posted by ixtab View Post
???

That's what databases are there for: they can maintain referential integrity by themselves. SQLite supports all of that - why not use it?
Have you ever dared to venture into the Kobo forum? The Kobo stores ALL its library information in a database, and the number of times it breaks, resulting in the need to reload all books, is alarming.
HarryT is offline   Reply With Quote
Old 01-05-2013, 11:26 AM   #11
ixtab
(offline)
ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.
 
ixtab's Avatar
 
Posts: 2,903
Karma: 6677557
Join Date: Dec 2011
Device: K3, K4, K5, KPW, KPW2
Quote:
Originally Posted by HarryT View Post
Have you ever dared to venture into the Kobo forum? The Kobo stores ALL its library information in a database, and the number of times it breaks, resulting in the need to reload all books, is alarming.
Nope, I haven't been there - I don't own a Kobo.
But I do have a degree in Computer Science, with a specialization in databases... and I definitely know that if you use a DBS correctly, it will save you from all sorts of trouble (and effort!), instead of causing it.


Last edited by ixtab; 01-05-2013 at 11:29 AM.
ixtab is offline   Reply With Quote
Old 01-05-2013, 02:14 PM   #12
ixtab
(offline)
ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.ixtab ought to be getting tired of karma fortunes by now.
 
ixtab's Avatar
 
Posts: 2,903
Karma: 6677557
Join Date: Dec 2011
Device: K3, K4, K5, KPW, KPW2
Quote:
Originally Posted by HarryT View Post
Performance is probably also better, because you can do queries without (or with fewer) table joins. A lot of my "day job" work is with databases, and we often end up with a certain degree of denormalisation for both the reasons I've mentioned.
Sorry, I only read this part of your reply now.

Yes, that's a valid point, and denormalization does make sense at times. But just before we start, how many Terabytes of data does an e-reader hold, and how many thousands of concurrent transactions does it have to process per second? Are we talking about hundreds of table joins, where each table could contain millions of records?

...

Of course, the following are all unsubstantiated claims - nobody except Amazon knows what exactly is happening in their code after all. I'm just sticking with how Amazon organized their database schema - we're talking about 0 joins (as opposed to 2), followed by JSON parsing and (in most of the cases) at least one additional DB query to "simulate" the join - because the data has to be retrieved anyway, and I actually doubt that they do all of the retrieval in one go; I rather think that it will be n additional queries.

Essentially, I strongly suppose that they "reimplemented" the join in client code. So also in terms of performance, I'd bet that a proper database schema would outperform the current one - even for the extremely small database that a Kindle holds. Plus, it could also provide referential integrity at no cost.

Another unsubstantiated claim: if the Kobo really has that many problems with its database, then I assume that it's for the exact same reason. A database system can do so much more than just "put things in there and get them out of there", but one actually has to understand at least a little bit of the theory to use it efficiently. Seriously, the DB schema that Amazon uses is pretty much what any 16-year old would intuitively come up with. They're essentially not using ANY of the benefits that a DBMS really offers - they could have just used plain files instead*.

(*) Yes, the collections actually were plain files before the K5. So they just seem to have ported that "to a database". But why build an entire new API around it, if they don't use the benefits of the DB? Just because "management asked that the collections must be stored in databases now"? What's the point?
ixtab is offline   Reply With Quote
Old 01-05-2013, 11:57 PM   #13
twobob
( ͡° ͜ʖ ͡°){ʇlnɐɟ ƃǝs}Týr
twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.twobob ought to be getting tired of karma fortunes by now.
 
twobob's Avatar
 
Posts: 6,552
Karma: 6021142
Join Date: Jun 2012
Location: uti gratia usura (Yao ying da ying; Mo ying da yieng)
Device: PW-WIFI|K5-3G+WIFI| K4|K3-3G|DXG|K2| Rooted Nook Touch
future proofing?

Oh and the kobo does it you know! So it must be good...

sqlcipher also springs to mind but meh. cmon. really? Nah... surely not.

For my part I appreciate the schema, possessing the skills of the average 16 year old it suits me perfectly... Thank you that decision maker!
twobob is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
KPW No Covers? setite Amazon Kindle 3 10-08-2012 11:36 AM
Collection question crich70 Upload Help 1 01-13-2012 09:14 AM
Kindle NT Collection Question Laura81 Amazon Kindle 9 12-21-2011 01:21 AM
PRS-650 PRS-650 Collection folder question daqddyo1 Sony Reader 8 01-08-2011 07:07 AM
Question about collection ranjankm80 Amazon Kindle 3 01-02-2011 11:09 PM


All times are GMT -4. The time now is 06:12 PM.


MobileRead.com is a privately owned, operated and funded community.