How to choose the best IoT Database?

0 votes

I want to port data from my SQL Database  it to some other Database, which will be Open Source and provide me with:

  • JSON support
  • Scalability
  • Flexibility to add multiple columns automatically as per payload
  • Python and PHP Support
  • Extremely Fast Read, Write
  • Ability to export at least 6 months of data in CSV format


Thanks

Mar 1 in IoT (Internet of Things) by Shubham
• 13,250 points
40 views

1 answer to this question.

0 votes
Does your model looks like a snowflake? If yes, you may consider NoSQL, otherwise stay away of it. If you manage to model as a snowflake (and this means you are open for compromises) you may use anything like Lucene based search products, Mongo, Cassandra, etc. The fact you have timeseries doesn't qualify you for NoSQL. For example, you may have 10K devices issuing 5k message types. Specific data is redundantly recorded at device level and at message type level. In that case, because of the n:m relation, you don't have the snowflake anymore.
answered Mar 1 by Upasana
• 8,490 points

Related Questions In IoT (Internet of Things)

0 votes
1 answer
0 votes
1 answer

How to connect Raspberry Pi and lighting the LED?

You might want to try instead to ...READ MORE

answered Jul 23, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
22 views
0 votes
1 answer
0 votes
1 answer

How to tackle Security Loopholes of IoT Solutions ?

This is pretty off-topic, but I'll supply ...READ MORE

answered Aug 23, 2018 in IoT (Internet of Things) by anonymous2
• 4,260 points
36 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
60 views
0 votes
1 answer

How to use the data I receive from Azure IoT Hub?

The payload you receive will be a ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by DataKing99
• 8,100 points
62 views
0 votes
1 answer

Failure of JSON parsing in Arduino and ESP8266

I'm assuming it's because of the garbage ...READ MORE

answered Dec 24, 2018 in IoT (Internet of Things) by Upasana
• 8,490 points
207 views
0 votes
1 answer

Postman : Generating an output as a random number

Try generating your random value in the ...READ MORE

answered Feb 12 in IoT (Internet of Things) by Upasana
• 8,490 points
237 views
0 votes
1 answer
0 votes
1 answer

How to deploy Windows 10 IoT (Rasp Pi image) as a Virtual Machine

The easiest way I found is downloading ...READ MORE

answered Sep 10, 2018 in IoT (Internet of Things) by Upasana
• 8,490 points
114 views