• 1
  • 10
  • 11
  • 12
  • 13(current)
  • 14
[RFC] Database Abstraction Proposal - Request for Comments (Devs and DB Admins only!)
@joemorin73
Yes i do.

I searched the fields for the thumbs and fanart but no luck.

How can i retrieve this informations?
Thx
Reply
I'll have to look into the DB. Unfortunately, I will have to look at it a little later. I believe the db only contains a link to the set FanArt and Thumbs that are stored locally. I can not recall which fields.
Reply
Hello joemorin73

If i query XBMC via JSON-RPC i get in my case for e.g. the movie 'Alice in Wonderland'
the thumb link 'special://masterprofile/Thumbnails/Video/babe3dda.tbn' and for the fanart 'special://masterprofile/Thumbnails/Video/Fanart/babe3dda.tbn'

If i query the mysql database for the movie i only find field c08,c20 from the table movie. In this fields there are the links to themoviedb.org but not the links to the local stored files.

My goal is not to use JSON-RPC for query. I want to use the mysql because JSON-RPC misses some info i want to query. e.g. actors,movie resolution etc.

So how can i get the links to the local stored files? The interesting part of the link is /Video/Fanart/babe3dda.tbn.

Do i have to calculate from checksum or is it not possible to get these links from the database?
Reply
_Andy_ Wrote:Do i have to calculate from checksum or is it not possible to get these links from the database?

Unfortunately it is not possible, there is no local thumb path information in the database. JSON pulls it from internal strutcures and ultimately via GetCachedFanart() or GetThumbnailImage() depending on your request for fanart or thumbnail respectively.
Always read the XBMC online-manual, FAQ, Wiki and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.
Reply
Not sure if this is the right place, but it seems to me this were the main topic regarding MySQL support in XBMC.

After reading this[1], I wondered why it only accepted latin1 charset, and nut utf-8. Is this something that has been fixed? Or are we stuck with latin1?

[1] http://j.mp/gSqkAF
Reply
meh, just seen the paragraph about the column names and I renamed nearly all pvr related columns a couple of days ago, not according to those rules ofcourse...

too bad for all those "bleeding edge" users who just recreated their channels list Smile

I'll add diagrams for the pvr part when I'm done with all the changes.
opdenkamp / dushmaniac

xbmc-pvr [Eden-PVR builds] [now included in mainline XBMC, so no more source link here :)]
personal website: [link]

Found a problem with PVR? Report it on Trac, under "PVR - core components". Please attach the full debug log.

If you like my work, please consider donating to me and/or Team XBMC.
Reply
I've looked through the schema and I don't see a date entry for when the file was added to the library. Is this something that can be added? If I missed it, can someone point me to it?
Reply
Question 
I posted this in this other thread first http://forum.xbmc.org/showthread.php?tid=73831 but maybe here is the corrent place for it?

Regarding a database schema for music and music-videos, why not just start by using MusicBrainz's newly released NGS (Next Generation Schema) as is?

http://wiki.musicbrainz.org/Next_Generation_Schema

MusicBrainz Next Generation Schema (NGS) has been announced as a complete re-write of MusicBrainz database schema model and it was just announced a couple of weeks ago.

http://wiki.musicbrainz.org/?title=Serve...s/20110516

"MusicBrainz Next Generation Schema (NGS) is the culmination of five years of planning and two years of active development".

Also checkout MusicBrainz for music data mining in general because it contains loads of cool release meta data information like advanced relationship and much more.

http://musicbrainz.org/doc/Advanced_Relationship
http://wiki.musicbrainz.org/Release
http://wiki.musicbrainz.org/Release_Format
http://wiki.musicbrainz.org/Release_Event

http://musicbrainz.org/doc/MusicBrainz_Database

I read most of this stuff about their NGS on MusicBrainz blog.

http://blog.musicbrainz.org/

Bonus with reusing the MusicBrainz's NGS is that their professionals will keep that database schema up to date and fix bugs in it Smile

http://tickets.musicbrainz.org/browse/MBS
http://bugs.musicbrainz.org


Sorry if this was a dumb suggestion or if you are only looking at creating a database schema for handling videos. I am most curious if you will consider music and other pure audio files when you implement your new database schema for XBMC, so wondering what the status on this is today?
Reply
Thanks for the information.

The Database schema has been put on hold to focus on the design of the internal data structures that would ultimately be stored by the design.

It will be these data structures that inform the schema design.
Always read the XBMC online-manual, FAQ, Wiki and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.
Reply
firnsy Wrote:Thanks for the information.

The Database schema has been put on hold to focus on the design of the internal data structures that would ultimately be stored by the design.

It will be these data structures that inform the schema design.

Ideally database-related structures should be hidden behind a wall, and on the "XBMC side" are existing XBMC structures (movies, artists, etc.), which it can lookup and store using an API that is not database, or even terribly database design specific. There need be no lock in to EAV/CR or not, for example; the database interfaces could be implemented that way, or not.
Reply
dbrobins Wrote:Ideally database-related structures should be hidden behind a wall, and on the "XBMC side" are existing XBMC structures (movies, artists, etc.), which it can lookup and store using an API that is not database, or even terribly database design specific. There need be no lock in to EAV/CR or not, for example; the database interfaces could be implemented that way, or not.

Indeed the data need not be store in a database at all. It could be served up by XML, UPnP or whatever.

My intent is to introduce a intermediary layer before the presentation that allows the fusing of multiple backend sources - local or remote.
Always read the XBMC online-manual, FAQ, Wiki and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.
Reply
firnsy Wrote:My intent is to introduce a intermediary layer before the presentation that allows the fusing of multiple backend sources - local or remote.

What can I do to help?
Reply
This is exactly the feature that I've been hoping for. I've four systems at my home.

Please, let's implement this. I'm postgresql user, will to help if needed.
Reply
just out of curiosity do you think this setup could be bundled into the xbmcbuntu package so that each new install come with a potential sql server to enable the host or share amongst computers?
Reply
If it will ever make it into XBMC it will most likely also be available in XBMCbuntu because XBMCbuntu does not really modify how XBMC itself works.
Always read the online manual (wiki), FAQ (wiki) and search the forum before posting.
Do not e-mail Team Kodi members directly asking for support. Read/follow the forum rules (wiki).
Please read the pages on troubleshooting (wiki) and bug reporting (wiki) before reporting issues.
Reply
  • 1
  • 10
  • 11
  • 12
  • 13(current)
  • 14

Logout Mark Read Team Forum Stats Members Help
[RFC] Database Abstraction Proposal - Request for Comments (Devs and DB Admins only!)0