• Login
  • Register
  • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below
  • Forum
  • Website
  • GitHub
  • Status
  • Translation
  • Features
  • Team
  • Rules
  • Help
  • Feeds
User Links
  • Login
  • Register
  • Login Register
    Login
    Username/Email:
    Password:
    Or login with a social network below

    Useful Links Forum Website GitHub Status Translation Features Team Rules Help Feeds
    Jellyfin Forum Development Server Development How does the library.db understand relationships between actors and movies?

     
    • 0 Vote(s) - 0 Average

    How does the library.db understand relationships between actors and movies?

    ickyfehmleh
    Offline

    Junior Member

    Posts: 10
    Threads: 1
    Joined: 2023 Jul
    Reputation: 0
    Country:United States
    #2
    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'
    « Next Oldest | Next Newest »

    Users browsing this thread: 1 Guest(s)


    Messages In This Thread
    How does the library.db understand relationships between actors and movies? - by Kevin Blansit - 2023-12-23, 05:18 AM
    RE: How does the library.db understand relationships between actors and movies? - by ickyfehmleh - 2025-01-13, 12:56 AM
    RE: How does the library.db understand relationships between actors and movies? - by Venson - 2025-01-13, 07:01 AM

    • View a Printable Version
    • Subscribe to this thread
    Forum Jump:

    Home · Team · Help · Contact
    © Designed by D&D - Powered by MyBB
    L


    Jellyfin

    The Free Software Media System

    Linear Mode
    Threaded Mode