2025-01-13, 12:56 AM
It's not a good idea to modify a sqlite database out from under the application. You may want to look into the Jellyfin API to see if what you're doing is possible.
It looks like you could query on people.name to find all the ItemIds that a person appears in, joining people.itemid to eg TypedBasedItems.guid:
> select tbi.path, p.name from TypedBaseItems tbi, People p where p.itemid=tbi.guid and p.name='Patrick Stewart'
It looks like you could query on people.name to find all the ItemIds that a person appears in, joining people.itemid to eg TypedBasedItems.guid:
> select tbi.path, p.name from TypedBaseItems tbi, People p where p.itemid=tbi.guid and p.name='Patrick Stewart'