# Types of NoSQL DB

**URL:** <https://discourse.nodered.org/t/types-of-nosql-db/29870>\
**Category:** General\
**Created:** [10 July 2020 19:03 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870 "2020-07-10T19:03:43Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [10 July 2020 19:03 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/1 "2020-07-10T19:03:44Z")

</div>

Hi.  
How many types of NoSQL DB have in NR? And which is better for sensor data gathering (SQL or NoSQL)?

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [11 July 2020 10:07 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/2 "2020-07-11T10:07:24Z")

</div>

Any help?

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [11 July 2020 10:10 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/3 "2020-07-11T10:10:30Z")

</div>

> [@Martin10](#):
>
> How many types of NoSQL DB have in NR

I don't think anyone keeps a count.

Have a search on [flows.nodered.org](http://flows.nodered.org) and see what's there.

> [@Martin10](#):
>
> And which is better for sensor data gathering (SQL or NoSQL)?

It depends more what you want to do with the data after you have stored it.

Lots of people suggest InfluxDB is worth using, particular it you want to do time series queries.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [11 July 2020 12:00 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/4 "2020-07-11T12:00:25Z")

</div>

I found this  
[https://flows.nodered.org/search?term=NoSQL](https://flows.nodered.org/search?term=NoSQL)

Can you tell me more about what i can to do with the data after i have stored it? What options i have?

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [11 July 2020 13:08 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/5 "2020-07-11T13:08:32Z")

</div>

Exactly _why_ are you interested in a nosql database in particular?

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [11 July 2020 13:08 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/6 "2020-07-11T13:08:58Z")

</div>

> [@Martin10](#):
>
> Can you tell me more about what i can to do with the data after i have stored it?

Isn't that something you need to decide? Why are you collecting the data? Do you just want to display it somewhere? (Dashboard??) Do you want it to cause some other action? Do you just want to collect it because you can?

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [11 July 2020 13:56 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/7 "2020-07-11T13:56:52Z")

</div>

I want to build a weather station, and to store the sensor data for further analyze. And since i'm new to the DB sphere, i wish to explorer all the options, in order to make the best choice .

---

<div class="post-metadata">

**Author:** ![cinhcet](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/cinhcet/32/438_2.png) [@cinhcet](https://discourse.nodered.org/u/cinhcet)\
**Post date:** [11 July 2020 14:04 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/8 "2020-07-11T14:04:32Z")

</div>

There are really many options.

Have you already thought about how many sensor readings per time interval you want to store?

If you look at influxdb (as mentioned), it seems that it might be overpowered for such a simple application of storing weather data. However, if you start doing some calculations, you very quickly realize that even if you just want to store sensor readings ever 5 minutes or so, you will end up with a lot of data very quickly.  
Influxdb provides mechanisms to deal with that, for example, you can downsample old data etc.

But the most compelling advantage of influxdb compared to other databases is that many people use it exactly for the purpose of storing sensor readings, which means tools like [https://grafana.com/](https://grafana.com/) enable you to easily create a dashboard from an influxdb (grafana also has plugins for other types of databases).

However, if you come from an SQL background, influxdb can be a bit confusing first, since it seems very similar to SQL, but in reality isn't 🙂

One caveat of influxdb: Version 2 is in development at the moment, which is quite different to version 1, but currently, version 2 does not run on raspberries

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [12 July 2020 09:19 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/9 "2020-07-12T09:19:15Z")

</div>

I still not figured out the details.  
I will try the Influxdb + grafana, if it don't work i will try something else.

What do you think about mongoDB?

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [12 July 2020 12:54 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/10 "2020-07-12T12:54:22Z")

</div>

First you want to know about the available nosql nodes, but you don't know what it means, you are "new to the DB sphere" - what is the reason for a nosql database ?

If the purpose is just a weather station, any type of storage would suffice, including a simple csv or text file.

But let's say you receive reasonable amounts of data from this weatherstation, what are the most important elements of the data that you will receive: The datapoint and the timestamp of that datapoint.

The key strengths of a NOSQL database is in scalability, high availability, key/value pairs, document stores.  
The key strength of a RDBMS database is in it's relationship features.  
The key strength of influxdb is in the middle of those 2 and has features of both, but it's primary goal is to gather time(series) driven data.

Pick (wisely).

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [14 July 2020 09:38 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/11 "2020-07-14T09:38:39Z")

</div>

I want to try all options and than to decide what to do.

I've searched in the net for example of how to set up the influxdb, grafana and sensors in NR, but can't find enough simple example. Can you help me?

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [15 July 2020 13:13 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/12 "2020-07-15T13:13:07Z")

</div>

Any help?

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [15 July 2020 13:34 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/13 "2020-07-15T13:34:03Z")

</div>

Start by studying the influx docs to find how the database works, then you can use the node-red-contrib-influxdb node to write the values to the database.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [15 July 2020 13:55 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/14 "2020-07-15T13:55:21Z")

</div>

I'm looking for both practice and theory.  
I don't understand, did influxdb create local DB like sqlite, or is more like mysql?

---

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [15 July 2020 14:05 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/15 "2020-07-15T14:05:28Z")

</div>

Watch [some videos about it](https://youtu.be/JdV4x925au0?t=267).

influx can be queried similar to a sqldb, but you don't have to create the structure. Which is why i stated above that influx has features of both nosql and rdbms.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [15 July 2020 14:45 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/16 "2020-07-15T14:45:52Z")

</div>

> [@Martin10](#):
>
> I'm looking for both practice and theory.

That's why I said study the docs (theory) then have a play with the nodes (practice) to write to the database.

> [@Martin10](#):
>
> did influxdb create local DB like sqlite, or is more like mysql

You do need to install influxdb server but the database can be local.

---

<div class="post-metadata">

**Author:** ![Martin10](https://avatars.discourse-cdn.com/v4/letter/m/a587f6/32.png) [@Martin10](https://discourse.nodered.org/u/Martin10)\
**Post date:** [18 July 2020 09:20 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/17 "2020-07-18T09:20:09Z")

</div>

I learn faster via practical examples, but OK. Is there docs for influxdb in this NR site, because i don't find one?

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [18 July 2020 09:40 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/18 "2020-07-18T09:40:35Z")

</div>

There are a bunch on example flows with influxdb on the [flows.nodered.org](http://flows.nodered.org) site

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [18 July 2020 09:43 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/19 "2020-07-18T09:43:52Z")

</div>

> [@Martin10](#):
>
> docs for influxdb in this NR site

The docs for Influxdb itself (as opposed to how to use it in node-red) can be found at [InfluxDB OSS v1 Documentation](https://docs.influxdata.com/influxdb/v1.8/)  
Stick with 1.8 for the moment. There is an upcoming version 2.0 but it is still very new and not well supported yet.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [16 September 2020 09:56 UTC](https://discourse.nodered.org/t/types-of-nosql-db/29870/20 "2020-09-16T09:56:56Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.