Database
Posit Connect requires a database. You can configure Connect to use SQLite (the default) or a PostgreSQL database that you provide.
Use SQLite for single-server Posit Connect environments; the SQLite database files must reside on local storage. Use PostgreSQL for all multi-node and containerized environments.
The Database.Provider
setting controls which kind of database is in use.
; /etc/rstudio-connect/rstudio-connect.gcfg
[Database]
Provider = sqlite