Database

Overview

Posit Workbench uses a database to store active users, and in a load balancing configuration to coordinate server status and to temporarily store browser cookies that have a valid expire time, but have been invalidated by a session sign-out. There is also a schema_version table that allows Workbench to automatically update the database schema when a newer version is installed.

Workbench supports multiple database options. Currently, the supported databases are:

  • SQLite
  • PostgreSQL

When running Posit Workbench in a load balanced configuration, you must use a PostgreSQL database, as SQLite is insufficient for managing state between multiple nodes.

The contents of the database are described in the Data Dictionary appendix. For information about hardening your database configuration, see the Hardening Guide.