Historical Transaction Groups as a general logging facility

Ignition
1

Simply put Historical Transaction Groups are a general auditing / logging facility except for the fact that they don't seem to have the capability to send to a general logging facility (only to a SQL database). It's certainly within my power to emulate a database and use an existing SQL connector.

I'm thinking of something which writes line-oriented JSON to a UDP port, although a TCP connection would do. Am I missing something?

2

After some monkeying around with MariaDB I stumbled on this:

  use test;
  create table JsonTable ( a_str varchar(32), a_int int, a_float double(12,4) )
  engine=CONNECT table_type=JSON option_list='pretty=0' lrecl=128;

which when given

  insert into JsonTable values ('bar', 43, 3.14);

produces

  {"a_str":"bar","a_int":43,"a_float":3.1400}