EPG (TV-Guide) data-store code development discussion for the unified PVR front-end

I've not kept this thread up to date, but anyone watching the wiki page will have noticed that my application is written and was submitted on 30/03/08

Since then I've had to concentrate on uni work - 3 projects nearing completion deadline - and getting my head around the qualificiation task.

I've downloaded sqlitespy, and am currently creating a database to test transaction speed with large data sets. I'll need to read up on db design before I can take much from these trials, anyone with more experience in this please voice your thoughts on this.

Is there any news on development of this?

dubstar_04 Wrote:Is there any news on development of this?

I second this... Is there any update on development?

Is this project still underdevelopment?

Yes, I should leave more status updates here, otherwise the moss sets in, people start worrying

sqlite stuff: there's code in my subversion branch that is the basis for CTVDatabase - the class that handles all access to the sqlite file we need to store all the schedule data. As it is I can fill it and retrieve the listings back channel by channel. Of course we need more access methods, such as searching functions, filtering by field etc. Speed wise, it's a painful process:

Quote:m_database.GetDataEnd() took 828 ms to return
m_database.GetChannels() took 15 ms to return
CGUIWindowEPG::GetGridData returned 860 items in 1836 ms (2 days of 35 channels)
CGUIEPGGridContainer::UpdateItems completed successfully in 172 ms

GetDataEnd is a stupid method I use to find out what date the data runs out in the db. It will need to be replaced by a static value stored somewhere, so that can be ignored; nearly 2 seconds to get 860 items is pretty shocking however. Improvement needed here as this is performed each time you flick to the TV guide window. I know it's possible to cache this data and/or improve the query and design of the db.

GUI TV guide: There's code in svn for a window (CGUIWindowEPG) that retrieves 2 days of data as a 2d vector of FileItems, builds a grid of GUIListItems and which can be navigated reasonably well. This has been a really tough thing to get working, tough because I've made mistakes, have been improving and reshaping a lot of code, and primarily because I came to this with a very limited understanding of XBMC's GUIlib. (I wouldn't recommend my approach for time limited projects..) There are some nice things in it, such as semi-intelligent navigation, proper horizontal scrolling rather than page flipping; the basis of a reasonably sophisticated container class. It's needless to say, there's a lot more to do, and challenges are ahead - but I'm still enjoying myself

Just wanted to pop in and say thank you and good luck with the project... we're all very excited to see development on this front (at least I am :nod

rwparris2 Wrote:Just wanted to pop in and say thank you and good luck with the project... we're all very excited to see development on this front (at least I am :nod

I second this. I check the forums every day to see if there is any progress with your project.

I would also like to say thank you for all you effort and i sincerely hope that you gain everything from the project / experience that you wish for.

Would you be able to post any screenshots of progress and you go?

Many thanks,

Dubstar_04

in case you miss it there's a screenshot and some info on the skinning aspects in the Skinning Forum - http://forum.xbmc.org/showthread.php?p=2...post205811

WOW!!

Its so great to see that you have made so much progress!!

Keep it coming!!

I think this will become a very important project for XBMC. We all know XBMC is simply the best mediacenter around, but in this particular area it was clearly behind others. With this it will surely catch up in just about the last area it had any catching up to do
Keep it up