Batabase access | GitHub Installation | 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
Batabase access
No permission to create posts
February 2, 2014
10:41 am
Avatar
Pablo Estevez
New Member
Members
Forum Posts: 1
Member Since:
February 2, 2014
sp_UserOfflineSmall Offline

Hello,

My question is about the channels of access that external applications can have to the internal database of ThingSpeak.
If I understand well, the database is implemented using MySQL, so the main question is if it is possible to directly interact with that database from a different software, and/or what methods are available to extract data from that database to external software.

I have read in the forums that there are commands in the API to export JSON, XML, or CSV files. Those would indeed be useful, but I'm looking for something more integrated, where hopefully I could directly interrogate the mySQL database from my application. This would allow me to do real-time statistical analysis, create my own visualizations, generate separate channels to add data to the database (for instance adding data from another database, joining two sensor networks), etc. I could always make regular requests to ThingSpeak to get new data and update a separate copy of the database, but that doesn't seem very efficient and would be prone to errors.
I can imagine this is easier to do in a self-hosted system, which wouldn't be a problem for me. In that case, would I be able to directly access the database from separate programs running in the same server? or would I have to integrate my modules into the ThingSpeak code?

By the way, I'm still assessing if ThingSpeak is the right platform for my project, and therefore do not have yet experience on using your system or your API.

February 2, 2014
5:22 pm
Avatar
lee

Admin
Forum Posts: 457
Member Since:
March 14, 2011
sp_UserOfflineSmall Offline

Hi,

For security and performance reasons we cannot allow direct access to our database.

However, if you install ThingSpeak and MySQL locally or on a server you control, you can certainly use any third-party tools you want to connect to MySQL and perform queries or analyses on the database. Your modules would not have to be integrated into the ThingSpeak code.

lee

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
13 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 272

Vinod: 240

piajola: 95

turgo: 70

vespapierre: 63

Adarsh_Murthy: 62

Member Stats:

Guest Posters: 1

Members: 8665

Moderators: 1

Admins: 2

Forum Stats:

Groups: 3

Forums: 14

Topics: 1600

Posts: 5760

Newest Members:

khanhNguyen_CT, susyburr, quijano__, meosuckhoe, briskpanda, Dejw0089

Moderators: cstapels: 460

Administrators: Hans: 405, lee: 457