Problem
The MODE 1, after the #73 merge, relies on Vector, which allows us to insert directly to the workflow_instances and task_instances directly.
Current
Currently, we have 4 tables, 2 raw tables and 2 normalized tables. The Vector pgsql sink inserts into the tables workflow_events_raw and task_events_raw and the triggers are responsible for inserting into the normalized tables with Idempotency and other consistency and integrity guarantees.
Proposal
- Insert directly into the
workflow_instances and talk_instances directly
- Keep the triggers looking now to
workflow_instances and task_instances instead to raw tables.
Problem
The MODE 1, after the #73 merge, relies on Vector, which allows us to insert directly to the
workflow_instancesandtask_instancesdirectly.Current
Currently, we have 4 tables, 2 raw tables and 2 normalized tables. The Vector
pgsqlsink inserts into the tablesworkflow_events_rawandtask_events_rawand the triggers are responsible for inserting into the normalized tables with Idempotency and other consistency and integrity guarantees.Proposal
workflow_instancesandtalk_instancesdirectlyworkflow_instancesandtask_instancesinstead to raw tables.