[RFC] Database Abstraction Proposal - Request for Comments (Devs and DB Admins only!)

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
_Andy_ Offline
Senior Member
Posts: 260
Joined: May 2010
Reputation: 6
Location: Germany, Milky Way Galaxy
Post: #181
@joemorin73
Yes i do.

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

How can i retrieve this informations?
Thx
find quote
joemorin73 Offline
Junior Member
Posts: 7
Joined: Nov 2010
Reputation: 0
Post: #182
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.
find quote
_Andy_ Offline
Senior Member
Posts: 260
Joined: May 2010
Reputation: 6
Location: Germany, Milky Way Galaxy
Post: #183
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?
find quote
firnsy Offline
Team-XBMC Developer
Posts: 104
Joined: Jul 2009
Reputation: 0
Location: Australia
Post: #184
_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.
find quote
MindTooth Offline
Senior Member
Posts: 158
Joined: Feb 2010
Reputation: 0
Post: #185
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
(This post was last modified: 2011-01-05 01:42 by MindTooth.)
find quote
opdenkamp Offline
Team-XBMC PVR Developer
Posts: 2,224
Joined: Feb 2009
Reputation: 29
Location: Heerlen, The Netherlands
Post: #186
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.
find quote
opensauce Offline
Member
Posts: 64
Joined: Jan 2010
Reputation: 0
Post: #187
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?
find quote
RockerC Offline
Fan
Posts: 347
Joined: May 2011
Reputation: 4
Question  MusicBrainz Database Schema for music?
Post: #188
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?
find quote
firnsy Offline
Team-XBMC Developer
Posts: 104
Joined: Jul 2009
Reputation: 0
Location: Australia
Post: #189
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.
find quote
dbrobins Offline
Member
Posts: 73
Joined: Dec 2009
Reputation: 0
Location: Redmond, WA
Post: #190
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.
find quote
firnsy Offline
Team-XBMC Developer
Posts: 104
Joined: Jul 2009
Reputation: 0
Location: Australia
Post: #191
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.
find quote
griffore Offline
Member
Posts: 75
Joined: Oct 2007
Reputation: 0
Location: Ontario, Canada
Post: #192
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?
find quote
Tuju Offline
Junior Member
Posts: 3
Joined: Jan 2012
Reputation: 0
Post: #193
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.
find quote
kinnth Offline
Junior Member
Posts: 3
Joined: Mar 2011
Reputation: 0
Post: #194
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?
find quote
Montellese Offline
Team-XBMC Developer
Posts: 3,753
Joined: Jan 2009
Reputation: 36
Location: Switzerland
Post: #195
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 XBMC online-manual, FAQ 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.

[Image: badge.gif]
find quote
Post Reply