Author |
Message |
Registered: March 14, 2007 | Posts: 630 |
| Posted: | | | | 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 |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,197 |
| Posted: | | | | I think I need a translation. | | | First registered: February 15, 2002 |
|
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| Posted: | | | | 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
|
|
Registered: May 19, 2007 | Reputation: | Posts: 6,730 |
| Posted: | | | | 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 |
|
Registered: March 10, 2007 | Posts: 4,282 |
| Posted: | | | | 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 |
|
Registered: March 14, 2007 | Posts: 630 |
| Posted: | | | | 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 |
|
Registered: March 10, 2007 | Posts: 4,282 |
| Posted: | | | | 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 |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,321 |
| Posted: | | | | 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. |
|
Registered: March 13, 2007 | Reputation: | Posts: 2,217 |
| Posted: | | | | 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 |
|
Registered: March 14, 2007 | Posts: 630 |
| Posted: | | | | 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 |
|
Registered: March 13, 2007 | Reputation: | Posts: 3,321 |
| Posted: | | | | 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. |
|
Registered: September 6, 2010 | Posts: 11 |
| Posted: | | | | 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 |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,461 |
| Posted: | | | | 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 |
|
Registered: March 18, 2007 | Reputation: | Posts: 6,461 |
| Posted: | | | | 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 |
|
Registered: March 13, 2007 | Reputation: | Posts: 2,217 |
| Posted: | | | | 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 |
|
Registered: March 14, 2007 | Reputation: | Posts: 6,744 |
| Posted: | | | | 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 |
|