INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Separating Media Database and User Information  (Read 1329 times)

benn600

  • Citizen of the Universe
  • *****
  • Posts: 3849
  • Living: Santa Monica CA Hometown: Cedar Rapids IA
Separating Media Database and User Information
« on: December 17, 2007, 12:13:19 am »

With the recent stirring up of a server/client system and users/permissions, I'd like to bring up separating MC into two pieces:

1) Media Database
2) User Details (Playlists, Play Count, *and program settings*)

You may have read my DVD tagging thread.  If MC could utilize two portions, as explained above, then I would not have any trouble keeping the Media Database portion up to date and wouldn't need tagging info stored in the files (as much).  I still like tags in files because it means the MC database is not mandatory for "continuing existing."  I never like relying completely on a program's database.  The files are mandatory for enjoying them...MC "technically" is not.

Specifics obviously need to be worked out but this is a start.
Logged

johnnyboy

  • Regular Member
  • Citizen of the Universe
  • *****
  • Posts: 626
Re: Separating Media Database and User Information
« Reply #1 on: December 17, 2007, 04:37:51 am »

I've thought this for years, just never said it :)
Logged

benn600

  • Citizen of the Universe
  • *****
  • Posts: 3849
  • Living: Santa Monica CA Hometown: Cedar Rapids IA
Re: Separating Media Database and User Information
« Reply #2 on: December 17, 2007, 10:00:23 am »

Take your household of music listeners--creating a relational database for the entire household requires the above.

For just one person, go ahead and combine the two majorly different pieces of the puzzle.
Logged

Alex B

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 10121
  • The Cosmic Bird
Re: Separating Media Database and User Information
« Reply #3 on: December 17, 2007, 10:30:53 am »

Instead of trying to create the requested true client/server system, which would need a completely
different database engine and structure, something like this could be a good start towards a better
multi-users system.

I can imagine that the following could be relatively easy to accomplish:

- Add some automation to the current "shared library" feature. (Does it have an official name yet?)
  The initial start up process is currently a bit too complex task for many users. MC could automatically
  create the needed network shares and translate the filename paths according to the created
  share names so that the users would not need to move the media files.

- Add an easier way to promote one of the MC instances to have the write access.

- Make possible what is suggested in this thread. Each MC instance could have a "personal"
  subfolder for client specific database fields (user ratings, playlists etc) in the shared libary folder.
  Each MC instance would always be able to write these fields. Maybe MC could display a list of
  unconnected "accounts" when the shared library is loaded. Then it would not matter which PC is 
  used for opening a personal "account".

- A global play count could be maintained by summing the main library and user play counts.
Logged
The Cosmic Bird - a triple merger of galaxies: http://eso.org/public/news/eso0755

benn600

  • Citizen of the Universe
  • *****
  • Posts: 3849
  • Living: Santa Monica CA Hometown: Cedar Rapids IA
Re: Separating Media Database and User Information
« Reply #4 on: December 17, 2007, 12:24:57 pm »

Those are some good ideas.

Remember that on your server, you can still use the network addressable shares, //Chenbro/titanium/Music/[Artist]/[Album]/[Name].flac

That way it will work all over the network.
Logged

hit_ny

  • Citizen of the Universe
  • *****
  • Posts: 3310
  • nothing more to say...
Re: Separating Media Database and User Information
« Reply #5 on: December 17, 2007, 12:46:48 pm »

If MC could utilize two portions, as explained above, then I would not have any trouble keeping the Media Database portion up to date and wouldn't need tagging info stored in the files (as much).  I still like tags in files because it means the MC database is not mandatory for "continuing existing."  I never like relying completely on a program's database.  The files are mandatory for enjoying them...MC "technically" is not.
what does this mean ?

that you would like to save user specific info like rating etc for a file in the database ?

..and not anymore in the files ?

cos if you are already saving that stuff in the files then why do you need user specific sections in the DB

 ?
Logged

benn600

  • Citizen of the Universe
  • *****
  • Posts: 3849
  • Living: Santa Monica CA Hometown: Cedar Rapids IA
Re: Separating Media Database and User Information
« Reply #6 on: December 17, 2007, 02:15:26 pm »

It needs to be in the files for backup preservation.  If I move files on the server and a user's MC notices that, it may lose the tags.  Luckily they are stored in the files.

The tags cannot be just stored in the files because that would be painfully slow checking all the files to get all 14K song tags.
Logged

llafriel

  • World Citizen
  • ***
  • Posts: 230
Re: Separating Media Database and User Information
« Reply #7 on: December 17, 2007, 02:35:40 pm »

I also miss the ability to create playlists and set ratings from clients. What if the client communicated what was changed to the server, and the server updated its library accordingly? I know ratings could work this way as I do this already via my ppc and Netremote, well I think it works that way..
Logged
Pages: [1]   Go Up