Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[benn600]

Has anyone at J River looked into MySQL as the MC database at all?

Personally, I would absolutely love it if the entire (or almost every) settings/options list could be stored in the database and if it was a MySQL database that would be incredibly handy.  Then, I could write a PHP site that would connect to the database and I could manipulate it (in reasonable ways).  And then imagine running a MySQL server at home and simply using MC to connect to the database (port 3389).  I know there are a lot of implications but I can't stop imagining how amazing this could be.  You would have a table (or tables) for storing program settings.  Plus, wouldn't it help reduce database corruption as the database would be completely separate from MC?

Let me know if any investigation has been done.  I'd love to hear your experiences.  I'm a huge MySQL fan.

[John Gateley]

This comes up every once in a while. While general purpose databases like MySQL and Postgresql are amazing, they are general purpose. MC uses a special purpose database, and does a lot better because it is special purpose.

We use both MySQL and Postgres in house.

j

[johnnyboy]

It would be absolutely FANTASTIC as it would give limitless potential to expand on the app but I can see how it would cause them problems as they'd have no control over customizing it.

Having said that - whats really needed is the whole OS file system to run as a DB then MC can just connect to that and use that for the data as could every other app!

[benn600]

Yep: what if NTFS was just a MySQL database of files and their location on the disk?  There would be no synchronizing the two.

John, do you have any general statistics for running MySQL in house?  I run some complicated queries on one of my sites and am disappointed with the speed.  Of course its joining two very large tables.  But the easy and powerful access to the *MC* database as MySQL would be amazing.

I'm very interested in getting all profile settings being stored in the library files.  I just saw MySQL as a possible place to store this (registry is where much of it is stored now).

[JimH]

Has anyone at J River looked into MySQL as the MC database at all?

Personally, I would absolutely love it if the entire (or almost every) settings/options list could be stored in the database and if it was a MySQL database that would be incredibly handy.  Then, I could write a PHP site that would connect to the database and I could manipulate it (in reasonable ways).  And then imagine running a MySQL server at home and simply using MC to connect to the database (port 3389).  I know there are a lot of implications but I can't stop imagining how amazing this could be.  You would have a table (or tables) for storing program settings.  Plus, wouldn't it help reduce database corruption as the database would be completely separate from MC?

Let me know if any investigation has been done.  I'd love to hear your experiences.  I'm a huge MySQL fan.

We looked at it.  It was too slow for our purposes.

[newsposter]

There are scads of special-purpose databases available most (all) of which are faster and easier to maintain/admin that any SQL-based right like MySQL.

[Mr ChriZ]

There are scads of special-purpose databases available most (all) of which are faster and easier to maintain/admin that any SQL-based right like MySQL.

From a purely technical interest, could you give an example of one of these newsposter?
I'd like to take a look.  I've never played with a non SQL database.

Cheers,
Chris

[newsposter]

I'm in love with vsamEx, I've embedded it in a few things over the years.

http://www.1-software-source.com/index.html

JR should have a look at this too.  The licensing is very, VERY reasonable and it would open up the door to a Linux version of MC as well as multi-user/multi-server installations using the same database.

[Mr ChriZ]

Thanks that looks interesting. =)