Implementing Multiple Video Databases?

[brownbug]

I'm sorry if this is in the incorrect area, I just can't really place where it might go. and I am realy sorry for my english, I am from Hungary

The problem is the folowing.

in my Movies I want to make several databases such as Films Documentary Concert Cartoon etc, and I cant figure it out how to make it.

I know xml and c++ but did not find a clue for this problem.
Thanks for the help

[Waffa]

You need to use the library. Then use Media Companion (http://www.billyad2000.co.uk/).
This program does scrape .nfo, .tbn, folder.jpg and fanart.jpg files.
You can change what you want, for example genre : Documentary Concert Cartoon.
Try this program out.

[brownbug]

Thanks will try it. and write back

You need to use the library. Then use Media Companion (http://www.billyad2000.co.uk/).
This program does scrape .nfo, .tbn, folder.jpg and fanart.jpg files.
You can change what you want, for example genre : Documentary Concert Cartoon.
Try this program out.

[brownbug]

thanks again for your reply but you did not understand my problem eather I did not specified it well.
I need 5 separate databases, When I enter the movies section in the xbmc I want to make the choise between the 5 or six categories(movie tipes Cartoon Documentary and so on).

whith your soulution i have all my movies in one big database, and I can search for it by making my selection in the categories first than by name or actor so on.

Think about it if you want to search for a movie with the elephant whitin the movies name, you get all documentury and films.

I hope you understand me.

Waitin for your reply thanks

[Waffa]

thanks again for your reply but you did not understand my problem eather I did not specified it well.
I need 5 separate databases, When I enter the movies section in the xbmc I want to make the choise between the 5 or six categories(movie tipes Cartoon Documentary and so on).

whith your soulution i have all my movies in one big database, and I can search for it by making my selection in the categories first than by name or actor so on.


Or Genre.
Just ad your personal genretype with the genres in Media Companion.
Select in XBMC the genre you want to see.


Think about it if you want to search for a movie with the elephant whitin the movies name, you get all documentury and films.

I hope you understand me.

Waitin for your reply thanks

You can always search for a movie. See context menu.:grin:

[Gamester17]

XBMC currently only have one video database (SQL) and that is only used for Movies, TV Shows, and Music Videos. XBMC does not currently have database/library support for Cartoons and Documentaries, etc.

If you want thas (or something similar with all different videos in one database which would make much more sence) then yes you would have to code it yourself in C++, XML, and learn a little about SQL databases.

See all these feature request and discussions for more information about this topic:
http://xbmc.org/forum/showthread.php?t=37206
http://xbmc.org/forum/showthread.php?t=12721
http://xbmc.org/forum/showthread.php?t=33710
http://xbmc.org/forum/showthread.php?t=30161
http://xbmc.org/forum/showthread.php?t=37449

A lot to read, I know but at least you are not the only one who wants this :;):

[brownbug]

Thanks for your reply.

The problem with on big thatabase whit al my movies is that when i want to update the database itt will search for an hour, I have a 40 Tb server on my network and 10.000 films + series and documentury and so on. I used medio before.

[sho]

Currently to have separate databases you need separate profiles:
http://xbmc.org/wiki/?title=Profiles

I think someone just wrote a script that switches between profiles.

[brownbug]

Hope that someone will try to make separate databases soon wwhithin a single profile. I will try to mak it my self. Who knows maybee I sucsees.

[sho]

Thanks for your reply.

The problem with on big thatabase whit al my movies is that when i want to update the database itt will search for an hour, I have a 40 Tb server on my network and 10.000 films + series and documentury and so on. I used medio before.
There are outstanding feature requests to achieve what you want w/o going to separate databases (which judging by previous dev comments is not going to happen):

http://xbmc.org/trac/ticket/5397
http://xbmc.org/trac/ticket/4969

[Gamester17]

Using separate databases for videos in one profile would mean XBMC would loose the cross-reference features so I am personally against it.
* Cross-reference Movies with TV Shows (for example Stargate, X-Files, Blade, etc.)
* Cross-reference actors that are in both Movies, TV Shows, and Music Videos, etc.

The problem with on big thatabase whit al my movies is that when i want to update the database itt will search for an hour, I have a 40 Tb server on my network and 10.000 films + series and documentury and so on. I used medio before.Unfortunately I think you today are in a minority there, and one of the XBMC project's coding guidelines is to apply the law of diminishing return, meaning rhe majority of the effort should be invested in implementing features which have the most benefit and widest general usage by the community.

I think your time would then instead be better spent on optimizing database update and handling in XBMC to make it faster, or even make XBMC use other SQL backend. See for example: http://xbmc.org/forum/showthread.php?t=37449

My 2 cents

[spiff]

i have only seen one sensible solution to this issue and that is the ability to flag paths as autoupdates or not. having separate db's is silly.

sql backend is also totally unrelated

[sho]

That's actually a very good idea.. so what's the ETA? :)

[spiff]

i was already working on it. r16862

you clean the trac please

[brownbug]

I dont see why that will not going to happen if there exist not one, more then 5 requests for this.

I am at 50% procent whit it, and Will finalize it soon, just need more time.
Just time is my problem.
Thanks for your post.

[spiff]

because it will mess up the code for no good reason.

afaict you want to adresse two issues;

1) updates takes forever - this you can now handle
2) you want searches to be more narrow. this should be handled that way - by narrowing searches.

i think what you are really after is another content type for documentaries. this is something that is most welcome.

[brownbug]

content type thats the right word for it. and when I search that conten ex documentary, dont want to se die hard 4 in it

[spiff]

yeah, precisely.

this should be handled just like we handle the other content types today, currently movies, tvshows, musicvideos. there is no reason to switch db file. i'll gladly give you some pointers if you want.

[Gamester17]

Yes, and again additional content types is also being requested/discussed in these threads:
http://xbmc.org/forum/showthread.php?t=33710
http://xbmc.org/forum/showthread.php?t=37206
http://xbmc.org/forum/showthread.php?t=12721
These tree threads are all related and kind of dependent on the different ideas in them :;):

I suggest you try to catch spiff and jmarshall on IRC (#xbmc on freenode), see:
http://xbmc.org/wiki/?title=Appendix_D:_Development_Notes#Contact_metho ds
http://xbmc.org/wiki/?title=Appendix_D:_Development_Notes

Happy coding!