home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 2
Plugin Development
SQLiteDatabase Plugin for MP2
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="MJGraf" data-source="post: 1042340" data-attributes="member: 17886"><p>Just for refernece:</p><p></p><p>There has been some discussion and also some new test versions of SQLiteDatabase in <a href="https://forum.team-mediaportal.com/threads/sorting-order-is-not-natural.122812/" target="_blank">this thread</a> where I tried to improve the sort order of SQLite (taking into account case-insensitivity, culture sensitivity in terms of InvariantCulture, as well as natural number sorting).</p><p>These improvements make SQLiteDatabase slower - but still I'm trying to implement everything MP1 already stumbled upon - just because we have have to learn from mistakes in the past. Meaning first of all everything has to work - including sort order as the user expects it. Performance is important, but comes second...</p><p></p><p>What I would also like to mention is that in the meantime SQLiteDatabase has "grown" quite a bit in terms of lines of code. However, there are some things, that we might want to move to the MediaPortal.Utilities namespace later as they may prove useful for other parts of MP2 as well. Namely:</p><ul> <li data-xf-list-type="ul">SQLiteSettings.GetRamInMegabytes (does what the name implies)</li> <li data-xf-list-type="ul">For the sort-thingy I have implemented a "LexicographicComparer : IComparer<String>" so that we can use it for e.g. Linq as well.</li> <li data-xf-list-type="ul">And maybe also our ConnectionPool - I just have to rename it to ObjectPool. The only requirement it has is that the pooled objects implement IDisposable (and even that could be avoided by checking whether the object actually implements IDisposable as we do it in ServiceRegistration) - so no particular thing for connections...</li> </ul><p>But this is just not to forget it. There's enough time left to do this once SQLiteDatabase works with SlimTVNative and is fully integrated as standard database...</p><p></p><p>Michael</p></blockquote><p></p>
[QUOTE="MJGraf, post: 1042340, member: 17886"] Just for refernece: There has been some discussion and also some new test versions of SQLiteDatabase in [URL='https://forum.team-mediaportal.com/threads/sorting-order-is-not-natural.122812/']this thread[/URL] where I tried to improve the sort order of SQLite (taking into account case-insensitivity, culture sensitivity in terms of InvariantCulture, as well as natural number sorting). These improvements make SQLiteDatabase slower - but still I'm trying to implement everything MP1 already stumbled upon - just because we have have to learn from mistakes in the past. Meaning first of all everything has to work - including sort order as the user expects it. Performance is important, but comes second... What I would also like to mention is that in the meantime SQLiteDatabase has "grown" quite a bit in terms of lines of code. However, there are some things, that we might want to move to the MediaPortal.Utilities namespace later as they may prove useful for other parts of MP2 as well. Namely: [LIST] [*]SQLiteSettings.GetRamInMegabytes (does what the name implies) [*]For the sort-thingy I have implemented a "LexicographicComparer : IComparer<String>" so that we can use it for e.g. Linq as well. [*]And maybe also our ConnectionPool - I just have to rename it to ObjectPool. The only requirement it has is that the pooled objects implement IDisposable (and even that could be avoided by checking whether the object actually implements IDisposable as we do it in ServiceRegistration) - so no particular thing for connections... [/LIST] But this is just not to forget it. There's enough time left to do this once SQLiteDatabase works with SlimTVNative and is fully integrated as standard database... Michael [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
Plugin Development
SQLiteDatabase Plugin for MP2
Contact us
RSS
Top
Bottom