Overview

Database

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.