Overview

Database

RStudio uses the 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 RStudio to automatically update the database schema when a newer version is installed.

RStudio supports multiple database options. Currently, the supported databases are SQLite and PostgreSQL. When running RStudio 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.