Telemetry Database Handler Requirements

[jacoffey3]

What does a telemetry DB handler need to do?

• Write telem API
• Define new telemetry items when they are received
• Manage the memory usage
  • Hard maximum limit
  • Rolling cleanup on all items (typically persist values for 2 weeks maximum)
• Create and send Health and Status beacon to the radio periodically
  • Control the frequency of this
  • Most recent values only
  • Control what items are included dynamically
• Receive IP messages
• Monitor and log system events
  • Anytime an event happens on the system, it should be logged. It listens to everything.
• Process log requests
  • Handle incoming GraphQL requests
  • Stream telemetry to the source based on the request
• Telemetry categorization
  • Critical, nominal, debug
  • By subsystem

[jacoffey3]

SPIKE: Telemetry Database Requirements

[plauche]

• What does "define new telemetry items" mean?
• Log requests - Is this the same as a request for telemetry?

[jacoffey3]

"define new telemetry items" means I want to store a new telemetry item. Basically, I'm integrating a payload, and I want to start storing the internal temperature of that payload. We need a way to put it in the right place and be handled properly.

basically, just bulk telemetry

[CatGarab]

Receive IP Messages - From where and about what?

Telemetry categorization - Could the subsystem include the level of importance as a field in the telemetry message it sends? Unless you mean "for this subsystem, only store telemetry messages that are informational level or higher"

[jacoffey3]

IP - Basically GraphQL requests for telemetry and new telemetry items to log. So from everywhere.

No, because you can have subsystem items that are more/less important, and you want to log everything on the spacecraft. Importance is only used to figure out what we want to downlink.

[CatGarab]

Additional potential work item: periodically do SQLite integrity check or quick check to check for database corruption

[CatGarab]

Also: log database errors to somewhere

[jacoffey3]

Yes to both of those!

[jacoffey3]

Must autoboot....