Cecil’s Data Science Blog

How to build a Docker image on Linux

Container
Docker
Whether you’re pushing to dockerhub, or building an image for local use, the process for building docker images is the same.
Nov 11, 2024
Cecil Singh

SQLite Backup & Restore Scripts

script
database
Backup and Restore scripts for SQLite databases
Sep 30, 2024
Cecil Singh

Run Shiny Applications natively via the Linux command line

Linux
Shiny
R
You may wish to run Shiny apps natively via the command line to help isolate code-related issues when when working with Posit Workbench or Posit Connect. Running code…
Feb 20, 2024
Cecil Singh

Memory-Based Load Balancing on Posit Workbench

load balancing
memory
linux
Posit
The default load-balancing methods on Posit Workbench largely consider CPU utilization as the determinant for routing between nodes. There may be instances where…
May 14, 2023
Cecil Singh

Testing Database Connections from the Linux Command Line

database
linux
Posit Pro drivers allow you to easily connect your Workbench & Connect servers to external databases. The steps to install these drivers can be found here…
May 3, 2023
Cecil Singh

VScode Session Timeouts

vscode
Posit
Currently, there is not a mechanism to timeout VS code sessions natively with directives in Posit configuration files.
Mar 13, 2023
Cecil Singh

Connecting Workbench & Connect to AWS S3

AWS
S3
R
Posit
You may want to connect your Posit Workbench session to an S3 bucket to pull data from Amazon Web Services (AWS).
Feb 23, 2023
Cecil Singh

R Performance is faster on Posit Desktop than on Posit Workbench

Posit
R
You may notice that scripts execute faster on your local computer using Posit Desktop, when compared to using Posit Workbench.
Feb 9, 2023
Cecil Singh

Logrotate with Posit Teams

linux
logging
Posit
You may wish to rotate the logs on your Posit Workbench, Package Manager, or Connect server. Whether to keep log files small, or to pass these files into third party…
Jan 25, 2023
Cecil Singh

Too Many Open Files error on Posit Workbench

Posit
Linux
You may see errors in logs similar to the below when using Posit Workbench:
Nov 28, 2022
Cecil Singh

Posit Connect Reclaim Disk Space

Posit
Storage
You may notice that your Posit Connect server can start occupying a large amount of disk space as users start deploying content. There are several configuration changes can…
Sep 19, 2022
Cecil Singh

Workbench Launching to Multiple Kubernetes Clusters

Kubernetes
Posit
Yes, it is possible to have multiple Kubernetes clusters on a single Workbench instance. As long the two clusters can talk to each other, the Workbench instance can launch a…
Jul 11, 2022
Cecil Singh

Troubleshooting Postgres Connection Issues

Postgres
Database
Postgres is the logical choice as a database for many technology stacks, especially those migrating from SQLite3. However, in doing so, can introduce some new challenges to…
May 22, 2022
Cecil Singh

Troubleshooting Kubernetes Pods on AWS

AWS
Kubernetes
Linux
Ensure that you have command-line access to the AWS console to access your AWS resources. You can use the AWS CLI tool through your terminal to verify this. You can run the…
Dec 21, 2021
Cecil Singh

Connecting your Linux host to AWS EFS

AWS
EFS
Storage
This guide assumes that you are familiar with the AWS console, and that you have configured an EFS file system as per the guide below:
Dec 3, 2021
Cecil Singh

SSL with Posit Workbench + Launcher

SSL
Workbench
Launcher
Posit
It’s possible to use an SSL certificate with the launcher in Posit Workbench. This may seem appealing, but what does this mean and how does it affect the interactions with…
Nov 26, 2021
Cecil Singh
No matching items