php for d3 linux

[CDMI - Steve T]

what is needed to utilize php web technology on D3/Linux.

our version is:

D3 Release Version  9.0.0.LINUX

Most recent mload into boot abs performed at 16:37:02 on 16 Feb 2014.

Implementation. . . . . . 6386

Software Serial Number. . 11031328

System ID Number  . . . . 60336879

Release . . . . . . . . . D3/UNIX: LINUX

Unix Information. . . . . Linux;pick0:LINUX;2.6.32-431.23.3.el6.x86

we've been using Coyote for years, but the boss is looking for more 'main' stream technology.

all advise and suggestions are appreciated.

Steve Trimble

[MAV]

Hi Steve,

Take a look at JD3 (http://sourceforge.net/projects/jd3/).

Marcos Alonso Vega

[geneb]

On Thu, 16 Oct 2014, MAV wrote:

>
> Hi Steve,
>
> Take a look at JD3 (http://sourceforge.net/projects/jd3/).
>

Steve, if Java is an option, you might want to take a look at the Java
MVSP interface for D3. I use it and it's pretty nice.

g.

--
Proud owner of F-15C 80-0007
http://www.f15sim.com - The only one of its kind.
http://www.diy-cockpits.org/coll - Go Collimated or Go Home.
Some people collect things for a hobby. Geeks collect hobbies.

ScarletDME - The red hot Data Management Environment
A Multi-Value database for the masses, not the classes.
http://scarlet.deltasoft.com - Get it _today_!

[CDMI - Steve T]

would you please pass along a URL?

thanks,

 

Steve Trimble (501) 615-8674

Computerized Data Mgmt Inc (CDMI)

From: geneb <ge...@deltasoft.com>
To: mvd...@googlegroups.com
Sent: Thursday, October 16, 2014 8:52 AM
Subject: Re: [mvdbms] Re: php for d3 linux

On Thu, 16 Oct 2014, MAV wrote:

>
> Hi Steve,
>
> Take a look at JD3 (http://sourceforge.net/projects/jd3/).
>

Steve, if Java is an option, you might want to take a look at the Java
MVSP interface for D3.  I use it and it's pretty nice.

g.

--
Proud owner of F-15C 80-0007

http://www.f15sim.com/- The only one of its kind.
http://www.diy-cockpits.org/coll- Go Collimated or Go Home.

Some people collect things for a hobby.  Geeks collect hobbies.

ScarletDME - The red hot Data Management Environment
A Multi-Value database for the masses, not the classes.

http://scarlet.deltasoft.com/- Get it _today_!

--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+unsub...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms

[George Gallen]

I would imagine that D3 and the webserver (ie apache) would co-exist
on the Linux server. Not sure how coyote works - so on that subject
I claim ignorance.
 
php shouldn't matter - it's just the server side language being used
to interface with the web server. The question I think your asking
is how to interface D3 with the scripting programs?
 
there are two ways I can think of.
 
one - is where the D3 side does all the HTML work and the php scripts
just pass data to D3 and back to the web server for the client. where
you could use an embedded html tag to know what webpage is being
received - and the posted data is written to a file. The D3 side would
monitor that file - get the data and then run the appropriate D3 program.
that program would then create html output - write it to another file
which the php script is waiting for - and then passed back to apache.
 
two - where the php script creates the D3 commands and passes that
to D3, and waits for raw data to be returned - then that script will
work with the data and create the HTML to pass back to the server.
this option will require a method to send the D3 raw data back to
the php script, and most likely a bunch of php functions to work with
the data  (like MySQL functions).
 
The advantage to one - D3 does most of the work - and is isolated from
the webserver other than a conduit for transport - it would be more
difficult if someone hacked your server and accessed your .php scripts
to really be able to do much - since the filenames, logic is all contained
in D3 - they would then have to know that first, and then be able to
log into D3.
 
The advantage to two - your web interface could be more easily ported
to a different database backend - although it would still be difficult for
the multivalued aspect.
 
George
 

---

Date: Wed, 15 Oct 2014 14:26:30 -0700
From: cdm...@gmail.com
To: mvd...@googlegroups.com
Subject: [mvdbms] php for d3 linux

--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com

To unsubscribe, email to: mvdbms+un...@googlegroups.com

[geneb]

On Thu, 16 Oct 2014, CDMI - Steve T wrote:

> would you please pass along a URL?
> thanks,
>

Steve, the Java docs are here:

http://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/91/java_api/index.html

MVSP Quickstart Guide:
http://www3.rocketsoftware.com/rocketd3/support/documentation/d3nt/92/mvsp/index.htm

The software can be found here: ftp://ftp2.rocketsoftware.com/pub/MVSP/
You'll need a login ID & password to reach it, but your VAR should be able
to tell you what that is. From what mine is, they apparently use a
generic one. :)

If you need any help, please ask. I've been working with MVSP for quite a
while.

g.

--
Proud owner of F-15C 80-0007

http://www.f15sim.com - The only one of its kind.
http://www.diy-cockpits.org/coll - Go Collimated or Go Home.

Some people collect things for a hobby. Geeks collect hobbies.

ScarletDME - The red hot Data Management Environment
A Multi-Value database for the masses, not the classes.

[Glen Batchelor]

I'm sorry to hear that Gene.. are you better now?

ROFLOL.. sorry, can't help myself.

--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com

To unsubscribe, email to: mvdbms+unsubscribe@googlegroups.com

[geneb]

On Thu, 16 Oct 2014, Glen Batchelor wrote:

> I'm sorry to hear that Gene.. are you better now?
>
> ROFLOL.. sorry, can't help myself.
>

Ha! You're just jealous of my MVSP Fu. :D

[Kevin Powick]

On Wednesday, 15 October 2014 17:26:30 UTC-4, CDMI - Steve T wrote:

what is needed to utilize php web technology on D3/Linux.

Regardless of the tools/technology you use, the approach you should take is one that make D3 irrelevant to the PHP programmer.  The PHP developer should not need to understand D3 or multivalued data.  The way to do that is via a RESTful web service that provides an API for various D3 "services", against which your PHP developers can write the website/application.

Such an approach will also open up your D3 "services" to any platform/tool/language that can act as a HTTP client (e.g. mobile iOS/Android).  Nothing changes on the server as all that work is done.  Developers just need to code their client side application.

I don't have any suggestions for products to do this, but we rolled our own using Go (http://golang.org).  It's actually pretty nice and I have thought about "productizing" it for the MV community, but that's not high on my to-do list right now.

--

Kevin Powick

[CDMI - Steve T]

I think my biggest question is how to knock on D3's door and be accepted inside. Coyote is a real time 'on the dbase' HTTP 1.0 compliant web server. So Coyote handles the listening on phantom ports. It's configurable to listen to certain IP and ports. Course if you use Coyote, you don't code in PHP (that I'm aware of).

[Glen Batchelor]

remember this project? :)

