Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Desktop Feature Requests Page: 1 2  Previous   Next
Standard webservice access to the data.
Author Message
DVD Profiler Desktop and Mobile Registrantlmoelleb
Beer Profiler now!
Registered: March 14, 2007
Denmark Posts: 630
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Today there are a lot of discussion about how data should be exposed. Should it be REST or SOAP, should it be JSON or XML? The only thing everyone agree on, is that it shouldn't be home cooked binary formats as introduced in 3.7. Specifically not with buffer overflow attacks happening left and right.

Please add a proper service allowing us to access our data. You can even create it using WCF with all the above mentioned endpoints so noone starts yelling at you for not supporting their specific preferences.
Regards
Lars
DVD Profiler Unlimited RegistrantStar ContributorNexus the Sixth
Contributor since 2002
Registered: March 13, 2007
Reputation: High Rating
Sweden Posts: 3,195
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I think I need a translation. 
First registered: February 15, 2002
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,741
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
In the plugins forum you can download a plugin toolkit and directly connect with DVDP using C# as a programming language.

Or you export your collection via the File menu to XML.


As far as I'm aware there is no official way to exchange data with the online database, so you couldn't use any of your proposed webservice protocols.

And what binary format are you talking about?
Karsten
DVD Collectors Online

DVD Profiler Unlimited RegistrantStar ContributorLewis_Prothero
Strength Through Unity
Registered: May 19, 2007
Reputation: Superior Rating
Germany Posts: 6,730
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting lmoelleb:
Quote:
home cooked binary formats



That reminded me of:
Quote:
1 out of 10 people can understand the binary system. The other half never will.
It all seems so stupid, it makes me want to give up!
But why should I give up, when it all seems so stupid?


Registrant since 05/22/2003
 Last edited: by Lewis_Prothero
Invelos Software, Inc. RepresentativeKen Cole
Invelos Software
Registered: March 10, 2007
United States Posts: 4,282
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
There weren't any home cooked binary formats introduced in 3.7, so I'm also confused.  XML export is still there, and the plugin interface is unchanged.
Invelos Software, Inc. Representative
DVD Profiler Desktop and Mobile Registrantlmoelleb
Beer Profiler now!
Registered: March 14, 2007
Denmark Posts: 630
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
My mistake - it probably was introduced earlier, I just didn't notice. What I am referring to is options/sharing/Share my collection on the network. I had the idea that it was added to support iPhone communication, but I now understand it was introduced previously to support client/server setup.

Anyway - I turned it on, hooked it through a TCP monitor expecting to see REST or SOAP flying by. Unless I missed something, that didn't look like any of the modern standard protocols to me. It even had HTML content type set in the headers when it was downloading images.

While I could of course reverse engineer this protocol, it's not really the kind of stuff I enjoy doing anymore (10-15 years ago I would probably have gone for it). With SOAP being pretty old, and REST being so simple I am just used to have access to data.

I am aware of the XML export, and I am aware of the plugin system (you can find my Instant Export plugin taking most of the pain away in the downloads/plugins section). However there are a couple of weaknesses with this approach:

1) The export is (even when automated) a one way road. You can get data out, but not in.
2) The plugin system is fine for tasks that belongs inside DVD Profiler, but it is problematic if the data exchange has to be driven from an outside task.

For now I have thrown an HTTP server into a plugin so I can serve up a simple REST/XML interface in DVD Profiler - it's read only now, and I do not really have the time to extend it a lot. I'll just add the functionality I need to get the data moved to my WP7 device.
Regards
Lars
 Last edited: by lmoelleb
Invelos Software, Inc. RepresentativeKen Cole
Invelos Software
Registered: March 10, 2007
United States Posts: 4,282
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
The database sharing protocol isn't intended to be public and will change from version to version, so reverse engineering it wouldn't be the way to go.  A server-side plugin like you're doing sounds like a great fit for your task.
Invelos Software, Inc. Representative
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
It would still be nice some day to have a service running that grants access to the data outside of the main program. I have no specific needs at this point in time, but I think it would be fun to see some of the ideas that others could come up with.  With the proper set of tools available, I'm sure we would soon have multiple additional options to display our online collections.

Just something to think about for the future.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Mark Harrison:
Quote:
It would still be nice some day to have a service running that grants access to the data outside of the main program.

