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

nogi · 2010-11-11 15:28

Jordan Wrote:I was able to fix my slow connection problem on my mac by adding

Code:

[mysqld] ..... ...... skip-name-resolve
to the MySQL my.ini file.

Where on the Mac do I find this file?

Jordan · 2010-11-11 21:23

nogi Wrote:Where on the Mac do I find this file?

This file is not on your mac. Its on the computer running MySQL. I believe this file can be in different places depending on the OS and possibly on install settings. Mine is in C:\Program Files\MySQL\MySQL Server 5.1 on Windows Home Server (which is pretty much Windows Server 2003).

nogi · 2010-11-12 04:01

Jordan Wrote:This file is not on your mac. Its on the computer running MySQL. I believe this file can be in different places depending on the OS and possibly on install settings. Mine is in C:\Program Files\MySQL\MySQL Server 5.1 on Windows Home Server (which is pretty much Windows Server 2003).

Right. Mine is on a QNAP server Confused

Jordan · 2010-11-12 06:20

nogi Wrote:

Right. Mine is on a QNAP server

I believe you want to edit this file /etc/config/my.cnf

Robotica · 2010-11-12 15:48

In this topic solexalex started working on a picture database. To help him out a little I have got a few questions: Since it is a plugin (with it's own database):

Is there a decision about the naming convention already? I think if so, it would be very convenient for solexalex (and all users) to implement them at this point in time.

And is it possible to test this plugin with a mySQL database? Or should the mysql-patches somehow be applied to his database?

czfj5r · 2010-11-14 14:58

Hi,

been looking into the thread and tried some searches but...
Is there anywhere a current updated schema of the database layout which is kept up to date where someone can see the relationships as well as the indexing used (mySQL i my highest interest)?

It would be great to be able to see the ongoing latest database information as to understand where there might be options for enhancing speed. Currently I suffer most in the music library and thereby trying to get inside the database as it seems to me that might be the bottleneck?

If the schema is already visible and available somewhere I apologize for not finding it and feel very free to enligten me of the whereabouts Smile

_Andy_ · 2010-12-06 23:28

Hello

The database is a very nice idea. I installed a mysql setup and added some data.
There are the local paths for the thumbs/fanart stored?
Maybe i'm to blind but if i query the databae via JSON i get e.g. for a tvshow 'special://masterprofile/Thumbnails/Video/c/cf3b00f0.tbn'
So how can i query this information via the mysql database?

joemorin73 · 2010-12-09 20:58

_Andy_ Wrote:Hello

The database is a very nice idea. I installed a mysql setup and added some data.
There are the local paths for the thumbs/fanart stored?
Maybe i'm to blind but if i query the databae via JSON i get e.g. for a tvshow 'special://masterprofile/Thumbnails/Video/c/cf3b00f0.tbn'
So how can i query this information via the mysql database?

Do you have MySql workbench installed?

joemorin73 · 2010-12-09 21:00

I'm reading up on the Database and I'm interested in helping out on a new design. Is this proposal still being pursued?

sebak · 2010-12-09 22:48

joemorin73 Wrote:I'm reading up on the Database and I'm interested in helping out on a new design. Is this proposal still being pursued?

If you mean design of the database itself, you'll probably wanna go here:
http://forum.xbmc.org/showthread.php?tid=73831

nogi Junior Member Posts: 46 Joined: Aug 2010 Reputation: 0	2010-11-11 15:28 Post: #171 Jordan Wrote:I was able to fix my slow connection problem on my mac by adding Code: `[mysqld] ..... ...... skip-name-resolve` to the MySQL my.ini file. Where on the Mac do I find this file?
	find quote

Jordan Junior Member Posts: 14 Joined: Mar 2010 Reputation: 0	2010-11-11 21:23 Post: #172 nogi Wrote:Where on the Mac do I find this file? This file is not on your mac. Its on the computer running MySQL. I believe this file can be in different places depending on the OS and possibly on install settings. Mine is in C:\Program Files\MySQL\MySQL Server 5.1 on Windows Home Server (which is pretty much Windows Server 2003).
	find quote

nogi Junior Member Posts: 46 Joined: Aug 2010 Reputation: 0	2010-11-12 04:01 Post: #173 Jordan Wrote:This file is not on your mac. Its on the computer running MySQL. I believe this file can be in different places depending on the OS and possibly on install settings. Mine is in C:\Program Files\MySQL\MySQL Server 5.1 on Windows Home Server (which is pretty much Windows Server 2003). Right. Mine is on a QNAP server
	find quote

Jordan Junior Member Posts: 14 Joined: Mar 2010 Reputation: 0	2010-11-12 06:20 Post: #174 nogi Wrote: Right. Mine is on a QNAP server I believe you want to edit this file /etc/config/my.cnf
	find quote

_Andy_ Senior Member Posts: 128 Joined: May 2010 Reputation: 0 Location: Germany, Milky Way Galaxy	2010-12-06 23:28 Post: #177 Hello The database is a very nice idea. I installed a mysql setup and added some data. There are the local paths for the thumbs/fanart stored? Maybe i'm to blind but if i query the databae via JSON i get e.g. for a tvshow 'special://masterprofile/Thumbnails/Video/c/cf3b00f0.tbn' So how can i query this information via the mysql database?
	find quote

joemorin73 Junior Member Posts: 7 Joined: Nov 2010 Reputation: 0	2010-12-09 21:00 Post: #179 I'm reading up on the Database and I'm interested in helping out on a new design. Is this proposal still being pursued?
	find quote

sebak Junior Member Posts: 31 Joined: Mar 2010 Reputation: 0 Location: Belgium	2010-12-09 22:48 Post: #180 joemorin73 Wrote:I'm reading up on the Database and I'm interested in helping out on a new design. Is this proposal still being pursued? If you mean design of the database itself, you'll probably wanna go here: http://forum.xbmc.org/showthread.php?tid=73831
	find quote