search

netoptimizer / IPTV-Analyzer

Fast MPEG2 Transport Stream Analyzer, based on Netfilter kernel module
www.iptv-analyzer.org
GNU General Public License v3.0
98 stars 55 forks source link

db: Create table for (new) event types #1

Closed netoptimizer closed 13 years ago

netoptimizer commented 13 years ago

Need a side table describing the event types, as there previously were only one event type (drops).

New event types needed soon:

Future event types, could be related to burst, jitter, PCR-clock issues.

netoptimizer commented 13 years ago

Event datatype, design discussion: We also need to consider that, potentially/theoretically, is possible for two events type to occur in the same poll cycle. Thus, either we need some kind of bit-vector so several events can be recorded together, or else the software needs to record two log_event records.

Its possible to use the MySQL "SET-type", to create a SQL bit-vector. The problem with this approach is, that each time a new event type is created, the database needs to be altered.