MobileRead Forums - View Single Post - Is there a limit to the number of books Calibre can handle?

ownedbycats · 06-20-2020, 04:50 PM

I know this is an old thread, but I was curious about it too, mostly the hard limit of books the Calibre database can hold.

Calibre uses a sqlite database, and according to the SQLite documentation, the theoretical maximum number of rows in a table is 2*64 (no superscript?), which is....a very big number. Though you'll reach the 140 terabyte database size limit long before that number.

06-20-2020, 04:50 PM	#7
ownedbycats Custom User Title Posts: 11,018 Karma: 75555555 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I know this is an old thread, but I was curious about it too, mostly the hard limit of books the Calibre database can hold. Calibre uses a sqlite database, and according to the SQLite documentation, the theoretical maximum number of rows in a table is 264 (no superscript?), which is....a very big number. Though you'll reach the 140 terabyte* database size limit long before that number. Last edited by ownedbycats; 06-20-2020 at 04:55 PM.