Evokoa/pgGraph v0.1.1

v0.1.1 Release

on GitHub

v0.1.1 - Alpha Hardening Critical Paths

This release hardens pgGraph's alpha SQL contract, sync behavior, persistence path handling, Docker operations, release gates, playground coverage, and supply-chain policy.

Breaking Changes

• graph.weighted_shortest_path() now returns one SQL row per path step instead of the previous compact single-row payload.
  New row shape: step, node_table, node_table_name, node_id, edge_label, edge_weight, step_cost, total_cost.
• graph.status() now includes read_only_reason.
• graph.sync_health() is new and includes scheduler/operator fields, including read_only_reason.
• graph.build_status() and graph.maintenance_status() now include progress_phase and progress_message.
• Sync mutations against an already read-only engine now report PG012 instead of reusing PG008.

Highlights

• Added graph.sync_health() for scheduler-friendly sync and maintenance diagnostics.
• Added graph.run_scheduled_maintenance() for pg_cron or external schedulers.
• Added graph.query_freshness and graph.sync_batch_size GUCs.
• Topology reads now apply pending trigger sync by default.
• graph.aggregate() and graph.path_count_estimate() now honor freshness policy.
• Fixed durable artifact path resolution when PGDATA is not exported.
• Fixed legacy sync replay so failed legacy rows no longer block later valid rows.
• Docker image now enables pg_cron, installs graph, and schedules maintenance every 5 minutes.
• Added a heavy playground release gate validating all sidebar SQL examples.
• Pinned direct Rust/Python dependencies and Docker base image digests.
• Added a dependency update checker with a 14-day release age gate.

Docker / Ops

Docker now preloads pg_cron and graph, creates both extensions on first init, and schedules:

SELECT graph.run_scheduled_maintenance();

every 5 minutes as pggraph-maintenance.

Existing Docker volumes must be recreated to pick up the new init SQL.

Validation

Release gate coverage includes fmt, clippy, docs, unit tests, pgrx SQL tests, cargo-deny, fuzz check, package validation, fresh install smoke, metadata audit, SQLSTATE/ACL boundary tests, backup/restore, lock regressions, concurrency, synthetic release smoke, playground query validation, and pgbench sync stress.

Upgrade Notes

• Review applications using graph.weighted_shortest_path().
• Recreate Docker volumes if using the repository Docker image.
• Treat dependency checker UPDATE and REVIEW output as manual review work, not automatic upgrade approval.