The problem I see (and maybe Ken also): With the database accessible there wouldn't be any need for buying the program for a lot of people, thus it could kill his business-model.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Desktop and Mobile Registrantlmoelleb
Beer Profiler now!
Registered: March 14, 2007
Denmark Posts: 630
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Quoting Mithi:
Quote:
The problem I see (and maybe Ken also): With the database accessible there wouldn't be any need for buying the program for a lot of people, thus it could kill his business-model.

cya, Mithi


A few options:
1) A service running locally providing access to your locally stored collection. Without a local collection, there is nothing to run, so no change in the business model.
2) Host the service from the cloud - but still only granting access to your own collection, so you have to pay to go over 50 profiles (or make it part of an aditional yearly subscription service) - again, no change in the business model - even the yearly subscription feature have been mentioned before.

That said, coming up with new business models to complement your current is not necessarely a bad thing.
Regards
Lars
DVD Profiler Unlimited RegistrantMark Harrison
I like IMDB
Registered: March 13, 2007
Reputation: Great Rating
United States Posts: 3,321
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Mithi:
Quote:
Quoting Mark Harrison:
Quote:
It would still be nice some day to have a service running that grants access to the data outside of the main program.

The problem I see (and maybe Ken also): With the database accessible there wouldn't be any need for buying the program for a lot of people, thus it could kill his business-model.

cya, Mithi


I was referring to the users database.  Whether it accesses the local or their online.  Complete access to the primary database does present some issues.  Which is too bad as that would open even more possibilities.
Get the CSVExport and Database Query plug-ins here.
Create fake parent profiles to organize your collection.
DVD Profiler Unlimited RegistrantEnzo4
Registered: September 6, 2010
Posts: 11
Posted:
PM this userDirect link to this postReply with quote
It would be cool to have an access to the sharing server of course.

Here is my need, and it would open a little more your business:

I have a collection so, i can access it now from iphone/ipad, great, but i'd like to see my whole collection on my apple tv2, thanks to itune

Another big problem I have against DVD profiler is the fact it doesn't work on mac

=> So would be nice to have, even a light, program on mac (sold on mac store for example), that can connect to the sharing server of a dvd profiler running on windows (of course, would be even better to have a generic server that manages the database, that could run on any OS, as a result DVD profiler would be the official client running on windows)

you could code this new light soft on mac on native coding code of mac or with a cross platform language like Qt (in order to maintain only one client)

Would be for you a new soft you could sell on mac store (mac store is running from a couple of days)

and in that way, as the soft could be run everywhere, the need to reverse engineering would be quite low, and would protect you from guys analysing the protocol too closely......

I would be interested in buying such a software
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,455
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
How about SQL Server?

- It probably already runs as a service
- Standard API and SQL is international standard
- Available to plugins
- Available to scripts
- Cross platform

How about a collaboration?

- First step would be to define an "official" database schema that represents the DVDP data model (maybe start with the XML schema that some people already have)
- Step 2 would be to determine which elements of the schema could be supported by a plugin
(for example: "get actor picture by actor name" could not be supported today, even though those items are within the DVDP data model)
- Agreements as to who codes up which pieces
- Somebody volunteers to package and coordinate updates
- Maybe Invelos would "fund" and/or support the effort, then own the result?
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,455
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
More ideas:

MS Message Queue is a very simple protocol that could simplify communications between the client and server and make them more robust. Main issue is whether MQ is available on Mac, linux, etc. IP protocols are more universal, but writing robust code is tricky.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting mediadogg:
Quote:
How about SQL Server?
- First step would be to define an "official" database schema that represents the DVDP data model (maybe start with the XML schema that some people already have)

For that I would look to phpDVDProfiler, they already work with mySQL so they already have a way to get the XML into SQL statements.

But I just found the Restifier-Plugin from lmoelleb ... isn't that already what you (unspecific) want?

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
Registered: May 1, 2002
Registered: March 14, 2007
Reputation: Highest Rating
Germany Posts: 6,741
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting Mithi:
Quote:
Quoting mediadogg:
Quote:
How about SQL Server?
- First step would be to define an "official" database schema that represents the DVDP data model (maybe start with the XML schema that some people already have)

For that I would look to phpDVDProfiler, they already work with mySQL so they already have a way to get the XML into SQL statements.


Also, if you're interested check out my "DVD Profiler to Access" source code in C# (see signature). Loads of SQL statements there.
Karsten
DVD Collectors Online

 Last edited: by DJ Doena
    Invelos Forums->DVD Profiler: Desktop Feature Requests Page: 1 2  Previous   Next