MySQL | ThingSpeak Plugins | Forum

Avatar

Please consider registering
Guest

Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

Register Lost password?
sp_Feed sp_TopicIcon
MySQL
Avatar
nishaasingh29
New Member
Forum Posts: 2
sp_UserOfflineSmall Offline
1
July 25, 2017 - 3:27 pm
sp_Permalink sp_Print

Hey,

How am I supposed to send my thingspeak channel data to my MySQL database in real time?

Avatar
rw950431

Forum Posts: 252
sp_UserOfflineSmall Offline
2
July 25, 2017 - 10:46 pm
sp_Permalink sp_Print

Assuming your mysql database is exposed to the internet you could use the React (on data entry) + ThingHTTP (post channel values) to achieve that.

 

You are likely to get more information if you are more specific about your problem.

Avatar
nishaasingh29
New Member
Forum Posts: 2
sp_UserOfflineSmall Offline
3
July 26, 2017 - 12:55 am
sp_Permalink sp_Print

rw950431 said
Assuming your mysql database is exposed to the internet you could use the React (on data entry) + ThingHTTP (post channel values) to achieve that.

 

You are likely to get more information if you are more specific about your problem.  

No the database is not exposed to internet. How can I connect my channel data feed to mysql on my desktop? I have tried to import the csv values  but that does not work in real time. I want a database entry as soon as data is entered on te channel

Avatar
rw950431

Forum Posts: 252
sp_UserOfflineSmall Offline
4
July 26, 2017 - 9:33 pm
sp_Permalink sp_Print

Then you will have to poll the Thingspeak API regularly and download new data. Depends on what you mean by "real time" - within an hour? a minute? a second?

 

Where is your sensor?  Is it easier to input to mysql directly then upload to thingspeak afterwards?

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online: jacktheripper125, pudderz
21 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 252

Vinod: 164

cstapels: 96

piajola: 75

vespapierre: 63

Adarsh_Murthy: 59

Newest Members:

bbruno22

pudderz

Utkya

Poornak26

LindasHed

reddysiva

Forum Stats:

Groups: 4

Forums: 17

Topics: 1313

Posts: 4565

 

Member Stats:

Guest Posters: 1

Members: 5703

Moderators: 0

Admins: 2

Administrators: Hans, lee