I'm guessing it is kept instead in the metadata.opf file eCalibre makes, but I'm not sure how to go about verifying this, and then easily transferring it to the new library.
Although I am disappointed that eCalibre apparently doesn't store it with the book itself.
Yeah i find myself not trusting calibre as a library manager. I was experimenting with adding tags and wasn't happy with the results. If i can't have it be inside the epub/book then i don't want to use it, since it won't be transferred with the book itself.
There's a
datadata.db file that is in the Calibre Library save/working directory, which i suspect is where it stores the information. Uses SQLite, so you could peruse but i haven't incorporated SQLite in any projects so not sure how much i could automate it using the tables it provides.
I initially separated out my Erotica from my other books, so I didn't out myself to my (assumed vanilla, friends, and family), I share my library with.
And then finding the lag of working/tweaking with a huge library I separated out my Fantasy and Sci-Fi sections also. But now it's looking as if I might be better off recombining it all,
Though, if you have books separated in directories of different genres, then applying and adding that tag to all books within wouldn't be that hard.
--
I came to the conclusion unless it's blatantly erotica in title and/or cover, then you can treat it as non-erotica. There's a lot of non-erotica that has erotic scenes, but they tend to be here or there, or some that reference sex but never put the scene up.
Piers Anthony, one of my favorite authors (
as a child), has several sections where it vaguely describes something sexual or skips past it.
Geis of the Gargoyle comes to mind. Plenty of descriptions of topless girls, but doesn't go full out into erotic sex, and 'what the magician married' i think., though cant' find the exact book.
Then there's books my mom described to me and how she would skip the sex scenes,
Clan of the Cave Bear by Jean Auel, books of prehistoric living of humans vs Neandertals and knowledge inferred by birth vs experience and how it changed the clans.
Then there's Anne Rice, with vampires, but descriptions of the vampires giving of the act of feeding having a higher/on par erotic euphoria as sex/orgasm. Or how Lestat would intentionally target whores and husband killers...
Then Eric Vall, has
Succubus lord.... and as it enters any sex scene it leaves you with blue balls as it immediately bypasses it. (
well first book anyways, i haven't gone further than the 4th chapter due to the blueballness i got). Very disappointed here... Finished Metal Mage and it describes where apparently him and a half-elf finally opened up to having sex (and lots of it) and randomly describes how her breasts would heave as he fantasizes about her, but not have the scenes. I'm feeling Vall shouldn't be qualified so much as erotica literature personally. Or maybe he wants the first few books of each series to be SFW-ish... don't know.
Another, Larrell K Hamilton with the
Anita Blake series, first few books are combination dark horror vampire hunting. Then book 5 or something and every 3 chapters it's a huge orgy sex scene. (Yes there's a in-story reason for the sexual tension and it growing powers, but it sorta is a bait and switch).
Romance novels in general have erotica scenes, or euphemisms that are laughable. '
He touched her femininity and it felt like sparks from angels wings' comes to mind read to me by a friend.
Guess i'm saying, don't worry too hard. Unless the title suggests it's erotica, or a author that is blatantly erotica, or a publishing that's blatently erotica, then it's probably okay.