Operations

Storage And Artifacts

How records, projections, artifacts, backups, and retention should be handled.

isplay stores structured records in Postgres and payloads in an artifact directory.

Tables

TablePurpose
projectsProject records and metadata.
runsRun records and status.
eventsOrdered event stream with (run_id, seq) uniqueness.
artifactsArtifact metadata.
projectionsJSONB records for higher-level objects and derived outputs.

Artifact Root

Set a durable artifact root outside disposable containers:

export ISPLAY_ARTIFACTS_DIR=/var/lib/isplay/artifacts

Artifacts are JSON payload files. The database stores object key, SHA-256, size, MIME type, compression marker, redaction state, and metadata.

Backup Rule

Back up Postgres and artifacts together. A database backup without artifacts loses payload evidence. An artifact backup without Postgres loses IDs, hashes, and relationships.

Retention Advice

  • Decide retention by project boundary.
  • Keep shorter retention for raw or weakly redacted artifacts.
  • Keep analysis outputs and aggregate metrics longer when policy permits.
  • Treat deletion as evidence deletion; avoid partial deletion that leaves misleading records.

On this page