Reply to thread

Message

<blockquote data-quote="Mottebelke" data-source="post: 108835" data-attributes="member: 29868">I haven't used the latest version of MediaPortal yet (with the new TV engine), so I don't know exactly where you use the SQL Express database for. I guess it is for storing channel info, etc. If it is not an overly complex database, I would like to point you guys to the new SQL Server Compact edition.SQL Compact is a new and free database system introduced by Microsoft. It is aimed at desktop applications which need to use a lightweight and single-user database for the storage of their data. More info can be found here: <a href="http://www.microsoft.com/sql/editions/compact/default.mspx" target="_blank">http://www.microsoft.com/sql/editions/compact/default.mspx</a>What would be the advantages for MediaPortal by using the Compact db instead of the Express one:<ul>
<li data-xf-list-type="ul">It is lightweight which means less system memory is being used</li>
<li data-xf-list-type="ul">It can be embedded in the MediaPortal installer, which means less installation hassle for the end-user</li>
<li data-xf-list-type="ul">It won't take too much work to change the existing db code over to the new Compact db, as most ADO.NET functions are fully supported</li>
</ul>Anyway, I just wanted to let you guys know that this available and to me it seems like a very interesting option for MediaPortal.</blockquote>

[QUOTE="Mottebelke, post: 108835, member: 29868"] I haven't used the latest version of MediaPortal yet (with the new TV engine), so I don't know exactly where you use the SQL Express database for. I guess it is for storing channel info, etc. If it is not an overly complex database, I would like to point you guys to the new SQL Server Compact edition. SQL Compact is a new and free database system introduced by Microsoft. It is aimed at desktop applications which need to use a lightweight and single-user database for the storage of their data. More info can be found here: [url]http://www.microsoft.com/sql/editions/compact/default.mspx[/url] What would be the advantages for MediaPortal by using the Compact db instead of the Express one: [LIST] [*]It is lightweight which means less system memory is being used [*]It can be embedded in the MediaPortal installer, which means less installation hassle for the end-user [*]It won't take too much work to change the existing db code over to the new Compact db, as most ADO.NET functions are fully supported [/LIST] Anyway, I just wanted to let you guys know that this available and to me it seems like a very interesting option for MediaPortal. [/QUOTE]

Verification