View Single Post
Old 03-25-2023, 09:35 AM   #29
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,476
Karma: 8025702
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by BetterRed View Post
Would that mean every item listed in the Manage categories tool would have a link field similar to Authors, viz?
Yes
Quote:
I thought adding columns to calibre's database tables was off-limits because of the potential impact on the databases in the wild.
As Kovid mentioned, there have been many. With my change we are up to version 26.

There are always risks when changing the schema because reverting to a previous calibre release (before the change) might not work. I don't think this change will do that, but it might.

In addition, anyone who reads the upgraded tables using SELECT * expecting to get the old number of values will have problems. As I said when I taught a database course way-back-when, don't do that. Always select only the columns you need.
chaley is offline   Reply With Quote