DBI

SQL in rmarkdown

Mix SQL and R code chunks in a .Rmd file to leverage our knowledge in both languages

Building Web Applications with Shiny and SQL Server

This book supplements my presentation at the Omaha R User Group on Thursday, April 4, 2019. If you develop Shiny Applications and your back end is a relational database, then this book is for you. The demos and code snippets are written in T-SQL, Microsoft SQL Server dialect of SQL, but the core concepts are applicable across all RDBMS systems. Data Scientists using R are the primary audience. Database Developers, BI Developers, Software Engineers, Data Analysts and Managers wanting to learn more about Shiny Database applications will also benefit from the material.

sf

The reference package for spatial data management