{"id":632,"date":"2008-07-08T14:02:48","date_gmt":"2008-07-08T03:02:48","guid":{"rendered":"http:\/\/hifi-writer.com\/wpblog\/?p=632"},"modified":"2010-02-11T22:32:05","modified_gmt":"2010-02-11T11:32:05","slug":"disc-database","status":"publish","type":"post","link":"http:\/\/hifi-writer.com\/wpblog\/?p=632","title":{"rendered":"Disc Database"},"content":{"rendered":"<p>One of the things I&#8217;ve been doing since not long after the introduction of the DVD has been building a database in Microsoft Access of details relating to discs. I&#8217;ve added additional fields over the years to allow for bits and pieces of additional data in which I&#8217;ve become interested. That includes HD DVDs and Blu-ray discs.<\/p>\n<p>This database is far from complete, with some records consisting of little more than a title and a year. For many of the discs, the records are quite detailed. For example, consider the Australian Blu-ray release of &#8216;<a href=\"http:\/\/www.imdb.com\/title\/tt0489099\/\">Jumper<\/a>&#8216;. The items in my database for this title include:<\/p>\n<ul>\n<li><strong>Title:<\/strong> Jumper<\/li>\n<li><strong>Year:<\/strong> 2008<\/li>\n<li><strong>Rating:<\/strong> M<\/li>\n<li><strong>IMDB rating:<\/strong> 5.9 as at 3 July 2008<\/li>\n<li><strong>Duration:<\/strong> 88<\/li>\n<li><strong>Claimed Duration:<\/strong> (slick not available)<\/li>\n<li><strong>Distributor:<\/strong> Twentieth Century Fox Home Entertainment South Pacific Pty Ltd<\/li>\n<li><strong>Mastering:<\/strong> Deluxe Digital Studios<\/li>\n<li><strong>Aquisition date:<\/strong> June 2008<\/li>\n<li><strong>Number of discs:<\/strong> 1<\/li>\n<li><strong>Layers:<\/strong> Dual<\/li>\n<li><strong>Disc size:<\/strong> 38.90<\/li>\n<li><strong>Remarks: <\/strong>Review copy, BonusView, Region B<\/li>\n<li><strong>Genre:<\/strong> Action, Adventure, SF, Thriller<\/li>\n<li><strong>Picture:<\/strong> Widescreen anamorphic, 2.35:1, 1808p24, MPEG4 AVC<\/li>\n<li><strong>Audio:<\/strong> individual record for each audio track, eg. English (Audio descriptive), Dolby Digital, 448kbps, 3\/2.1<\/li>\n<li><strong>Titles:<\/strong> individual record for each title, eg. Disc Number 1, Side A, Title 3, Number of Chapters 25, Time 88:21, Skip Chapter Yes, Content Movie, Interlaced No<\/li>\n<li><strong>Subtitles:<\/strong> English for the Hearing Impaired, Italian, Italian (Text), Spanish, Spanish (Text), Danish, Finnish, Norwegian, Swedish, English (Commentary), German (Commentary), Finnish (Commentary), Norwegian (Commentary), Swedish (Commentary)<\/li>\n<li><strong>Other features:<\/strong> &#8216;Jumping Around the World&#8217; PIP feature; &#8216;Jumping Around the World&#8217; non-PIP feature; D-Box Motion Code; Animated Graphic Novel: &#8216;Jumpstart: Jumper&#8217;s Story&#8217; (8 mins &#8211; HD); Making-of featurette: &#8216;Doug Liman&#8217;s &#8220;Jumper&#8221; Uncensored&#8217; (36 mins &#8211; HD); Featurette: &#8216;Making an Actor Jump&#8217; (8 mins &#8211; HD); Featurette: &#8216;Jumping from Novel to Film: The Past, Present and Future of Jumper&#8217; (8 mins &#8211; HD); Six Deleted Scenes (11 mins &#8211; HD); Animation: &#8216;Previz &#8211; Future Concepts&#8217; (5 mins &#8211; HD)<\/li>\n<\/ul>\n<p>I would be happy to make this data available on line for the 1,200+ DVDs, 100+ Blu-ray discs and 70+ HD DVDs I have indexed, but I&#8217;m not prepared to put the time into learning how to make an online searchable database. If any readers can do this, I&#8217;d be prepared to provide the data and host the database. Remember, the Access database uses its relational features, although often in a half-arsed unprofessional way (I did it myself).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>One of the things I&#8217;ve been doing since not long after the introduction of the DVD has been building a database in Microsoft Access of details relating to discs. I&#8217;ve added additional fields over the years to allow for bits &hellip; <a href=\"http:\/\/hifi-writer.com\/wpblog\/?p=632\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7,3,16,8,13],"tags":[],"_links":{"self":[{"href":"http:\/\/hifi-writer.com\/wpblog\/index.php?rest_route=\/wp\/v2\/posts\/632"}],"collection":[{"href":"http:\/\/hifi-writer.com\/wpblog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/hifi-writer.com\/wpblog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/hifi-writer.com\/wpblog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/hifi-writer.com\/wpblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=632"}],"version-history":[{"count":2,"href":"http:\/\/hifi-writer.com\/wpblog\/index.php?rest_route=\/wp\/v2\/posts\/632\/revisions"}],"predecessor-version":[{"id":634,"href":"http:\/\/hifi-writer.com\/wpblog\/index.php?rest_route=\/wp\/v2\/posts\/632\/revisions\/634"}],"wp:attachment":[{"href":"http:\/\/hifi-writer.com\/wpblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=632"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/hifi-writer.com\/wpblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=632"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/hifi-writer.com\/wpblog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=632"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}