一覧へ戻る
michelp/pgfsm（新しいタブで開きます）
主要言語: Python
Simple SQL finite state machine for Postgres
- star 数
- 71
- watcher 数
- 2
- fork 数
- 9
- issue 数
- 1
- 最終更新
- 2025/05/14
gem-hunter主要言語: Python
Simple SQL finite state machine for Postgres
Simple SQL finite state machine for Postgres
This is some example code on how to store a simple state machine in SQL.
There are two tables, fsm.machine and fsm.transition. The machine table has insert and update triggers to ensure that every row is in a valid state. The transition table is where transition between states are defined.
There is a pgtap test in test.sql that illustrates the technique.