Home AMX User Forum AMXForums Archive Threads AMX Applications and Solutions

i!-Database Plus on Netlinx

Is there a way to host the DB and web files directly on the MASTER?

I love this tool, it's just difficult to convince a client that I need to install files on their server, or my own server on their network.

If one master could host the DB and web traffic of other masters this solution would be more self contained.

Anyone tried this? Or know if it's possible?

Comments

  • joelwjoelw Posts: 175
    dthorson wrote:
    Anyone tried this? Or know if it's possible?

    It's a commercial grade Java DB running as a Duet module. I didn't do any fancy queries, nor load large amounts of data, but my limited test worked.

    The performance on a centrally hosted AMX master DB might not be so great compared to i!-Database Plus. You might get away with a DB on each master, with a replication/sync scheme.

    I'm curious on amount and type of data.
  • joelwjoelw Posts: 175
    Update

    I just updated my test/demo a bit more. Running a database directly on a Duet enabled box is feasible.

    Current output
    send c vdvDuet,'?'
    >(0000164238) Hello Database!
    (0000164241) This application was run 16 time(s)
    (0000168740) Query is : SELECT * FROM CUSTOMER
    (0000168751) 0  First Name      Joel    0
    (0000168755) 1  Last Name       Winarske        0
    (0000168758) 2  Address1        2248 Morlan Drive       0
    (0000168761) 3  ZIP     94558   0
    (0000168764) 4  Phone   707-320-4271    1
    (0000168767) 5  Email   joelw@indyelectronics.com       1
    (0000168770) Query is : SELECT * FROM TOYS
    (0000168782) 0  Bear    20 cm   20.00
    (0000168786) 1  City Leopard    25 cm   17.00
    (0000168791) 2  City Giraffe    25 cm   17.00
    (0000168795) 3  City Tiger      25 cm   17.00
    (0000168800) 4  Frog    50 cm   32.00
    (0000168804) 5  Yeti-Sheep      25 cm   24.00
    (0000168809) 6  Cow     20 cm   15.00
    (0000168813) 7  Raven   30 cm   30.00
    (0000168816) Query is : SELECT * FROM ORDERS
    (0000168824) 1  1       1
    (0000168827) 2  5       3
    (0000168830) 3  7       2
    (0000168833) 4  2       1
    (0000169862) Database Created
    

    This database implementation would be suitable for phone list, contact list, VC listing, equipment usage, guide data, CDDB info, Voting System, etc. The database can also be synchronized to JDBC capable servers such as Oracle, SQL 200x, MySQL, etc.

    Send me an email if you have any development needs I can assist with.
  • dthorsondthorson Posts: 103
    This is great. Is there a duet module for this type of App, or did you write your own?
  • joelwjoelw Posts: 175
    dthorson wrote:
    This is great. Is there a duet module for this type of App, or did you write your own?

    It's a commercial Java product that we have a development license for. So we can provide a solution using this code and provide the commercial license file. It's a mature solution that runs well on AMX's Java implementation. Licensing is tied to Ethernet MAC Address.
  • Database implementation
    joelw wrote: »
    I just updated my test/demo a bit more. Running a database directly on a Duet enabled box is feasible.

    Current output
    send c vdvDuet,'?'
    >(0000164238) Hello Database!
    (0000164241) This application was run 16 time(s)
    (0000168740) Query is : SELECT * FROM CUSTOMER
    (0000168751) 0  First Name      Joel    0
    (0000168755) 1  Last Name       Winarske        0
    (0000168758) 2  Address1        2248 Morlan Drive       0
    (0000168761) 3  ZIP     94558   0
    (0000168764) 4  Phone   707-320-4271    1
    (0000168767) 5  Email   joelw@indyelectronics.com       1
    (0000168770) Query is : SELECT * FROM TOYS
    (0000168782) 0  Bear    20 cm   20.00
    (0000168786) 1  City Leopard    25 cm   17.00
    (0000168791) 2  City Giraffe    25 cm   17.00
    (0000168795) 3  City Tiger      25 cm   17.00
    (0000168800) 4  Frog    50 cm   32.00
    (0000168804) 5  Yeti-Sheep      25 cm   24.00
    (0000168809) 6  Cow     20 cm   15.00
    (0000168813) 7  Raven   30 cm   30.00
    (0000168816) Query is : SELECT * FROM ORDERS
    (0000168824) 1  1       1
    (0000168827) 2  5       3
    (0000168830) 3  7       2
    (0000168833) 4  2       1
    (0000169862) Database Created
    

    This database implementation would be suitable for phone list, contact list, VC listing, equipment usage, guide data, CDDB info, Voting System, etc. The database can also be synchronized to JDBC capable servers such as Oracle, SQL 200x, MySQL, etc.

    Send me an email if you have any development needs I can assist with.

    pls tell how to implement MySQL on Duet
  • svTechsvTech Posts: 44
    Joel is, likely, no longer monitoring this forum. If memory serves me, he has moved away from the AMX world.

    You can try to email him directly. See his posts for an email address (embedded in the text that he posted way back when).

    Cool idea, but unfortunately, I can't help with the actual details.
Sign In or Register to comment.