03-22-2013, 11:03 PM | #1 |
Junior Member
Posts: 3
Karma: 10
Join Date: Mar 2013
Device: kindle
|
I have a question about the end of folder path,help!
I add a book and the folder path:
Rowling, J.K -> Harry Potter 3 - Harry Potter And The Prisoner of Azkaban (53) the end of path is number. If I delete the book and add another one, the folder path must be xxx(54). Is it a rule or something? Please help me, thank you very much. |
03-22-2013, 11:13 PM | #2 | |
Well trained by Cats
Posts: 29,807
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
KEEP OUT The GUI manages the folder. IF YOU WANT TO DELETE/ADD/REPLACE: Use the GUI (or CLI). That way, calibre keeps track of it all. (the number matches a specific entry, you could have 2 copies of the same title...the numbers will be different.) For more: Read the sticky about file names at the top of this section. |
|
03-23-2013, 12:00 AM | #3 | |
Junior Member
Posts: 3
Karma: 10
Join Date: Mar 2013
Device: kindle
|
Quote:
Rowling, J.K -> Harry Potter 3 - Harry Potter And The Prisoner of Azkaban (53) I delete the book by using the GUI, and the folder delete. Next, I add same book,but the folder:J.K -> Harry Potter 3 - Harry Potter And The Prisoner of Azkaban (54). It must be something wrong, if I delete a book and add a new book, hte number should be 53. my os is fedora18. |
|
03-23-2013, 12:30 AM | #4 |
Handy Elephant
Posts: 1,736
Karma: 26785668
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Thinkpad E595, Ubuntu Mate, Huawei Mediapad 5, Bouye Likebook Plus
|
So, let the number be 54. It is just a number that calibre add to ensure that every folder is unique, so there can be more than one book with exactly the same title and author. If calibre ever reuse numbers, or just keep incrementing them, I don't know.
|
03-23-2013, 12:52 AM | #5 |
null operator (he/him)
Posts: 20,572
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Adoby, my observation is that it just keeps incrementing - I 'regard' it more like an acquisition number - its meaningless - to humans.
In case anyone is wondering why one would have more than one 'book' with exactly the same title and author, different languages is one reason, different editions is another... BR |
03-23-2013, 01:40 AM | #6 | |
Junior Member
Posts: 3
Karma: 10
Join Date: Mar 2013
Device: kindle
|
Quote:
|
|
03-23-2013, 02:42 AM | #7 |
Wizard
Posts: 1,090
Karma: 6058305
Join Date: Sep 2010
Location: UK
Device: Kindle Paperwhite
|
Yes. Calibre uses an SQLite database. I believe (but haven't checked the code) that the number is from a column with autoincrement set. If I'm right, every time a record (ie book) is added, that column's value will be one greater than the previous value used. Deletions won't affect it.
Ultimately, though, it doesn't matter. The files and folders in the library folder are part of the database. Just ignore them, same as you ignore the SQLite database file itself. |
03-23-2013, 02:49 AM | #8 |
Handy Elephant
Posts: 1,736
Karma: 26785668
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Thinkpad E595, Ubuntu Mate, Huawei Mediapad 5, Bouye Likebook Plus
|
Most likely. Until the library becomes corrupted or the disk crash, and you have to create a new calibre library.
Most likely it is an integer that is at least 32 bits large. So when you have added something like 2,147,483,647 books (or possibly the double amount if the integer is unsigned) something unforseen might happen. Or not. If you continuously add one book per second to calibre it would take at least 68 years before that limit is reached. By that time calibre will most likely have been updated to handle larger integers, if it doesn't already. |
03-23-2013, 03:05 AM | #9 |
null operator (he/him)
Posts: 20,572
Karma: 26954694
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Yep - like the numbers on bank notes
Adoby - I think its up to 64bit - sqllite has dynamic containers see http://stackoverflow.com/questions/7...integer-bigint So that would be up 18,446,744,073,709,551,615 books, the Library of Congress has mere 32,000,000ish BR Last edited by BetterRed; 03-23-2013 at 03:21 AM. |
03-23-2013, 05:35 AM | #10 |
Handy Elephant
Posts: 1,736
Karma: 26785668
Join Date: Dec 2009
Location: Southern Sweden, far out in the quiet woods
Device: Thinkpad E595, Ubuntu Mate, Huawei Mediapad 5, Bouye Likebook Plus
|
Ok, something like 580,000,000,000 years then, if you keep adding one book per second.
The sun is expected to expand to beyond the earth's orbit in about 7,000,000,000 years, so calibre should be okay. No worries. :X If you wish to lower the numbers used I suspect that you could just create a new library and copy all the books over there. (Using the GUI!) Then I assume that numbers from 1 and up will be used in consecutive order. Last edited by Adoby; 03-23-2013 at 05:41 AM. |
03-23-2013, 10:46 AM | #11 |
Well trained by Cats
Posts: 29,807
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Yes,
Numbers are never reused. The number is not a COUNT, it is a DB entry log ID. The Send To Device} template is {id} (this number is also shown in the Details pane). The book could still be on your device and not in Calibre, which is why I use {ID} in my template, to help differentiate possible 'duplicate entries' on my devices: file name only, catalog. |
03-23-2013, 10:48 AM | #12 | |
Well trained by Cats
Posts: 29,807
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
|
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Arc Folder question | Carpman | Kobo Tablets | 14 | 12-19-2012 01:35 PM |
Kindle Fire:Why Do My MOBI Files End Up in my DOCUMENTS Folder Instead of BOOKS?? | Nalapombu | Calibre | 7 | 04-22-2012 02:16 PM |
Folder question | TwinmtnNH | Library Management | 23 | 04-02-2011 04:19 PM |
Folder organization question | timezone | iRex | 12 | 04-17-2009 12:17 PM |
Can I change path/folder & Q re meta information loss | Scotch | Calibre | 2 | 12-31-2008 09:27 PM |