ThingSpeak is an open source “Internet of Things” application and API to store and retrieve data from things using HTTP over the Internet or via a Local Area Network. With ThingSpeak, you can create sensor logging applications, location tracking applications, and a social network of things with status updates.
In addition to storing and retrieving numeric and alphanumeric data, the ThingSpeak API allows for numeric data processing such as timescaling, averaging, median, summing, and rounding. Each ThingSpeak Channel supports data entries of up to 8 data fields, latitude, longitude, elevation, and status. The channel feeds support JSON, XML, and CSV formats for integration into applications.
The ThingSpeak application also features time zone management, read/write API key management and JavaScript-based charts from Highslide Software / Torstein Hønsi.
Support for ThingSpeak is available on the ThingSpeak Community site which features a Blog, Forum, Documentation, and Tutorials.
1. Install Ruby, RubyGems, Rails 3, git, and a database like MySQL
2. Download the application using git: git clone [email protected]:iobridge/thingspeak.git
3. Change to the thingspeak directory and install the appropriate gems: sudo bundle install
1. Set your database configuration file at config/database.yml (see config/database.yml.example for an example)
2. Create the database: rake db:create
3. Create the database tables: rake db:schema:load
1. Start the server: rails server
Your application will now be running at http://localhost:3000/
Make changes to config/locales/en.yml
To avoid errors, please ensure your lines start with spaces, not tabs.
Set your application name using the ‘application_name’ key.
Please see our official memcached fork
By default the application will accept channel updates via GET or POST. To only allow POSTs, change the value of GET_SUPPORT found in config/initializers/constants.rb
Set your domain, user_name, and password in config/environment.rb
Also set your password reset link in app/controllers/mailer.controller.rb line 14 (and uncomment the line)
Start Terminal
cd ~
sudo apt-get install aptitude
sudo aptitude update
sudo aptitude install build-essential git-core curl
bash < <(curl -s https://raw.github.com/wayneeseguin/rvm/master/binscripts/rvm-installer )
echo '[[ -s "$HOME/.rvm/scripts/rvm" ]] && . "$HOME/.rvm/scripts/rvm" # Load RVM function' >> ~/.bash_profile
source .bash_profile
sudo aptitude install mysql-server libmysqlclient-dev libmysql-ruby
Note: Enter and confirm a new MySQL password
sudo aptitude install libssl-dev libopenssl-ruby libxslt1.1 libxslt1-dev libxml2 libxml2-dev rubygems
rvm pkg install openssl
rvm pkg install iconv
rvm install 1.9.2 -C --with-openssl-dir=$HOME/.rvm/usr,--with-iconv-dir=$HOME/.rvm/
rvm --default use 1.9.2
git clone git://github.com/iobridge/thingspeak.git
cd thingspeak
bundle install
gedit config/database.yml.example
Note: Change database username and password for development, test, and production databases and save the file as database.yml
rake db:create
rake db:schema:load
rails server