Shiny DB Apps
Preface
Intended Audience
Software information
1
Use Cases for a Relational Database
2
Building and Managing Connections
2.1
Making a connection
2.2
Common Connection Problems
2.3
Executing a Query
2.4
The pool Package
2.5
Connection Summary
3
Performance
3.1
Pitfalls of Abstraction
3.2
Indexing
4
Security
4.1
Injection Attacks = Child’s Play
4.2
Breaking Down a Shiny App
4.3
Defending Against Injection
4.3.1
Paramertization and String Escaping
4.3.2
Whitelist input
4.3.3
Server Side Defense
4.3.4
Other defense layers
4.3.5
Defense in Depth
References
Published with bookdown
Building Web Applications with Shiny and SQL Server
Chapter 3
Performance