2012-02-27, 23:15
Hello, XBMC'ers. I'm a newbie here and want to take a crack at writing a plugin or two.
After opening my Videos database with a SQLite browser, I noticed a lot of non-normalized fields, especially in the "movie" table. For example, why does column "c14" contain genre information when there's a separate genre table (and the corresponding join table)? Likewise, "c18" has a string for the studio, but there's also a "studio" table.
Is there a reason for this? Some kind of backwards compatibility? Performance? Or just years of accumulated cruft?
Am I correct to assume that my future plugin should query this data the "right way" - by use of the join tables?
(Disclaimer: I may be a newbie when it comes to playing with XBMC, but I've been a web & database developer for what feels like forever. I wonder where I put my merit badge for coding Perl .cgi scripts in Notepad? )
-Dito
After opening my Videos database with a SQLite browser, I noticed a lot of non-normalized fields, especially in the "movie" table. For example, why does column "c14" contain genre information when there's a separate genre table (and the corresponding join table)? Likewise, "c18" has a string for the studio, but there's also a "studio" table.
Is there a reason for this? Some kind of backwards compatibility? Performance? Or just years of accumulated cruft?
Am I correct to assume that my future plugin should query this data the "right way" - by use of the join tables?
(Disclaimer: I may be a newbie when it comes to playing with XBMC, but I've been a web & database developer for what feels like forever. I wonder where I put my merit badge for coding Perl .cgi scripts in Notepad? )
-Dito