Writing to CouchDB/Cloudant From ESP32 Arduino

Abhishek Ghosh

By Abhishek Ghosh March 24, 2019 10:58 pm Updated on March 24, 2019

Writing to CouchDB/Cloudant From ESP32 Arduino

You’ll not get full working code in this guide but get full hints of code, resources. This guide will help to learn our regular readers in opposite direction of learning. Methodology is exactly like we did with Watson IoT platform (our GitHub repo has four sample codes). Here Are Some Tips, Resources For Writing to CouchDB/Cloudant From ESP32 Arduino. Our regular readers can recall about HTTP Post request towards IBM Watson IoT platform. In previous guide, we already written how to install CouchDB on Ubuntu cloud server. In the article on use-cases for CouchDB, we commented that with CouchDB we can omit the API development or rather middleware development part. Now look at the CouchDB documentation :

 https://docs.couchdb.org/en/stable/api/index.html

1	https://docs.couchdb.org/en/stable/api/index.html

Writing to CouchDB Cloudant From ESP32 Arduino

---

Now look at our ESP32 Arduino code with DHT11 sensor.

One of the impressive features of CouchDB has is the native support for RESTful API. In fact, it is the only way to interact with the database. CouchDB acts both like a data store and an application server. Here is documentation on update handler :

https://docs.couchdb.org/en/latest/ddocs/ddocs.html?highlight=update%20handler

1	https://docs.couchdb.org/en/latest/ddocs/ddocs.html?highlight=update%20handler

We talked about Futon on Web UI of administration :

http://guide.couchdb.org/draft/tour.html

1	http://guide.couchdb.org/draft/tour.html

Inside _design/app we can create a update handler. This inplace handler will appends a timestamp and unique id field to our data before saving it to CouchDB. First we are showing two JavaScript for parsing. This handler will also add a creator field :

function(doc, req) {
    if (!doc) {
        var data = JSON.parse(req.body);
        data['_id'] = req.uuid;
        data.creator = req.userCtx.name;
        data.ts = new Date().getTime()
    }
    return [data, req.body]
}

1

2

3

4

5

6

7

8

9

function(doc, req) {

if (!doc) {

var data = JSON.parse(req.body);

data['_id'] = req.uuid;

data.creator = req.userCtx.name;

data.ts = new Date().getTime()

}

return [data, req.body]

}

This is for t :

function(t) {
    if ('s1' == t.did) {
        t.t && t.h && t.ts && 's1' == t.did ? emit(t.ts, {
            ts: t.ts,
            t: t.t,
            h: t.h
        }) : emit(t.ts, {
            ts: t.ts,
            e: t.error
        })
    }
}

1

2

3

4

5

6

7

8

9

10

11

12

function(t) {

if ('s1' == t.did) {

t.t && t.h && t.ts && 's1' == t.did ? emit(t.ts, {

ts: t.ts,

t: t.t,

h: t.h

}) : emit(t.ts, {

ts: t.ts,

e: t.error

})

}

This guide gives the complete idea and resources to complete the above thing and create a HTML file with graph :

http://ashishware.com/CouchDbIot.shtml

1	http://ashishware.com/CouchDbIot.shtml

Coming to ESP32 Arduino code part, here are two resources :

http://blog.bitheap.net/2011/01/adding-data-to-couchdb-from-arduino.html

https://github.com/prasmussen/SensorBox/blob/master/SensorBox.ino

1

2

3

http://blog.bitheap.net/2011/01/adding-data-to-couchdb-from-arduino.html

https://github.com/prasmussen/SensorBox/blob/master/SensorBox.ino

Again, look at our ESP32 Arduino code with DHT11 sensor.

The basic thing is same and the trick to send JSON is the part we did with IBM Watson IoT :

        String payload = "{\"d\":{\"Name\":\"" DEVICE_ID "\"";

               payload += ",\"temperature\":";

               payload += temperature;

               payload += ",\"humidity\":";

               payload += humidity;

               payload += "}}";

        Serial.print("Sending payload: ");

1

2

3

4

5

6

7

8

9

10

11

12

13

String payload = "{\"d\":{\"Name\":\"" DEVICE_ID "\"";

payload += ",\"temperature\":";

payload += temperature;

payload += ",\"humidity\":";

payload += humidity;

payload += "}}";

Serial.print("Sending payload: ");

We hope that some of the readers will be successful to create own code. Who will not be successful, of course we will have full working code for them in future. There is another article which does not use Arduino but ESP32 with Lua :

https://bsmulders.com/2017/06/serverless-iot/

1	https://bsmulders.com/2017/06/serverless-iot/

About Abhishek Ghosh

Here’s what we’ve got for you which might like :

Take The Conversation Further ...

This Article Has Been Shared 3885 Times!

About Abhishek Ghosh

Here’s what we’ve got for you which might like :

Articles Related to Writing to CouchDB/Cloudant From ESP32 Arduino

Take The Conversation Further ...