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: [ Ссылка ]
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: [ Ссылка ]
✨ Git backed deployment in Posit Connect: [ Ссылка ]
✨ shinylive: [ Ссылка ]
✨ Mastering Shiny Best Practices: [ Ссылка ]
Blogs:
✨ [ Ссылка ]
✨ [ Ссылка ]
✨ Using Posit tools with data in DuckDB, Databricks, and Snowflake: [ Ссылка ]
✨ Creating a Shiny app that interacts with a database: [ Ссылка ]
✨ Appsilon has a lot of resources on the topic: [ Ссылка ]
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 → [ Ссылка ]
You can view all the previous workflow demos here →
[ Ссылка ]
Ещё видео!