Pre-requisites | Connecting to a database | Reading a SQL script into R | Executing the SQL query | Troubleshooting

Introduction and prerequisites | Prerequisites | What is RStudio? | How do I install dfeR? | What is an R project? | What is renv? | What is testthat? | What is a GitHub .gitignore file? | Using the create_project() function | Where to save your project | Parameters | Creating a project using code | Example use | Creating a project using the 'New Project Wizard' | Troubleshooting

Reading the summary | Proxy settings | Git SSL verification | Global .gitconfig location | GITHUB_PAT | renv download method (.Renviron) | RENV_DOWNLOAD_FILE_METHOD | RTools | .Renviron / .Rprofile location | Sharing the full output with support | Troubleshooting

Executive Summary | Why this is a game-changer for your workflow: | Under the Hood: The REST API Advantage | Prerequisites: Permissions and Authentication | Databricks Permissions | R Session Configuration | Basic Usage | What happens during execution? | Advanced Usage | Precise Data Type Mapping (Arrow Schemas) | Manual Chunking for Memory Management | Overwriting vs. Appending | Performance Benchmarks | Methodology | Key Results | Recommendation: Choosing the Right Tool | Stress Tests | The "Safety Net": Resilience at Scale | Key Results and Observations | Troubleshooting

Overview | See it in action | Installation | shinyjs dependency | A minimal working app | Component overview | Page structure and layout | Headings and text | Form inputs | Interactive components | Error handling | Data display

Overview | The cookie banner | A cookies settings page | Banner ids are global, the settings page is a module | The module UI | The module server | Wiring it together at the top level | Extending for analytics

Overview | Rich content in body components | heading_text() | Arguments | Visual size and semantic level are independent | Recommended size–level pairings | Accessibility | Heading IDs | Page titles | Why it matters | Three options | gov_text() | gov_list() | Rich content in list items | insert_text() | warning_text() | noti_banner() | Two types | When to use each component | external_link() | What the function does automatically | Descriptive link text | Grouped links | font()

Overview | gov_page() | Page width | Content width vs page width | Page-level components | skip_to_main() | cookieBanner() | header() | banner() | footer() | The main content area | The primary layout system | gov_row() | gov_box() | gov_text() | gov_layout() — legacy alternative | Multi-page dashboards | Setting up navigation links | Wiring navigation to panels | Keeping the page title in sync | Footer-only pages | Modularising the code | Complete example