ThingSpeak on postgres and Newbie Questions | 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
ThingSpeak on postgres and Newbie Questions
No permission to create posts
May 22, 2012
1:11 pm
Avatar
benni_75

Silver
Members
Forum Posts: 5
Member Since:
May 22, 2012
sp_UserOfflineSmall Offline

Hi,

I discovered this fabulous project and installed the version found on
https://github.com/other/thingspeak.git on a test machine for the moment it is only happiness.

But I ask myself some questions:
-Is there a version on postgres? Because I am not able to make some fine tuning in mysql.
-The three tabs plugin apps and devices and file import are not available with the version I have installed, do you know where to find them?
-Do you think that memcached is needed to 10Mio measures spread over approximately 100 channels knowing that there will be seldom more than 5 concurrent clients on the application.


May 24, 2012
3:27 pm
Avatar
Hans
Natick, MA

Admin
Forum Posts: 411
Member Since:
January 18, 2011
sp_UserOfflineSmall Offline

Benni! Glad that you found us and the GitHub release is working for you.

There are differences between what we have on our website and the open source version. The Apps and Plugins are not on GitHub (yet). We are still working on another round of new features that we will release before we get to adding new functionality to GutHub. Our intent is provide the base on which it's easy to build new components to.

I don't know of any Postgres variants. Internally we use MySQL for time-series data and Redis for queuing (to large scale).

Also, memcached is probably not needed for the applications that you are describing. Once you get to a 1000 it probably makes sense.

Let us know if you have more questions... Good luck-have fun.

May 29, 2012
4:11 pm
Avatar
benni_75

Silver
Members
Forum Posts: 5
Member Since:
May 22, 2012
sp_UserOfflineSmall Offline

Thank you for this information,

Can you describe in more detail the configuration of mysql? For example for a server 16Gb ram.

What storage engine do you use?
Do you have a sample my.cnf?

I am also very interested in using REDIS. I use Publish / Subscribe
for forwarding alarms and real-time measurements from Arduino. (unfortunately without archiving). I'm looking for more information on storing time series in REDIS with or without WEBdis, because using the native REDIS protocol in the arduino is a great idea to save space and increase efficiency.

Does the average values ​​derived for example 60 are pre-calculated and it available in a database or she are calculated on the fly during each query?

Greetings

Forum Timezone: America/New_York

Most Users Ever Online: 166

Currently Online:
17 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