http://mvwww.sourceforge.net/

I've not updated it in over 5 years, but if you are serving internal content or low-mid hit volume it should suffice.

Regards,

GlenB

--

You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com

To unsubscribe, email to: mvdbms+un...@googlegroups.com

[CDMI - Steve T]

thanks I'll look into that

 

Steve Trimble (501) 615-8674

Computerized Data Mgmt Inc (CDMI)

---

From: Glen Batchelor <batch...@gmail.com>
To: mvd...@googlegroups.com
Sent: Thursday, October 16, 2014 1:16 PM

Subject: Re: [mvdbms] Re: php for d3 linux

[Tony Gravagno]

I only got to this thread after responding to an email on the topic. I'm posting my email response here just to add to the pile. I'm not saying much beyond what has already been said, and it looks like I agree with everything here so far.

****

1) I might use MVSP/Java as a low-activity pipe. There should be a PHP/Java bridge so that you can instantiate a Java object. I know there is a COM interface for that for Windows. So there is one or more MVSP connections already established and you attach to one of them to do your transaction. I think there will be a performance hit in the instantiation of the Java object. Some experimentation is required. MVSP has had updates since 9.0. If you go this route I’d recommend a D3 upgrade.

2) You could write the data from PHP to the file system and then execute D3TCL to invoke a command that processes that data. Or just pass a small payload in the command-line. This will have a bigger performance hit than option 1 since it needs to login every time. I’d only do this when the number of hits is tiny. It’s a free and easy option, we pay with a lack of performance.

