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

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 10-23-2018, 12:31 PM   #1
Geremia
Zealot
Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.
 
Posts: 101
Karma: 8778
Join Date: Oct 2012
Device: Calibre
What happens to ID when it exceeds 9999?

The ID field is a 4 decimal digit serial number. What happens to ID when it exceeds 9999? Does the ID field become a 5 digit number?
Geremia is offline   Reply With Quote
Old 10-23-2018, 03:29 PM   #2
DaltonST
Deviser
DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.DaltonST is the One.
 
DaltonST's Avatar
 
Posts: 1,477
Karma: 101298
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
It is not a 4 digit number. It shows you the significant, non-zero integer version of it. When you go over 9999, it will show 10000. Then 100000. And so on.

The full length of an integer in SQLite (the database engine used by Calibre) is enormous. Maximum value: 2^63-1 = 9223372036854775807

Once that value is reached, you will have to create a new Library and copy all of your books from the old Library to that new Library, wherein all of the newly added books will be assigned a new book id starting with 1.
DaltonST is offline   Reply With Quote
Advert
Old 10-31-2018, 03:45 PM   #3
Geremia
Zealot
Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.Geremia shines like a glazed doughnut.
 
Posts: 101
Karma: 8778
Join Date: Oct 2012
Device: Calibre
Quote:
Originally Posted by DaltonST View Post
newly added books will be assigned a new book id starting with 1.
I wonder why my Calibre library's first ID didn't start at 1 but with a 4-digit number.
Geremia is offline   Reply With Quote
Old 10-31-2018, 04:01 PM   #4
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 23,223
Karma: 24102002
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by Geremia View Post
I wonder why my Calibre library's first ID didn't start at 1 but with a 4-digit number.
What makes you think it is?
The display in 'info' or details?

The DB has an Integer, so what is displayed has probably beenformatted
theducks is offline   Reply With Quote
Old 11-01-2018, 01:26 AM   #5
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 34,434
Karma: 10323934
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
You likely deleted the first 999 books.
kovidgoyal is offline   Reply With Quote
Advert
Reply

Tags
calibre, metadata

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to Import Google Play Books Library into Calibre Library? peterpandam Calibre 4 05-22-2018 01:15 AM
Move books from a calibre library (friend) to my library bulketerre Library Management 3 04-24-2018 10:01 AM
Adding books already in library directory but not library database sfguy5874 Library Management 1 07-07-2012 04:33 AM
How to direct Library books to Calibre instead of Sony Reader Library onebookie Calibre 3 07-19-2010 11:31 AM
Connect Store in Business until 9999! flyinggeek Sony Reader 1 11-25-2007 12:55 AM


All times are GMT -4. The time now is 02:23 AM.


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