+- XBMC Community Forum (http://forum.xbmc.org)
+-- Forum: Development (/forumdisplay.php?fid=32)
+--- Forum: Skin Development (/forumdisplay.php?fid=12)
+---- Forum: WIP Skins (/forumdisplay.php?fid=160)
+---- Thread: [WIP] The Paper Street Soap Company (mockups and development of a new skin concept) (/showthread.php?tid=86501)
- garyi - 2011-02-19 19:32
blacklist Wrote:Ha!
I'm trying to find a way to reduce the database bottleneck in xbmc to make up for loading this skin so full of python, etc. I already use MySQL as the database instead of sqlite that XBMC ships with. Running those SQL commands will create new index keys that result in a pretty healthy speed increase for database calls, therefore making the whole interface a bit snappier.
Make more sense now?
Well I guess, how do I change my database?
- Advocate - 2011-02-19 19:40
blacklist Wrote:1. I do find it faster.
2. Its a heck of a lot easier to deal with from a development point of view. I use a program called HeidiSQL that lets me explore tables, build querys, etc to dig into what's going on behind the scenes.
3. Its networked, so all three of my TVs use the same database.
And yes, by altering the tables and adding an index for some of the key fields, it speeds up querys. I've seen a very noticeable change in my music and movies after executing those changes.
Plus, its extra nerdy to be running a SQL server rather than a bunch of boring flat files
Blacklist I'm a bit of a MySQL n00b, can you tell me where and how I enter those commands on OS X please?
- blacklist - 2011-02-19 20:25
Advocate Wrote:Blacklist I'm a bit of a MySQL n00b, can you tell me where and how I enter those commands on OS X please?
Um, not a clue
I don't know OSX at ALL myself. MySQL has a command line fuction that allows you to directly issue querys, or you may want to see if there is a graphical mysql toold (like HeidiSQL) for OSX.
- blacklist - 2011-02-19 20:28
garyi Wrote:Well I guess, how do I change my database?
http://forum.xbmc.org/showthread.php?tid=70603&highlight=nas
That thread has all the information I used to make it happen on my machine. There are a lot of knowledgable people over there who can help you if you get stuck.
A couple words of warning:
1. This is not for everyone, there is quite a bit of configuration required to make it work properly.
2. There is no easy migration tool for your existing database, so you will most likely have to rescrape your library. To make this is easy as possible, export your library to individual files (available in XBMC settings) to make the re-scrape as easy and painless as possible.
PS. Sorry for going so far off topic, let get this back to Paper Street
(Totally my fault, I admit)
- theuni - 2011-02-19 21:08
blacklist Wrote:Ha!
I'm trying to find a way to reduce the database bottleneck in xbmc to make up for loading this skin so full of python, etc. I already use MySQL as the database instead of sqlite that XBMC ships with. Running those SQL commands will create new index keys that result in a pretty healthy speed increase for database calls, therefore making the whole interface a bit snappier.
Yikes. I'm coming into this conversation late, and admittedly breaking the rule by not reading the entire thread first, but I feel like I should chime in here. The fact that the skin is that heavy and loaded with scripts is troublesome in terms of the official repo. I really hope you're planning to submit the skin there when it's finished, it looks beautiful so far!
Looking at the download numbers, I would hope that all skinners would target our repo, it gives a massive amount of exposure.
So, could you enlighten me as to whether you are including scripts with the skin, or if you're using other scripts from the repo? I'd like to get a dialog going to avoid any confusion later.
Keep up the good work!
TheUni
- mcborzu - 2011-02-19 21:21
theuni Wrote:Yikes. I'm coming into this conversation late, and admittedly breaking the rule by not reading the entire thread first, but I feel like I should chime in here. The fact that the skin is that heavy and loaded with scripts is troublesome in terms of the official repo. I really hope you're planning to submit the skin there when it's finished, it looks beautiful so far!
Looking at the download numbers, I would hope that all skinners would target our repo, it gives a massive amount of exposure.
So, could you enlighten me as to whether you are including scripts with the skin, or if you're using other scripts from the repo? I'd like to get a dialog going to avoid any confusion later.
Keep up the good work!
TheUni
Awesome, been waiting on those stats. Might have been released via the mailing list but I've been lax on reading those...
- blacklist - 2011-02-19 21:49
theuni Wrote:Yikes. I'm coming into this conversation late, and admittedly breaking the rule by not reading the entire thread first, but I feel like I should chime in here. The fact that the skin is that heavy and loaded with scripts is troublesome in terms of the official repo. I really hope you're planning to submit the skin there when it's finished, it looks beautiful so far!
Looking at the download numbers, I would hope that all skinners would target our repo, it gives a massive amount of exposure.
So, could you enlighten me as to whether you are including scripts with the skin, or if you're using other scripts from the repo? I'd like to get a dialog going to avoid any confusion later.
Keep up the good work!
TheUni
We are making use of several existing scripts (recentlyadded, nextaired), but are adding 3 or 4 of our own (so far). We are definitly targeting the offical repo, and have made sure at each step to make sure we are using properly licensed fonts, etc. I'm afraid the sheer size of the skin may be what keeps us out, however.
As far as the scripts go, as of right now I'm planning on including the scripts with the skin.... but we're a long way off from release and have plenty of time to adjust what were doing before then.
- ppic - 2011-02-19 22:09
blaclist, my script are all designed to be on repo, i've always tink about that, i won't release it before we finish them with the skin use, but i believe theses need to be on repo because all skinners can make use of them.
@theuni:
seen or xbmc passion stats ?
here: http://passion-xbmc.org/addons/?Page=Stats
i think we save a lot of bandwith to xbmc servers with svn skins
- blacklist - 2011-02-19 22:52
ppic Wrote:blaclist, my script are all designed to be on repo, i've always tink about that, i won't release it before we finish them with the skin use, but i believe theses need to be on repo because all skinners can make use of them.
@theuni:
seen or xbmc passion stats ?
here: http://passion-xbmc.org/addons/?Page=Stats
i think we save a lot of bandwith to xbmc servers with svn skins
Oh I agree completely PPIC - I want all the scripts we have developed to be on the repo after we release. I would, however like to (selfishly) wait until we release to throw them out to everyone.
BTW I made a change locally to the actors script - at the top where we clear all the variables, we need to increase the number it clears to more like 75 or so. Did it on my local copy to fix a bug but haven't had the chance to push it to you guys yet.
And just because I can... how do we integrate that passion-xbmc swf chart thing into Paper Street?!? I TOTALLY want to be able to make pie charts of my media!!!!
(I'm totally not kidding. I'm already working on how to do it.)
- theuni - 2011-02-19 23:06
@blacklist: Great to hear we're on the same page. We do not allow scripts to be packaged with in-repo skins for a variety of reasons, so as long as you have that in mind while dev'ing, it sounds like it won't be an issue.
What's the current size? Currently the biggest in the repo is shade at 83mb zipped, I'm hesitant to go much bigger.
TheUni