How to save temperature data from temperature sensor into database?

niceseb · October 29, 2015, 6:32pm

electricimp/reference/blob/master/hardware/DHT22/dht22.device.nut

// Copyright (c) 2014 Electric Imp
// This file is licensed under the MIT License
// http://opensource.org/licenses/MIT
// Class for DHT22 Temp/Humidity Sensor

const SPICLK = 937.5;
const INTERVAL = 5; // time between readings in seconds

// Class to read the DHT11/DHT22 family of temperature/humidity sensors
// See http://akizukidenshi.com/download/ds/aosong/DHT11.pdf
// These sensors us a proprietary one-wire protocol. The imp
// emulates this protocol with SPI. 
// To use:
//  - tie MOSI to MISO with a 10k resistor
//  - tie MISO to the data line on the sensor
class DHT22 {
    static STARTTIME_LOW     = 0.020000;    // 20 ms low time for start
    static STARTTIME_HIGH    = 0.000020;  // 20 us min high time for start
    static STARTTIME_SENSOR  = 0.000080;  // 80 us low / 80 us high "ACK" from sensor on START
    static MARKTIME          = 0.000050;  // 50 us low pulse between 0 or 1 marks

This file has been truncated. show original

Was thinking of using MongoLab or even Plotly but not sure where to start

Swieter · October 29, 2015, 11:25pm

Hi niceseb -

There are several ways to get data into a database. One method is if the database has a REST API, which look like a web page URL that you can the PUT or POST data to. That code would live in the Agent code of your Model.

Another method is to use something like Parse or Carriots or some of the other code libraries shown on the Electric Imp resources page. Those pieces of code make it really easy to get up and running. Look at Parse as an example.

niceseb · October 30, 2015, 10:11am

Thanks, why not use MongoLab ?

I see this Plotly tutorial, but it is using TMP36 Analog Temp Sensor, so not sure whether the setup is identical to the RHT03 Sensor:

mlseim · October 30, 2015, 7:43pm

You can get your own shared webhost account with a domain name for $40 (the first year eg. cleverdot.com). With that you can use PHP and MySQLi to do anything you want. It’s a blank slate. To me, that seems cheaper than some of the cloud services, and with a shared webhost, you have a website all your own … to do what you want. Mongolab is $15 per month for up to 8GB. Cleverdot is $4 per month and you can program whatever you want. You can even use “niceseb.com” as your domain name!

Gerrikoio · October 30, 2015, 8:31pm

Yes nothing wrong with MongoLab. Have you seen the Electric Imp library for MongoLab. There are other libraries too for other services. As @swieter suggests there is also Parse (has library) and Carriots (although this does not have an imp library yet) cloud based options.

This will allow you to store data in a database… but then what do you want to do with the data.

For simple automated charts plus online data storage and retrieval, I suggest ThingSpeak. Here is one handy tutoral. http://community.thingspeak.com/tutorials/electric-imp/data-storage-and-retrieval-with-thingspeak/

If you want really fancy charts where you can edit then sure Plot.ly is good too.