Похожие чаты

Hey guys. I'm working on an IoT platform. We are

using mariadb/mysql as our main database in a somewhat monolithical application.
We are storing sensor data in a single table (database within a database you could say). Since we want to abstract away device data to equalize schema across all protocols.

To also provide historical data, we have a report table. But since the name of the fields is flexible, depending on the device and its configuration, we found no other way than naming the fields 1 through 30. With a foreign key to Device.

How would you go about this? Right now our application logic needs to take care of joining device parameter data to the history table. So each column has its own relation to a device parameter. Should we now just double the amount of fields and add 1_DeviceParameterID? How would you go about this?

2 ответов

45 просмотров

Rdmbs are not great for historical data and for data that has a flexible schema. I would suggest you to see other time series oriented dbms like influxdb.

Misan- Автор вопроса
Alessandro
Rdmbs are not great for historical data and for da...

how do you bridge the foreign keys on a foreign database? :O

Похожие вопросы

Обсуждают сегодня

а через ESC-код ?
Alexey Kulakov
29
30500 за редактор? )
Владимир
47
Чёт не понял, я ж правильной функцией воспользовался чтобы вывести отладочную информацию? но что-то она не ловится
notme
18
У меня есть функция где происходит это: write_bit(buffer, 1); write_bit(buffer, 0); write_bit(buffer, 1); write_bit(buffer, 1); write_bit(buffer, 1); w...
~
13
any reference of this implementation?
BitBuddha
29
Ⓐrtto, [4/23/24 7:02 PM] Please explain more fully how it is not working exactly, and what are the steps you are taking, and what error messages come or what happens. Ⓐrtto, ...
Ezza Kezza
2
sounds like people have lost their kaspa on tradeogre... does this mean tradeogre not trustworthy?
Ezza Kezza
15
Страшнейшая правда про списки ЦБ. С первых дней жизни P2P сферы, молодые человеки, начитавшись законодательной базы и "внутренних" документов, решили, что им противостоит сер...
Foxcool
3
Недавно Google Project Zero нашёл багу в SQLite с помощью LLM, о чём достаточно было шумно в определённых интернетах, которые сопровождались рассказами, что скоро всех "ибешни...
Alex Sherbakov
5
So much speculation in the last week. So much volatility in price. This is because Hedera has a GC that isn't using the network it's governing. Why aren't people asking why a...
Summit Seeker R
9
Карта сайта