pg_statecharts_dev
pg_statecharts : SCXML import and migration tooling for pg_statecharts
Overview
| ID | Extension | Package | Version | Category | License | Language |
|---|---|---|---|---|---|---|
| 2696 | pg_statecharts_dev | pg_statecharts | 0.1.0 |
FEAT | MIT | SQL |
| Attribute | Has Binary | Has Library | Need Load | Has DDL | Relocatable | Trusted |
|---|---|---|---|---|---|---|
| ----d-- | No | No | No | Yes | no | no |
| Relationships | |
|---|---|
| Schemas | fsm |
| Requires | pg_statecharts |
| Siblings | pg_statecharts |
Packages
| Linux / PG | PG19 | PG18 | PG17 | PG16 | PG15 |
|---|---|---|---|---|---|
| el8.x86_64 | N/A | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| el8.aarch64 | N/A | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| el9.x86_64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| el9.aarch64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| el10.x86_64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| el10.aarch64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| d12.x86_64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| d12.aarch64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| d13.x86_64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| d13.aarch64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| u22.x86_64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| u22.aarch64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| u24.x86_64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| u24.aarch64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| u26.x86_64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
| u26.aarch64 | MISS | PIGSTY 0.1.0 | PIGSTY 0.1.0 | PIGSTY 0.1.0 | N/A |
Source
github.com/kronor-io/statecharts
pg_statecharts-0.1.0.tar.gz
Install
Make sure PGDG and PIGSTY repo available:
Install this extension with pig:
Create this extension with:
Usage
Sources:
pg_statecharts_dev 0.1.0 is the development companion to pg_statecharts. It imports SCXML definitions and generates Sqitch migrations. The production state-machine runtime does not need this file-access tooling.
Core Workflow
After installing the runtime and its dependency, enable the companion:
The source directory is on the database host. Statechart callbacks must exist with the expected signatures. Parse or validation failures roll back the import transaction instead of accepting part of a chart.
Migration Generation
Create the destination directories before generation and make them accessible to the database OS user. The generator writes deploy, revert and verify scripts, updates the plan, and can overwrite existing generated chart files. Review the changes before using them as application migrations.
Permissions and Boundaries
Server file reads require pg_read_server_files; writes require pg_write_server_files. These are broad privileges, not a sandbox restricted to the supplied path. Restrict the extension and roles to a controlled development database. It shares the fsm schema, is pure SQL and requires no preload; PostgreSQL 16–18 are the documented test targets.
Use the runtime’s current semantic-version helpers in generated migrations. For old migrations that cast to the removed semver type, follow the upstream migration guide; regenerating every historical chart can introduce callback-order failures. Deploy reviewed generated SQL to production without installing this companion there.