What happens to ID when it exceeds 9999?

Geremia · 10-23-2018, 12:31 PM

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?

DaltonST · 10-23-2018, 03:29 PM

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.

Geremia · 10-31-2018, 03:45 PM

Quote:

Originally Posted by DaltonST

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.

theducks · 10-31-2018, 04:01 PM

Quote:

Originally Posted by Geremia

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

kovidgoyal · 11-01-2018, 01:26 AM

You likely deleted the first 999 books.

10-23-2018, 12:31 PM	#1
Geremia Addict Posts: 235 Karma: 100000 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?

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

10-23-2018, 03:29 PM	#2
DaltonST Deviser Posts: 2,265 Karma: 2090983 Join Date: Aug 2013 Location: Texas Device: none	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.

11-01-2018, 01:26 AM	#5
kovidgoyal creator of calibre Posts: 43,850 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	You likely deleted the first 999 books.