Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Expand on Pool and Shiny best practices and include custom SQL example #64

Open
landesbergn opened this issue Mar 18, 2018 · 1 comment

Comments

@landesbergn
Copy link

@landesbergn landesbergn commented Mar 18, 2018

The current pool page doesn't go into much detail about where and when to use different pool functions.

For example:

  • where/when in your shiny app to create a pool object
  • where/when to checkout connections from the pool with poolCheckout()
  • where/when to when to return connections to the pool with poolReturn()
  • where/when to close the pool using poolClose()

The current page also only has guidance when using dplyr to query, but not using custom SQL.

Addresses: https://community.rstudio.com/t/pool-and-shiny-best-practices-for-getting-custom-queries-from-database/3707/4

@jcpsantiago
Copy link

@jcpsantiago jcpsantiago commented Nov 15, 2018

+1 on adding more info about using SQL directly. I'm also still unsure how to use the pool* functions inside functions with custom SQL

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants