Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

Reading mango mysql database in external application


  • Hi

    I am interested in the idea of reading Mango's MySQL database in an external application. Initially this would just be simple - for example, say I have a temperature data point, and I want to display the current temperature on an external website for public viewing.

    Is accessing the Mango db directly (using python etc tools) feasible? Has anyone done this? Interested in any advice or tips as I'm not a database guy, though I do understand a bit about relational db's.

    Thanks,
    Jeremy


  • that is ok,in can read and write the database in your own application, But if you want read the realtime datapoint value,you had better use mango api,because read the realtime data,you have to very frequently opera the database,that is inefficient, if you use the mangto api,you can read the data from memory,no need to opera database.


  • Thanks Hussam.

    Using the API sounds like the best way to go, but it isn't released yet, right? Do you have early access to it?


  • I am also waiting ,and if you just need simple function to read and write database in your owr way,you can develop some code yourself to integrate into mango.


  • hussam is correct,

    There is a cache and some timing issues with reading directly from the database as Mango does hold and buffer the recently read data in memory before inserting it into the database when it has the resources to do so. The best way to do this will be to use the yet-to-be-released REST Api.

    We are getting close to a release date for Mango 2.5.0 but until then you can use the development branch of our Git Repository if you want to see how it will work.

    If you are interested please let me know and I can provide a document on how to setup the Eclipse IDE to test the new Mango 2.5.0.