3) For a more robust environment, I’d set up a web service in a local IIS box and then make a hop from Apache/PHP there. Pass the payload via a SOAP or REST as desired. The web service uses mv.NET to connect back into D3. This bridge might be faster than the other options. It’s more robust because you get session pooling and no login pain – and for the benefit there will be a cost. The extra HTTP hop might seem like a performance hit but in this world of disconnected data we do this all the time. In fact in a typical LAMP environment the Apache server and MySQL databases are rarely on the same server- there is almost Always another hop from web server to data. So this is not an inelegant solution.

I’d be happy to provide all related code and licenses so that you can focus on the PHP part. I’d provide a generic interface via a PHP class so that you can just set the data and invoke a method to do the connectivity. The result would be exposed as a property on the connection object, as a string, array, or JSON object – whatever you want.

****

[geneb]

On Thu, 16 Oct 2014, Tony Gravagno wrote:

> 3) For a more robust environment, I’d set up a web service in a local IIS
> box and then make a hop from Apache/PHP there. Pass the payload via a SOAP
> or REST as desired. The web service uses mv.NET to connect back into D3.
> This bridge might be faster than the other options. It’s more robust

You're kidding me right? mv.NET is the last place you want to look if you
need speed. Their pooling server is a huge bottleneck.

[CDMI - Steve T]

Gene:

IMHO, anything that involves Windows and IIS should not be associated with a multimillion dollar international company. But again, just my opinion. Windows is the ONLY reason, I've stopped using mvBASE and to me, it was one of the fastest most stable environments I've worked on. I've totally switched to openQM. It's really hard to beat the openQM environment. The product is solid, support outstanding, and features out the wahzu (as we say here). Don't really know what a wahzu is though :-)

And... it runs on pretty much whatever flavor floats your boat.

Thanks Ladybridge!

be well all,

 

Steve Trimble (501) 615-8674

Computerized Data Mgmt Inc (CDMI)

From: geneb <ge...@deltasoft.com>
To: mvd...@googlegroups.com

Sent: Friday, October 17, 2014 8:06 AM

Subject: Re: [mvdbms] Re: php for d3 linux

--
You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com

To unsubscribe, email to: mvdbms+unsub...@googlegroups.com

[David Peters]

Hi

Would you like to provide details confirming your blunt statement. We have no incidents in the field that show this as all customers are experiencing the exact opposite.

Regards

David Peters
Sales Manager
BlueFinity International – an Mpower1 Group Company

-----Original Message-----
From: mvd...@googlegroups.com [mailto:mvd...@googlegroups.com] On Behalf Of geneb
Sent: 17 October 2014 14:06
To: mvd...@googlegroups.com
Subject: Re: [mvdbms] Re: php for d3 linux

--
You received this message because you are subscribed to the "Pick and MultiValue Databases" group.

To post, email to: mvd...@googlegroups.com To unsubscribe, email to: mvdbms+un...@googlegroups.com

[geneb]

On Fri, 17 Oct 2014, CDMI - Steve T wrote:

> Gene: IMHO, anything that involves Windows and IIS should not be
> associated with a multimillion dollar international company. But again,
> just my opinion. Windows is the ONLY reason, I've stopped using mvBASE
> and to me, it was one of the fastest most stable environments I've
> worked on. I've totally switched to openQM. It's really hard to beat the
> openQM environment. The product is solid, support outstanding, and
> features out the wahzu (as we say here). Don't really know what a wahzu
> is though :-) And... it runs on pretty much whatever flavor floats your
> boat. Thanks Ladybridge! be well all,

