Announcement

Collapse
No announcement yet.

Sample code with MySQL insert operation

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sample code with MySQL insert operation

    Hi,

    I am fairly new at HS but have a fair amount of experience in VB as well as MySQL and Oracle SQL syntax. I am looking to write some code that can record device statuses and other info from HS into a MySQL database, and would perhaps over time develop this as a plugin of some sort.

    Would anybody have/or be able to point to some vb.net code samples that demo a simple INSERT operation into a MySQL database? This would be helpful in jump starting the process.

    Thanks in advance,

    Dennis

  • #2
    There are some samples here:

    http://board.homeseer.com/showthread.php?t=180343

    There are a couple of plugins that already do this. Jon00's database charting and Device History are the ones that come to mind.

    Cheers
    Al
    HS 3.0.0.548: 1976 Devices 1156 Events
    Z-Wave 3.0.1.262: 123 Nodes on one Z-Net

    Comment


    • #3
      Or this one which is based on the topic in the previous post. INSERT and UPDATE command.

      Comment


      • #4
        Thanks to you both for your quick reply! - this looks promising.

        Thanks again

        Dennis

        Comment

        Working...
        X