Solutions
Get Started
Guide
Guide Overview
Considerations
Write Effective Code
Connect to Data Sources and Systems
Manage Packages and Reproduce Environments
Secure Access
Implement Operational Patterns
Implement the Right Architecture
Gallery
Reference
Guide
Connect to Data Sources and Systems
Best Practices in Working with Databases
Other resources
Guide
Write Effective Code
Minimum Viable Python — Working with Python
Installing Python
Installing Python Packages
Python-Based Tools
Flask APIs
Dash Applications
Sending Custom Emails from Posit Connect
Reports using R Markdown
Using Python with Posit Products
Python with Jupyter Notebooks
Setting up and deploying a project with
reticulate
Connect to Data Sources and Systems
Best Practices in Working with Databases
Overview
Connect to a Database
Database Queries With R
R Packages
Using an ODBC driver
Using DBI
Using dplyr with databases
Pooling database connections in R
Tooling
Posit Professional Drivers
RStudio Connections Pane
Best practices
Selecting a database interface
Securing Deployed Content
Creating Visualizations
Enterprise-ready dashboards
Making scripts portable
Run Queries Safely
Schema selection
Securing Credentials
Setting up ODBC Drivers
Databases
Athena
Apache Impala
MongoDB
Other Databases
Microsoft SQL Server
Salesforce
Netezza
SQLite
Oracle
Apache Hive
MySQL
Amazon Redshift
MonetDB
Databricks
Cassandra
Snowflake
PostgreSQL
Teradata
Google BigQuery
Advanced
SQL translation
Connections Contract
Implementing a new backend
RStudio Connections
Other resources
Media
Accessing Data for Analytics On Workbench
Microsoft 365
Deploying Data for Content On Connect
Clients
Calling APIs on Connect from curl
Calling APIs on Connect from Node.js
Calling APIs on Connect from PHP
Calling APIs on Connect from Java
Calling APIs on Connect from Python
Calling APIs on Connect from R
Manage Packages and Reproduce Environments
Managing Packages within Posit Team
Reproducible Environments
Use Cases
Safely Upgrade Packages
Validate Your Environment
Deploy to Production
Collaborate Within a Team
Strategies
Strategy Map
Snapshot and Restore
Shared Baseline
Validated
Tools
Installing — pak/remotes
Repositories — Package Manager
Libraries — renv
R Versions
Docker
Python
Understanding Repositories and Libraries
Setting Default Repositories in Workbench
Bioconductor
Java and R
Connect Supervisor script examples
Setting Global Environment Variables
Secure Access
Content Security
Authentication in Posit Professional Products
Provisioning Users and Groups for Posit Professional Products
Configuring LDAP / Active Directory with Posit Team
Kerberos with Posit Professional Products
Implement Operational Patterns
Publishing Workflows for Connect
GitHub and GitLab Command Line Interfaces (CLIs)
Dev/Test/Prod with Posit Team
Diffable Data Science: A Demo
Options for Scheduling Data Science Tasks
Auditing and Monitoring Connect with the Connect Server API
Basic Content Usage Tracking
Interactive Content Usage Tracking
Basic Content Audit Report
Access Permissions Audit Report
Tag Usage on Connect
Audit the use of unsupported Python versions
Audit the R and Python Versions in Use on Connect
Audit Vanity URLs on Connect
Unpublished Content Audit Report
Publishing Methods for Connect
Deploying to Connect from CI/CD Pipelines
Publishing to Connect using GitLab CI/CD
Publishing to Connect using Azure Pipelines
Publishing to Connect using Bitbucket Pipelines
Publishing to Connect using Jenkins CI/CD
Publishing to Connect using GitHub Actions
Implement the Right Architecture
Running Posit Products in Containers
Configuring Python within Posit products
Considerations for Migrations
Architectures
Posit Team Architectures
Launcher
Auto-Scaling with Workbench and Kubernetes
Workbench with Slurm and Apptainer (formerly Singularity)
Sagemaker
Architecture for RStudio on SageMaker
Moving your Workbench Environment to RStudio on SageMaker
On this page
Media
Guide
Connect to Data Sources and Systems
Best Practices in Working with Databases
Other resources
Other resources
Media
A collection of talks on various R/Database related topics.
Read more
Back to top