Workflow Demo Live Q&A – December 18th!

This is the Live Q&A session for our Workflow Demo on December 18th to show how to build a Shiny app that reads from and writes to a database – using DuckDB.

The demo will be here: https://youtu.be/6AGroJb4zPM

Sara covers how to:
1. Set up a connection to DuckDB from a Shiny app
2. Query the database using R or Python
3. Use editable tables to enable users to write back to the database
4. Securely deploy your app to Posit Connect

Resources mentioned in this Q&A:
✨ Connect Authentication documentation: https://docs.posit.co/connect/user/oauth-integrations/
✨ Git backed deployment in Posit Connect: https://posit.co/blog/git-backed-deployment-in-posit-connect/
✨ shinylive: https://posit-dev.github.io/r-shinylive/
✨ Mastering Shiny Best Practices: https://mastering-shiny.org/best-practices.html#best-practices

Blogs:
✨ https://blog.stephenturner.us/p/duckdb-vs-dplyr-vs-base-r
✨ https://outsiderdata.netlify.app/posts/2024-04-10-the-truth-about-tidy-wrappers/benchmark_wrappers.html
✨ Using Posit tools with data in DuckDB, Databricks, and Snowflake: https://posit.co/blog/databases-with-posit/
✨ Creating a Shiny app that interacts with a database: https://posit.co/blog/shiny-with-databases/
✨ Appsilon has a lot of resources on the topic: https://www.appsilon.com/post/r-shiny-duckd

Please note, while the monthly Posit Team Workflow Series is usually the last Wednesday of the month – this will be a week earlier. Cheers to a festive holiday season and a fantastic year ahead for you and yours! ✨

To add future Monthly Workflow Demo events to your calendar → https://www.addevent.com/event/Eg16505674

You can view all the previous workflow demos here →
https://www.youtube.com/playlist?list=PL9HYL-VRX0oRsUB5AgNMQuKuHPpNDLBVt

Read Full Report