Audit Database

Overview

Posit Workbench provides an optional Audit Database to record historical data about sessions and product usage. The Audit Database and its features are disabled by default. Setting up the Audit Database is similar to configuring the Internal Database.

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

  • SQLite
  • PostgreSQL

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

Audit Database vs. Internal Database

Workbench’s Internal Database is a database that Workbench uses to hold application data required for product functionality. It is meant to only be accessed and used by Workbench. The Audit Database is a separate database that is meant to hold historical data about the product’s usage. The two databases are kept distinctly separate in order to

  1. To prevent heavy usage of the Audit Database from negatively impacting Workbench’s access to its Internal Database, and
  2. To fully separate data about the product that may be of use or interest to an admin from application data required for core Workbench functionality
Back to top