SQLite (dynamic)

SQLite dynamic database support, with REST API, events and dynamic creation of tables and columns.

Tables are automatically created with id and created fields. The id field is the primary key, and the created field is set to the current timestamp on creation.

The database can be stored with the system configuration, on the memory card or a USB storage device, and being a standard SQLite database can be edited with third party tools.

The “Fields” can be a list of fields that will be used, and these can use dot notation, where the last part is used as the field name e.g. payload.name becomes name in the table. Alternatively leaving this blank will add all fields in the message.