16.03.2017, 15:57
Hi
I would like to know your opinion:
I've been thinking about a new SQL server separated form the internal SQLLite. This server is going to be visible from outside and available from Lua in form of embedded SQL commands too. At the begining I asked myself what is should be good for. Then I have got these ideas:
1. There are lots of requests like "I want to export data which are not easily exportable. Graphs, Logs etc.". You can store all data you need by events.
2. From time to time you need to store global values. You can of course use the storage space but it's too simple tool.
3. Lua with their tables is a perfect tool for storing SELECT results.
4. It would be perfect for statistics operations. Like I would like to see average wind speed from the previous 10 minutes. But not in 10 minutes blocks but in time. This is not possible to do now.
5. You can fully replicate the database by standard DB tools.
6. You can easily embed tables stored in SQL database into an enterprise environment.
I would like to know your opinion:
I've been thinking about a new SQL server separated form the internal SQLLite. This server is going to be visible from outside and available from Lua in form of embedded SQL commands too. At the begining I asked myself what is should be good for. Then I have got these ideas:
1. There are lots of requests like "I want to export data which are not easily exportable. Graphs, Logs etc.". You can store all data you need by events.
2. From time to time you need to store global values. You can of course use the storage space but it's too simple tool.
3. Lua with their tables is a perfect tool for storing SELECT results.
4. It would be perfect for statistics operations. Like I would like to see average wind speed from the previous 10 minutes. But not in 10 minutes blocks but in time. This is not possible to do now.
5. You can fully replicate the database by standard DB tools.
6. You can easily embed tables stored in SQL database into an enterprise environment.
LM5Lp, firmware: 2018.08.22 and 2021.12.15, FlashSYS v2, ARMv7 Processor rev 5 (v7l), kernel 4.4.151 and 4.4.259