Skip to main content
For production environments requiring high availability and robust data management, Figranium can be configured to use PostgreSQL instead of the default file-based storage.

​
Configuration

To enable PostgreSQL, set the following environment variables in your deployment:
VariableDescription
DB_TYPESet to postgres.
DB_POSTGRESDB_HOSTHostname of your PostgreSQL server.
DB_POSTGRESDB_PORTPort of your PostgreSQL server (default: 5432).
DB_POSTGRESDB_USERUsername for the database.
DB_POSTGRESDB_PASSWORDPassword for the database.
DB_POSTGRESDB_DATABASEName of the database to use.

​
Migration

When you switch to PostgreSQL:
  1. Automatic Setup: Figranium will automatically create the necessary tables on its first run.
  2. Data Persistence: All task metadata, execution logs, and settings will be stored in the database.
  3. Captures: Note that visual assets (screenshots/recordings) remain on the local file system or mounted volumes; only their metadata is stored in Postgres.

​
Benefits

  • Concurrency: Better handling of simultaneous task executions and UI interactions.
  • Reliability: Reduced risk of data corruption compared to plain JSON files.
  • Backups: Leverage standard PostgreSQL backup and recovery tools.