i!-Database Plus on Netlinx

dthorson
dthorson Junior Member
in AMX Applications and Solutions
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?
· Share on FacebookShare on Twitter

Comments

  • joelw
    joelw Junior Member
    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.
    · Share on FacebookShare on Twitter
  • joelw
    joelw Junior Member
    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.
    · Share on FacebookShare on Twitter
  • dthorson
    dthorson Junior Member
    This is great. Is there a duet module for this type of App, or did you write your own?
    · Share on FacebookShare on Twitter
  • joelw
    joelw Junior Member
    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.
    · Share on FacebookShare on Twitter
  • pthamatharan
    pthamatharan Junior Member
    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
    · Share on FacebookShare on Twitter
  • svTech
    svTech Senior Programmer
    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.
    · Share on FacebookShare on Twitter

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Comment As ...

Categories