Database structure question

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

What exactly is the annotations_dirtied and metadata_dirtied for?

BetterRed · 02-21-2021, 05: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, 11: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, 05:14 PM	#1
ownedbycats Custom User Title Posts: 11,387 Karma: 79699999 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 04:02 PM
REQ: input on Database Structure and testing a workaround input	jecilop	Library Management	15	12-17-2015 01:10 AM
Story Structure Database	crich70	Writers' Corner	7	04-23-2015 01:31 PM
File Structure Question	Tiburon	Calibre	2	01-11-2010 10:21 PM
Question about the File structure	bbusybookworm	Amazon Kindle	3	11-23-2007 07:45 PM

02-21-2021, 05:32 PM	#2
BetterRed null operator (he/him) Posts: 22,046 Karma: 30277960 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, 11:09 PM	#3
kovidgoyal creator of calibre Posts: 45,664 Karma: 28549046 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