MobileRead Forums - View Single Post - Question about the new Bookshelf view in Calibre 9 and the Pages database field

BetterRed · 01-31-2026, 10:35 PM

When an existing library is first opened , the three unused columns in the 'books' table are removed, the 'books_pages_link' table is created and a row for every book inserted with the pages, algorithm, format, and format_size cells set to 'empty', the needs_scan cells are set to '1'.

When the Shelf View is opened the pages, algorithm, format, format size, are populated and needs_scan is set to '0'.

A negative 'pages' value seems to indicates the book has no suitable formats - e.g. audio book files - mp3, m3u files etc

BR

01-31-2026, 10:35 PM	#5
BetterRed null operator (he/him) Posts: 22,276 Karma: 30317806 Join Date: Mar 2012 Location: Sydney Australia Device: none	Version 9 - database update details When an existing library is first opened , the three unused columns in the 'books' table are removed, the 'books_pages_link' table is created and a row for every book inserted with the pages, algorithm, format, and format_size cells set to 'empty', the needs_scan cells are set to '1'. When the Shelf View is opened the pages, algorithm, format, format size, are populated and needs_scan is set to '0'. A negative 'pages' value seems to indicates the book has no suitable formats - e.g. audio book files - mp3, m3u files etc BR Attached Thumbnails Last edited by BetterRed; 02-01-2026 at 04:51 PM.