| Computers Forum Index » Computer - Databases - Pick » D3 Web Services Demo using REST... |
|
Page 1 of 1 |
|
| Author |
Message |
| Kevin Powick... |
 Posted: Fri Aug 21, 2009 9:05 pm |
|
|
|
Guest
|
This web services demo will allow you to use REST style calls over
HTTP to call D3 BASIC subroutines and
return the results of those subroutines as MV data strings, including
attribute and value marks. Any client
capable of a HTTP GET request (such as a web browser), will be able to
use this web service.
Download from the following link:
http://tridentinfosys.com/downloads/D3WebService.zip
--
Kevin Powick |
|
|
| Back to top |
|
|
|
| Kevin Powick... |
| Posted: Sat Aug 22, 2009 1:25 am |
|
|
|
Guest
|
On Aug 21, 8:34 pm, "Peter McMurray" <excalibu... at (no spam) bigpond.com> wrote:
Quote:
I had not thought of using ODBC in this manner. I was thinking along the
lines of the web services created in Cache Zen, U2 UniObjects or QMClient..
They're all just different "pipes" into MV. I do pretty much the same
thing with QM and the QM client. It's funny that most people don't
seem to recall that D3 ODBC can call subroutines. I wouldn't use it
for anything else because of the PITA factor. I chose the D3 ODBC
option because it's included for free with D3 and should work across
all platforms.
Quote: I also see that FlashConnect has been resurrected
Yes, another data pipe.
Quote: However your solution definitely answers the question very well. it will
certainly cover the smaller user. Whether or not it will scale to the
larger user only testing will tell.
It will scale very well if you implement connection pooling (the demo
uses a single connection). It's not difficult to do, but for a
freebie demo, I wasn't going to take the time to implement it.
--
Kevin Powick |
|
|
| Back to top |
|
|
|
| Peter McMurray... |
| Posted: Sat Aug 22, 2009 4:34 am |
|
|
|
Guest
|
Hi Kevin
Thank you.
I had not thought of using ODBC in this manner. I was thinking along the
lines of the web services created in Cache Zen, U2 UniObjects or QMClient.
Plus one has been distracted from ODBC by it popping in and out of D3 setup
even changing original supplier.
I also see that FlashConnect has been resurrected I understood that
Flashconnect was dead and buried. However I find that they have just
upgraded it, I quote
" Starting and stopping the FlashCONNECT Service, and performance
monitoring have been improved.
Various hangs, stops, infinite loops, installation and debug failures
have been fixed."
Not exactly the sort of thing that one would want to bet the shed on
especially at $3000+ a pop and there is a warning that prices can change at
a moments notice.
However your solution definitely answers the question very well. it will
certainly cover the smaller user. Whether or not it will scale to the
larger user only testing will tell.
Peter McMurray
"Kevin Powick" <kpowick at (no spam) gmail.com> wrote in message
news:94bdee92-d444-4fd2-9ed5-eb917a3b6a48 at (no spam) l35g2000vba.googlegroups.com...
Quote: This web services demo will allow you to use REST style calls over
HTTP to call D3 BASIC subroutines and
return the results of those subroutines as MV data strings, including
attribute and value marks. Any client
capable of a HTTP GET request (such as a web browser), will be able to
use this web service.
Download from the following link:
http://tridentinfosys.com/downloads/D3WebService.zip
--
Kevin Powick |
|
|
| Back to top |
|
|
|
| Peter McMurray... |
| Posted: Sat Aug 22, 2009 11:19 am |
|
|
|
Guest
|
"Kevin Powick" <kpowick at (no spam) gmail.com> wrote in message
news:e8737f72-0840-4e68-85de-68ae3d263b5f at (no spam) h31g2000yqd.googlegroups.com...
On Aug 21, 8:34 pm, "Peter McMurray" <excalibu... at (no spam) bigpond.com> wrote:
Quote:
I had not thought of using ODBC in this manner. I was thinking along the
lines of the web services created in Cache Zen, U2 UniObjects or QMClient.
They're all just different "pipes" into MV. I do pretty much the same
thing with QM and the QM client. It's funny that most people don't
seem to recall that D3 ODBC can call subroutines. I wouldn't use it
for anything else because of the PITA factor. I chose the D3 ODBC
option because it's included for free with D3 and should work across
all platforms.
Quote: I also see that FlashConnect has been resurrected
Yes, another data pipe.
Quote: However your solution definitely answers the question very well. it will
certainly cover the smaller user. Whether or not it will scale to the
larger user only testing will tell.
It will scale very well if you implement connection pooling (the demo
uses a single connection). It's not difficult to do, but for a
freebie demo, I wasn't going to take the time to implement it.
--
Kevin Powick
Definitely not. Freebies are not what I am after. The concept was all that
I was trying to get to. With sockets not supported on D3 Windows the more
obvious solutions are not on. I definitely want it to be cross platform, I
may not like Linux but quite a few do, including the guy who offers a
connection solution separate to his overall package - Visage 
My concern in particular is that a solution is fully scalable. I do not
want to have to write different Pick code or HTML/Javascript just because
the user number changed. By sticking to limiting the connection to message
passing one can plug in another fancier box with session balancing
algorithms and full blown security at a price.
However your typical 5 to 10 user is not going to look kindly on paying more
for the connection than the database which is not the cheapest on the market
in the first place. I am not saying that their payment decisions are
justified, one just has to live with them.
I work in the petroleum industry and buy my petrol from the garage at the
bottom of the street because I want the guy there when I have a flat or my
wife (who hates messing with pumps etc) has to fuel up, Others will drive
40Km into town to cash in the 4c a litre off vouchers and then buy a
chocolate bar at the counter that is marked up more than the amount they
just "saved"!
In fact one of the phrases I object to in the Tiger Logic brochure is "It is
free" if I could ban the dratted word from software I would.
I intend to follow up on Coyote again on 18 May 2009 Sam Snyder wrote to me
"do you want to use Coyote on windows or linux. Currently, it is not
supported on Windows."
Peter McMurray |
|
|
| Back to top |
|
|
|
| Tony Gravagno... |
| Posted: Sat Aug 22, 2009 12:06 pm |
|
|
|
Guest
|
Quote: With sockets not supported on D3 Windows...
They are.
Quote: I do not want to have to write different
Pick code or HTML/Javascript just because the user
number changed.
You would never have to do that no matter what technology you use.
Quote: By sticking to limiting the
connection to message passing one can plug in another
fancier box with session balancing algorithms and full
blown security at a price.
Easy as that huh?
Quote: However your typical 5 to
10 user is not going to look kindly on paying more for
the connection than the database which is not the
cheapest on the market in the first place.
Huh?
Quote: I am not
saying that their payment decisions are justified, one
just has to live with them.
Huh? |
|
|
| Back to top |
|
|
|
|
