Library Management: various questions not worth their own thread

[7hir7een]

Also, I'd like to trim down long kindle book titles that often have the series name and the genre in the title.

Is there any way to search for titles that are, say, over 100 characters?

[Comfy.n]

Originally Posted by 7hir7een

Also, I'd like to trim down long kindle book titles that often have the series name and the genre in the title.

Is there any way to search for titles that are, say, over 100 characters?

title:"~^.{100}"

that's based on a search @chaley gave us to search for very large comments

[ownedbycats]

Originally Posted by 7hir7een

Also, I'd like to trim down long kindle book titles that often have the series name and the genre in the title.

Is there any way to search for titles that are, say, over 100 characters?

template:"""program: strlen($title)#@#:n:>=100"""

[ownedbycats]

"Quotations" are auto-removed in title sort. not other punctuation like (parentheses) or ...ellipses. (Fanfic titles tend to go more stylistic). Is there a tweak for this? per_language_title_sort_articles doesn't seem suitable.

[ownedbycats]

I want to display a column icon when there's data files in the book. There's two ways I can see to do this:

1. Create a rule for program: extra_file_names(',') with any value. High-impact.

2. Update a noncomposite column (either #admintags or a new #extrafiles) and use Action Chains to update it. Less impact, but without a way (that I know of) to auto-update it when adding a file (which means forgetting).

Is extra_file_names() very slow, or is there a better option?

[chaley]

Originally Posted by ownedbycats

I want to display a column icon when there's data files in the book. There's two ways I can see to do this:

1. Create a rule for program: extra_file_names(',') with any value. High-impact.

2. Update a noncomposite column (either #admintags or a new #extrafiles) and use Action Chains to update it. Less impact, but without a way (that I know of) to auto-update it when adding a file (which means forgetting).

Is extra_file_names() very slow, or is there a better option?

Other than a python template, extra_file_names() is the only way to determine that something is in the data directory. That function must read the disk to make the determination, so yes, it will not be fast. Whether it is fast enough only you can know. I suspect it will be acceptable because it will only run when the book is visible in the booklist and the answer to extra_file_names() is cached.

As for the action chains, perhaps you can partially solve the problem by running the chain when calibre starts or stops. You might also be able to convince Kovid to add an event to the methods in cache.py that modify the data directory.

[BetterRed]

I use the extra_data_files function to show a folder icon:

program:
	if has_extra_files()
		then 'folder.png'
	else
		'transparent_square.png'
	fi

I have a library of 8,473 books, 2,951 (~35%) books have non-empty 'data' folders (there are probably a few hundred empty ones, I don't bother removing empty data folders). The library is on a 7,200 rpm SATA III (6.0Gb/s) HDD.

Because it's a wet cold Sunday morning, I removed the rule. I cannot discern any noticeable difference when hitting page down on the book list (48 lines per page), it is more or less instantaneous with or without the 'has_extra_files' column icon rule.

BR