Back to results
michelp/pgfsm(opens in a new tab)
Language: Python
Simple SQL finite state machine for Postgres
- stars
- 71
- watchers
- 2
- forks
- 9
- open issues
- 1
- Last updated
- 05/14/2025
gem-hunterLanguage: 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.