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

**firnsy** · 2011-06-28 11:54

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.

griffore · 2011-10-13 02:50

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?

Tuju · 2012-01-14 15:15

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.

kinnth · 2012-02-24 03:43

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?

**Montellese** · 2012-02-24 10:03

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.

Thracx · 2012-03-27 22:57

(2011-06-27 13:53)firnsy Wrote: 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.

Now that Eden is out the door, perhaps work can resume / be renewed on this DB schema rewrite? Any updates, firmsy?

paradix · 2012-11-22 12:22

I have been looking into the database schema lately and was a little surprised about its construction.
Is firnsy's work available somewhere?

**Montellese** · 2012-11-22 12:43

(2012-11-22 12:22)paradix Wrote: I have been looking into the database schema lately and was a little surprised about its construction.

It's called legacy Wink

**DonJ** · 2012-11-22 17:30

(2012-11-22 12:22)paradix Wrote: Is firnsy's work available somewhere?

Check the wiki: http://wiki.xbmc.org/index.php?title=Dat...hema_4.0/a

griffore Member Posts: 70 Joined: Oct 2007 Reputation: 0 Location: Ontario, Canada	2011-10-13 02:50 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 Junior Member Posts: 3 Joined: Jan 2012 Reputation: 0	2012-01-14 15:15 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 Junior Member Posts: 2 Joined: Mar 2011 Reputation: 0	2012-02-24 03:43 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

paradix Senior Member Posts: 116 Joined: Sep 2011 Reputation: 6	2012-11-22 12:22 Post: #197 I have been looking into the database schema lately and was a little surprised about its construction. Is firnsy's work available somewhere?
	find quote