Migrate hero_proc storage from SQLite to OSIS #28

New issue

Open

opened 2026-03-25 13:53:32 +00:00 by timur · 0 comments

timur commented

2026-03-25 13:53:32 +00:00

Owner

Context

Per discussion in hero_archipelagos#40, hero_proc currently uses SQLite for all persistence (jobs, runs, actions, secrets, logs). The goal is to explore migrating to OSIS as the data layer, which would:

Unify storage across the hero ecosystem
Enable auto-generated Rhai engine modules per root object type
Allow direct save/fetch of objects from OSIS in Rhai scripts
Share workflow state between hero_proc and hero_osis

Scope

Evaluate which hero_proc data models map to OSIS root objects
Design OSchema definitions for Job, Run, Action, etc.
Implement OSIS adapter alongside existing SQLite (feature flag)
Migrate existing data paths incrementally

References

hero_archipelagos#40: Intelligent automation app
hero_osis: https://forge.ourworld.tf/lhumina_code/hero_osis

This is a backlog item — not blocking the initial workflow UI implementation.

## Context Per discussion in hero_archipelagos#40, hero_proc currently uses SQLite for all persistence (jobs, runs, actions, secrets, logs). The goal is to explore migrating to OSIS as the data layer, which would: - Unify storage across the hero ecosystem - Enable auto-generated Rhai engine modules per root object type - Allow direct save/fetch of objects from OSIS in Rhai scripts - Share workflow state between hero_proc and hero_osis ## Scope - Evaluate which hero_proc data models map to OSIS root objects - Design OSchema definitions for Job, Run, Action, etc. - Implement OSIS adapter alongside existing SQLite (feature flag) - Migrate existing data paths incrementally ## References - hero_archipelagos#40: Intelligent automation app - hero_osis: https://forge.ourworld.tf/lhumina_code/hero_osis This is a **backlog** item — not blocking the initial workflow UI implementation.