I agree completely. Unfortunately I've got code that uses assembler
(ScreenGen) and I don't have the resources to code out from under it so I
can dump D3 altogether. I'm still using v9.0 because I worry about what
changes were made to newer versions that might break those assembler
modules. :( There's also no budget to hire the folks that covert
ScreenGen stuff to AccuTerm, or I'd have done that by now.

I'd much rather throw money at Ladybridge than Rocket any day.

[geneb]

On Fri, 17 Oct 2014, David Peters wrote:

> Hi
>
> Would you like to provide details confirming your blunt statement. We
> have no incidents in the field that show this as all customers are
> experiencing the exact opposite.

I tested the mv.NET environment a number of years ago. At the time, the
D3VBODBC library (from within VB.Net, not VB6) I was using walked all over
the mv.NET interface in terms of speed. So unless you've managed to
gimmck away the laws of physics, that server in the middle is still
slowing things down.

The sad thing is, that crufty old class library is still faster than the
MVSP.Net code I'm forced to use now (because TL decided to make breaking
changes to the class library that made it impossible to use in a .Net
environment) I'd sorely love to get my hands on the source code so I
could port it to C and make it a real barn-burner.

The MVSP.Net library does work well though - it's just not as fast as it
could/should be. They made a huge mistake when they decided to make the
MVSP server process run essentially like an inbound telnet session to port
9000. They should have written the library to talk directly to the ODBC
server process instead. It would have saved a huge amount of developer
effort in creating the server side software - time that could've been
spent squeezing every last drop of performance out of the client library.
Instead, they punted and used the string builder class. They then
followed that up by shipping it with a show stopping bug that was so
blindingly obvious that the QA dept must have gone, "Hey it compiled!
Ship it!"

*waves cane*

[Gabriel Gonzalez]

Hi Tony, do you still have all the related code and licenses? I would be very happy if you could help me with that.

[Tony Gravagno]

Gosh, that was over a decade ago. If I was doing any communications work with MV now, the first place I'd look would be Linkar https://kosday.com/linkar/

I'd also check the status of MVSP and whatever is supported by the Python integrations.

I'm not involved with MV as I was in the past, so I can't provide anything directly.

Good luck!

T

On Thursday, August 14, 2025 at 4:16:37 PM UTC-7 gg wrote:

Hi Tony, do you still have all the related code and licenses? I would be very happy if you could help me with that.

 

El Thursday, October 16, 2014 a la(s) 8:45:07 PM UTC-3, Tony Gravagno escribió:

1) I might use MVSP/Java as a low-activity pipe. There should be a PHP/Java bridge...

2) You could write the data from PHP to the file system and then execute D3TCL...

3) For a more robust environment, I’d set up a web service in a local IIS box and then make a hop from Apache/PHP there. Pass the payload via a SOAP or REST as desired. The web service uses mv.NET to connect back into D3....

I’d be happy to provide all related code and licenses so that you can focus on the PHP part....

****

[Rafael Rivas]

Buenas tardes, no se, si estoy entendiendo bien, si lo que se quiere es acsesar la base de datos de d3 a php, porque si es así, yo tengo un programa elaborado desde Python de consulta de productos de la base de datos d3 Windows y muestra en la pantalla de python, la descripción, el pvp y la existencia, si no es lo que se quiere pido disculpas feliz tardes

--

You received this message because you are subscribed to
the "Pick and MultiValue Databases" group.
To post, email to: mvd...@googlegroups.com
To unsubscribe, email to: mvdbms+un...@googlegroups.com
For more options, visit http://groups.google.com/group/mvdbms

---
You received this message because you are subscribed to the Google Groups "Pick and MultiValue Databases" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mvdbms+un...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/mvdbms/4a811ce0-37a8-4d4f-9d8f-c3b075e0424dn%40googlegroups.com.