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, 2019 in IoT (Internet of Things) by Shubham
• 13,490 points
954 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, 2019 by Upasana
• 8,620 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,240 points
684 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,240 points
906 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,130 points
1,346 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,250 points
1,816 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,620 points
2,846 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, 2019 in IoT (Internet of Things) by Upasana
• 8,620 points
6,151 views
+1 vote
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,620 points
3,190 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP