| Saturday, March 27th, 2021, 02:20 UTC | ||
| [02:20:06] | markspieth (markspieth!~yaaic@mythtv/developer/markspieth) has quit (Ping timeout: 265 seconds) | |
| [02:22:48] | markspieth (markspieth!~yaaic@mythtv/developer/markspieth) has joined #mythtv | |
| [02:22:49] | Mode for #mythtv by ChanServ!ChanServ@services. : +v markspieth | |
| [03:07:41] | markspieth2 (markspieth2!~yaaic@mythtv/developer/markspieth) has joined #mythtv | |
| [03:07:41] | Mode for #mythtv by ChanServ!ChanServ@services. : +v markspieth2 | |
| [03:08:26] | markspieth (markspieth!~yaaic@mythtv/developer/markspieth) has quit (Ping timeout: 265 seconds) | |
| [03:24:02] | amessina (amessina!~amessina@unaffiliated/amessina) has quit (Quit: Konversation terminated!) | |
| [03:28:06] | davic (davic!uid473656@gateway/web/irccloud.com/x-gbnqpoztlgdykeoq) has quit (Quit: Connection closed for inactivity) | |
| [03:31:32] | amessina (amessina!~amessina@unaffiliated/amessina) has joined #mythtv | |
| [05:08:08] | ghoti (ghoti!~paul@dynamic-64-118-29-61.wtccommunications.ca) has joined #mythtv | |
| [05:30:00] | peterbennett (peterbennett!~pi@mythtv/developer/peterbennett) has quit (Quit: WeeChat 2.3) | |
| [05:32:08] | peterbennett (peterbennett!~pi@c-75-67-203-208.hsd1.ma.comcast.net) has joined #mythtv | |
| [05:32:09] | peterbennett (peterbennett!~pi@c-75-67-203-208.hsd1.ma.comcast.net) has quit (Changing host) | |
| [05:32:09] | peterbennett (peterbennett!~pi@mythtv/developer/peterbennett) has joined #mythtv | |
| [05:32:09] | Mode for #mythtv by ChanServ!ChanServ@services. : +v peterbennett | |
| [07:30:18] | RokLobsta (RokLobsta!~Dirkka@119-17-136-18.771188.mel.static.aussiebb.net) has quit (Remote host closed the connection) | |
| [08:19:09] | Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6ea1:20d:5872:d872) has joined #mythtv | |
| [08:19:09] | Mode for #mythtv by ChanServ!ChanServ@services. : +v Steve-Goodey | |
| [11:40:39] | SteveGoodey (SteveGoodey!~steve@host86-150-63-51.range86-150.btcentralplus.com) has joined #mythtv | |
| [11:40:40] | Mode for #mythtv by ChanServ!ChanServ@services. : +v SteveGoodey | |
| [12:09:47] | Warped (Warped!~Warped@unaffiliated/warped) has quit (Quit: ChatZilla 0.9.92-rdmsoft [XULRunner 35.0.1/20150122214805]) | |
| [12:18:16] | SteveJGoodey (SteveJGoodey!~quassel@2a00:23c5:7d83:6501:2881:b76a:d50a:649) has joined #mythtv | |
| [12:18:16] | Mode for #mythtv by ChanServ!ChanServ@services. : +v SteveJGoodey | |
| [12:21:42] | SteveJGoodey (SteveJGoodey!~quassel@2a00:23c5:7d83:6501:2881:b76a:d50a:649) has quit (Read error: Connection reset by peer) | |
| [12:49:44] | Warped (Warped!~Warped@unaffiliated/warped) has joined #mythtv | |
| [14:04:16] | Warped (Warped!~Warped@unaffiliated/warped) has quit (Ping timeout: 240 seconds) | |
| [14:30:31] | Warped (Warped!~Warped@unaffiliated/warped) has joined #mythtv | |
| [15:11:48] | SteveGoodey (SteveGoodey!~steve@host86-150-63-51.range86-150.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
| [15:13:01] | SteveGoodey (SteveGoodey!~steve@host86-150-63-51.range86-150.btcentralplus.com) has joined #mythtv | |
| [15:13:02] | Mode for #mythtv by ChanServ!ChanServ@services. : +v SteveGoodey | |
| [15:22:14] | SteveGoodey (SteveGoodey!~steve@host86-150-63-51.range86-150.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
| [15:26:02] | Steve_Goodey (Steve_Goodey!~steve@2a00:23c5:7d83:6501:6ea1:20d:5872:d872) has joined #mythtv | |
| [15:26:03] | Mode for #mythtv by ChanServ!ChanServ@services. : +v Steve_Goodey | |
| [15:26:46] | Steve-Goodey (Steve-Goodey!~steve@2a00:23c5:7d83:6501:6ea1:20d:5872:d872) has quit (Ping timeout: 240 seconds) | |
| [15:41:19] | SteveGoodey (SteveGoodey!~steve@host86-149-198-205.range86-149.btcentralplus.com) has joined #mythtv | |
| [15:41:19] | Mode for #mythtv by ChanServ!ChanServ@services. : +v SteveGoodey | |
| [17:02:08] | warpme_ (warpme_!uid391875@gateway/web/irccloud.com/x-yhndbwoofywpxrtw) has quit (Quit: Connection closed for inactivity) | |
| [19:39:35] | MeFisto94 (MeFisto94!~darkchaos@HSI-KBW-091-089-167-059.hsi2.kabel-badenwuerttemberg.de) has joined #mythtv | |
| [20:07:57] | jpabq (jpabq!~quassel@mythtv/developer/jpabq) has quit (Quit: http://quassel-irc.org - Chat comfortably. Anywhere.) | |
| [20:11:01] | jpabq (jpabq!~quassel@mythtv/developer/jpabq) has joined #mythtv | |
| [20:11:01] | Mode for #mythtv by ChanServ!ChanServ@services. : +v jpabq | |
| [21:22:25] | Steve_Goodey (Steve_Goodey!~steve@2a00:23c5:7d83:6501:6ea1:20d:5872:d872) has quit (Quit: Konversation terminated!) | |
| [21:24:01] | jpabq: | Hi all. I want to add the character the actor is playing to our xmltv processing. I can add that field to either the people table or the credits table. I am thinking it would be more efficient to add it to people assuming that most of the time a season/series of recordings is being made. That would require that name/role be made into a key in the people table. Thoughts? |
| [21:27:55] | jpabq: | Another way to do it, would be to make people.name a compound field which also optionally holds the role. Something like "Mark Harmon;NCIS Special Agent Leroy Jethro Gibbs". That field is currently varchar(128) so it would probably need increased to be safe. |
| [21:37:03] | hampton: | Actor to character is not always a 1:1 mapping. Its sometime 1:n. Think Mike Myers movies, or Eddy Murphy and Arsenio Hall, or Tyler Perry. |
| [21:37:31] | jpabq: | hampton: good point! I had not though of that. |
| [21:37:58] | hampton: | Sometimes its even n:1, but not in the same episode. :-) |
| [21:38:29] | jpabq: | Right. I wonder how that shows up in the xmltv data. I assume a separate entry for each character. |
| [21:38:57] | hampton: | Don't know. That's how it would show up in the movie credits. |
| [21:39:58] | jpabq: | I have seen some movie credits where they showed it as something like "Character One / Character Two — Actor" |
| [21:40:49] | hampton: | I don't know if its up to the end titling company, or if there is some SAG rule, or ?? |
| [21:41:27] | hampton: | Of course, SAG rules would probably only apply to US/Canada productions |
| [21:44:12] | jpabq: | True. |
| [21:46:44] | jpabq: | That insight doesn't really change my question about optimal DB storage. It just points out gotcha which needs to be handled. I could still potentiall list the Actor;Role;Role;Role in the people.name field. I would just have to allow that field to be quite a bit larger. How efficient are varchar fields handled in mysql? Is it better to have a large varchar which only about 10% is used most of the time, or a second field which may be empty 1/3 of |
| [21:46:44] | jpabq: | the time? |
| [21:48:52] | jpabq: | https://www.mysqltutorial.org/mysql-varchar/ |
| [21:50:47] | jpabq: | That makes it sound like packing it into a single field is the way to go from a size perspective. The main trick will be choosing a good seperator character. I would think that a semicolon woudl be safe? Or may be colon and semicolon.... Actore:Role;Role;Role |
| [21:50:47] | hampton: | Not a database guy, but I would guess that varchar only consumes the actual space. stuarta might know but he's offline for a week. |
| [21:51:39] | hampton: | Sigh. I need to spend some time trying to get my OSX builder back online. |
| [22:04:25] | gigem: | You need a table to contain the characters. My initial, gut feeling is that should be a new table instead of overloading the existing people table. You also need a table to tie people to characters. Again, my initial, gut feel (but less so) is that should be a new table too. You could add a character column to credits but would then have to account for duplicate roles. |
| [22:18:59] | markspieth2: | what about characters like darth vader with both dvid prowse and james earl jones doing the one char |
| [22:22:06] | SteveGoodey (SteveGoodey!~steve@host86-149-198-205.range86-149.btcentralplus.com) has quit (Quit: Konversation terminated!) | |
| [22:22:23] | jpabq: | The mythconverg.credits table uses the chanid/starttime as the key. It then uses a int to lookup the actor information in the people table. Based on gigem's thoughs, there would need to be a "role" table, which has another int key tying it back to the credits table. |
| [22:50:02] | warpme_ (warpme_!uid391875@gateway/web/irccloud.com/x-dujcbnjpnloizpra) has joined #mythtv | |
| [23:01:16] | jpabq: | markspieth2: I will test to make sure we handle that situation. |
| [23:09:25] | markspieth2: | jpabq: i dont think there are many of these. ;-) |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.