MySQL | ThingSpeak Plugins | Forum

Avatar

Please consider registering
Guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





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

sp_Feed sp_TopicIcon
MySQL
No permission to create posts
July 25, 2017
3:27 pm
Avatar
nishaasingh29
New Member
Members
Forum Posts: 2
Member Since:
July 25, 2017
sp_UserOfflineSmall Offline

Hey,

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

July 25, 2017
10:46 pm
Avatar
rw950431

Top
Members
Forum Posts: 271
Member Since:
January 30, 2014
sp_UserOfflineSmall Offline

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.

July 26, 2017
12:55 am
Avatar
nishaasingh29
New Member
Members
Forum Posts: 2
Member Since:
July 25, 2017
sp_UserOfflineSmall Offline

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

July 26, 2017
9:33 pm
Avatar
rw950431

Top
Members
Forum Posts: 271
Member Since:
January 30, 2014
sp_UserOfflineSmall Offline

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:
27 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 261

Vinod: 196

piajola: 85

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 5703

Moderators: 0

Admins: 2

Forum Stats:

Groups: 4

Forums: 17

Topics: 1313

Posts: 4565

Newest Members:

James181, kimberlypg2, JamesAdorb, waynesmith, paulettebw60, ashleytb4

Administrators: Hans: 387, lee: 457