Reply to thread

Message

<blockquote data-quote="morpheus_xx" data-source="post: 744446" data-attributes="member: 48495">AW: MP2 Media Database ConceptHi,first I like your idea and am lucky that you want to do it in MP2 <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />Some facts about the MediaLibrary:<ul>
<li data-xf-list-type="ul">It's a SQL embedded DB, you can access and browse it with a common MS SQL Management studio</li>
<li data-xf-list-type="ul">Information about MediaItems (audio, video, pictures) are stored in so called MediaAspects, one for video details, audio details a.s.o.</li>
<li data-xf-list-type="ul">The information are filled by so called &quot;MetadataExtractors&quot; during:<ul>
<li data-xf-list-type="ul">browsing local media navigation (not attached to server)</li>
<li data-xf-list-type="ul">running a importer job by the server that fills the MediaLibrary</li>
</ul></li>
<li data-xf-list-type="ul">You do not need to deal directly with the database when you use and extend this technology.</li>
<li data-xf-list-type="ul">You can add more MetadataExtractors that fill MediaAspects, when they are registered, they will be called during import.</li>
<li data-xf-list-type="ul">You could extend existing PictureAspect to hold more attributes, or better: create a new &quot;PicasaPictureAspect&quot; that will be internally persisted as a new database table (MediaLibrary takes care for this!)</li>
</ul>I recently added thumbnails to the MediaAspect (let's call it master data of any MediaItem), look at this commit: <a href="https://github.com/MediaPortal/MediaPortal-2/commit/516b997c4f17d142c39dd8cf1f07eb47eff437b4" target="_blank">https://github.com/MediaPortal/MediaPortal-2/commit/516b997c4f17d142c39dd8cf1f07eb47eff437b4</a>So when you plan you plugin check the MetadataExtractors and the MediaAspects first!Morpheus</blockquote>

[QUOTE="morpheus_xx, post: 744446, member: 48495"] [b]AW: MP2 Media Database Concept[/b] Hi, first I like your idea and am lucky that you want to do it in MP2 :) Some facts about the MediaLibrary: [LIST] [*]It's a SQL embedded DB, you can access and browse it with a common MS SQL Management studio [*]Information about MediaItems (audio, video, pictures) are stored in so called MediaAspects, one for video details, audio details a.s.o. [*]The information are filled by so called "MetadataExtractors" during: [LIST][*]browsing local media navigation (not attached to server) [*]running a importer job by the server that fills the MediaLibrary [/LIST] [*]You do not need to deal directly with the database when you use and extend this technology. [*]You can add more MetadataExtractors that fill MediaAspects, when they are registered, they will be called during import. [*]You could extend existing PictureAspect to hold more attributes, or better: create a new "PicasaPictureAspect" that will be internally persisted as a new database table (MediaLibrary takes care for this!) [/LIST] I recently added thumbnails to the MediaAspect (let's call it master data of any MediaItem), look at this commit: [url]https://github.com/MediaPortal/MediaPortal-2/commit/516b997c4f17d142c39dd8cf1f07eb47eff437b4[/url] So when you plan you plugin check the MetadataExtractors and the MediaAspects first! Morpheus [/QUOTE]

Verification