Database structure question

ownedbycats · 02-21-2021, 04:14 PM

What exactly is the annotations_dirtied and metadata_dirtied for?

BetterRed · 02-21-2021, 04:32 PM

I'll take a stab: they are queues, indicating annotation and metadata changes have not been written to the metadata.opf files in the book folders. The updating of the metadata.opf files in the book folders is done in a separate low priority thread - the dirtied tables are neccessited by the need to catch up if calibre is terminated before the queues are emptied.

I am not 100% sure annotation backups are stored in the metadata.opf file, but…

BR

kovidgoyal · 02-21-2021, 10:09 PM

metadata_dirtied is for metadata.opf backup as BR explained, annotations_dirtied is for when the viewer which is a separate process makes changes to annotations in a book in the calibre library. The annotations_dirtied queue is used to feed into metadata_dirtied queue.

02-21-2021, 04:14 PM	#1
ownedbycats Custom User Title Posts: 8,603 Karma: 61176603 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Database structure question What exactly is the annotations_dirtied and metadata_dirtied for?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to manage structure detection question	LadyKate	Conversion	2	10-19-2016 03:02 PM
REQ: input on Database Structure and testing a workaround input	jecilop	Library Management	15	12-17-2015 12:10 AM
Story Structure Database	crich70	Writers' Corner	7	04-23-2015 12:31 PM
File Structure Question	Tiburon	Calibre	2	01-11-2010 09:21 PM
Question about the File structure	bbusybookworm	Amazon Kindle	3	11-23-2007 06:45 PM

02-21-2021, 04:32 PM	#2
BetterRed null operator (he/him) Posts: 20,565 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	I'll take a stab: they are queues, indicating annotation and metadata changes have not been written to the metadata.opf files in the book folders. The updating of the metadata.opf files in the book folders is done in a separate low priority thread - the dirtied tables are neccessited by the need to catch up if calibre is terminated before the queues are emptied. I am not 100% sure annotation backups are stored in the metadata.opf file, but… BR

02-21-2021, 10:09 PM	#3
kovidgoyal creator of calibre Posts: 43,850 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	metadata_dirtied is for metadata.opf backup as BR explained, annotations_dirtied is for when the viewer which is a separate process makes changes to annotations in a book in the calibre library. The annotations_dirtied queue is used to feed into metadata_dirtied queue.

Advert