[Dev] [UES] Connecting a database to dashboard
Hi, We are going to implement new gadgets(charts) in UES, for that data has to be retrieved by joining mysql database tables (at the moments which is relying on streams). I would like to know if there's a way of directly querying a database in order to get the required data for the gadgets. Thanks Regards, Chanuka. -- Chanuka Dissanayake *Software Engineer | **WSO2 Inc.*; http://wso2.com Mobile: +94 71 33 63 596 Email: chan...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [UES] Connecting a database to dashboard
On Wed, Aug 26, 2015 at 12:25 PM, Chanuka Dissanayake chan...@wso2.com wrote: Hi, We are going to implement new gadgets(charts) in UES, for that data has to be retrieved by joining mysql database tables (at the moments which is relying on streams). I would like to know if there's a way of directly querying a database in order to get the required data for the gadgets. What do you mean by directly querying a database? Do you want to poll the data from the database into the gadget or just one time retrieval? Please have a look at [1] and [2]. Might be useful. [1] http://jaggeryjs.org/documentation.jag?api=rdb [2] https://docs.wso2.com/display/UES100/Creating+WebSocket+Enabled+Gadgets Thanks, Tanya Thanks Regards, Chanuka. -- Chanuka Dissanayake *Software Engineer | **WSO2 Inc.*; http://wso2.com Mobile: +94 71 33 63 596 Email: chan...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Tanya Madurapperuma Senior Software Engineer, WSO2 Inc. : wso2.com Mobile : +94718184439 Blog : http://tanyamadurapperuma.blogspot.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] [UES] Connecting a database to dashboard
Hi Tanya, Thanks for the information. What I meant is, at the moment gadgets are retrieving the data via streams right? So if we want to query the data by joining few tables how can we do that, and it's not one time retrieval we need to poll the data. Regards, Chanuka. On Wed, Aug 26, 2015 at 12:41 PM, Tanya Madurapperuma ta...@wso2.com wrote: On Wed, Aug 26, 2015 at 12:25 PM, Chanuka Dissanayake chan...@wso2.com wrote: Hi, We are going to implement new gadgets(charts) in UES, for that data has to be retrieved by joining mysql database tables (at the moments which is relying on streams). I would like to know if there's a way of directly querying a database in order to get the required data for the gadgets. What do you mean by directly querying a database? Do you want to poll the data from the database into the gadget or just one time retrieval? Please have a look at [1] and [2]. Might be useful. [1] http://jaggeryjs.org/documentation.jag?api=rdb [2] https://docs.wso2.com/display/UES100/Creating+WebSocket+Enabled+Gadgets Thanks, Tanya Thanks Regards, Chanuka. -- Chanuka Dissanayake *Software Engineer | **WSO2 Inc.*; http://wso2.com Mobile: +94 71 33 63 596 Email: chan...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Tanya Madurapperuma Senior Software Engineer, WSO2 Inc. : wso2.com Mobile : +94718184439 Blog : http://tanyamadurapperuma.blogspot.com -- Chanuka Dissanayake *Software Engineer | **WSO2 Inc.*; http://wso2.com Mobile: +94 71 33 63 596 Email: chan...@wso2.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev