A Q on database ..

To discuss development of addons / skins / customization of MediaMonkey.

Moderator: jiri

dtsig
Posts: 2833
Joined: Mon Jan 24, 2011 6:34 pm

A Q on database ..

Post by dtsig » Sat Jun 27, 2015 10:39 am

Are we still stuck with just sqlite? Or will this be opening up to other/stronger databases?

Thanks .. looking like fun so far
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

PetrCBR
Posts: 1431
Joined: Tue Mar 07, 2006 5:31 pm
Location: Czech
Contact:

Re: A Q on database ..

Post by PetrCBR » Sat Jun 27, 2015 2:08 pm

We're still using sqlite.

dtsig
Posts: 2833
Joined: Mon Jan 24, 2011 6:34 pm

Re: A Q on database ..

Post by dtsig » Sat Jun 27, 2015 2:36 pm

Will that be expanded?
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

jiri
Posts: 5351
Joined: Tue Aug 14, 2001 7:00 pm
Location: Czech Republic
Contact:

Re: A Q on database ..

Post by jiri » Mon Jun 29, 2015 3:10 am

There aren't any plans for a change of this. I hope that any possible usecase would be covered by the current and future features of MM5. Feel free to let me know what you miss in the SQLite implementation though (here or over email)...

Jiri

dtsig
Posts: 2833
Joined: Mon Jan 24, 2011 6:34 pm

Re: A Q on database ..

Post by dtsig » Mon Jun 29, 2015 9:17 am

Jiri .. first thanks for being open for discussion. And don't get me wrong I love MMW and like the looks of the new UI except that the graphics are flat like all things window8 :(.
I believe that MMW really needs expanding to "real" database and here are my major reasons ..

1) Stability. Yes I know that I am the only one that ever has a problem with MMW .. especially the DB. But this is a real problem. Just this morning MMW acted up again and I lost a couple hours of work. This is because the db is not saved for each transaction. It is one big file and updated at the end. I virtually never have any problems with say something using mySql ..
2) Multiuser. I want to share a single instance of the "db" with the family. Then my daughter could connect (using her own user) and add ratings or add tracks/vids etc. Wife .. the same. They could share their tracks or not. Also this would allow for the 'admin' to maybe hide some vids/tracks that you really don't want the kids to play. Think LOTR .. One mediaserver to rule them all
3) connectivity. I want to be able to easily access the db from external routines. Yes there is the connection object available but that is not entirely intuitive.
4) Accessibility. Along with that there is no easy way to work with the database directly. This is because of the .. crap my brain just froze .. you know the sorting page you use .. so only MMW can access the data (easily).

Don't get me wrong .. I'm not pulling a DrKeith <G> .. this isn't a deal killer .. but just like the 'service' should really becoming THE service .. the db needs to get out of the 'only one instance' mode. MMW is growing up and those old shoes are just too tight.

Thanks for listening ..
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

PetrCBR
Posts: 1431
Joined: Tue Mar 07, 2006 5:31 pm
Location: Czech
Contact:

Re: A Q on database ..

Post by PetrCBR » Mon Jun 29, 2015 12:23 pm

dtsig, i can respond to item 4 ... here you can download sqlite plugin with our collation, so when you use editor with plugins support, you can use it and search,sort even with text fields.

dtsig
Posts: 2833
Joined: Mon Jan 24, 2011 6:34 pm

Re: A Q on database ..

Post by dtsig » Mon Jun 29, 2015 4:56 pm

Thanks PetrCBR. That does help ..
Where's the db and ini stored
Reporting Bugs
Where tags are stored

Not affiliated with MediaMonkey ... just a RABID user/lover
DTSig

jiri
Posts: 5351
Joined: Tue Aug 14, 2001 7:00 pm
Location: Czech Republic
Contact:

Re: A Q on database ..

Post by jiri » Tue Jul 07, 2015 8:07 am

Thanks, good to know your thoughts about this, even though I have a different opinion is some aspects.

1) This really shouldn't happen, the DB is supposed to be very stable and secure. Please let me know more details, maybe a debug log could contain some useful info.
2) I'm afraid that it would add so much complexity, way more than most users expect and can even manage. I think that a more manageable approach is to have each DB stored locally per user, this way individual ratings can be handled. As for permissions - this can be handled by sharing (some parts of) a library over upnp, can't it?
3) What exactly you mean by external routines? I think that access through MM API works well.

Jiri

Teknojnky
Posts: 5523
Joined: Tue Sep 06, 2005 11:01 pm
Contact:

Re: A Q on database ..

Post by Teknojnky » Mon Dec 26, 2016 1:45 am

Hi. Long time time!

Good to see that MM continues to march along into the future!

Regarding database/sqlite:

I agree with previous comment regarding multi user, I believe that many years ago when MM2 used access database, it was much easier to have multiple user sharing database, than since the change to sqlite.

As before, I believe the solution is to decouple the physical database from the app, to allow for any user supplied database backend (sqlite/mysql/MSsql/etc).

Like how KODI (previously xbmc) you can switch from the internal/local DB, to a remote MYSQL DB for media library.

Ever since then, I have KODI/MYSQL database running on NAS (linux based readynas), and a dozen different clients all accessing the shared media library.

I wish/hope that someday MM will eventually allow similar shared database implementation.

To Jiri, individual user/client profiles within a shared database can also be created to manage any type of individual ratings/play counts/etc, ie have both global play counts/ratings, and client/user specific ones.

Peke
Posts: 11201
Joined: Tue Jun 10, 2003 7:21 pm
Location: Serbia
Contact:

Re: A Q on database ..

Post by Peke » Mon Dec 26, 2016 7:18 pm

+1 to that Teknojnky
Me and few other friends (one of them is database expert) are working on stable solution for MM and recently we made big progress when we developed bi-di communication for a friends client which can possibly used in MM. Simply said we used Combination of Direct MySQL Access on QNAP that share single MM Library (designated server MM) which is distributed/imported into Clients (MM clean Install). All DB is Handled using UNC path so it should be accessible on any Client accessing DB.

Other aspects like Playlists/collections/devices are per each client side. Unfortunately it is still in drawing board and far from test release but it is possible and can be made working.
Best regards,
Pavle
MediaMonkey lead QA/Tech Support guru
Admin of Free MediaMonkey addon Site HappyMonkeying
Image
Image
How to add Images to forum

Post Reply