How to choose the best IoT Database

Question

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

Answer 1

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.