closing database connection when closing shiny app

[strigo]

If I close a database pool when ending a session all remainig user with an open app will lose their database connection.

session$onSessionEnded(function() {
  observe({
    pool::poolClose(db_connex)
    pool::poolClose(con_postgres)
          })

  })

Is there a way to avoid this habbit?
Will the pool close its open connection when gc runs?

[agus]

Hey there!

I think you might wanna check out session$onStop. It allows you to register a callback that will be executed when the app exits.

FYI, there is a typo on the code snippet (it says "poolColse": pool::poolColse(con_postgres))

---

This post was published by an Appsilon team member. Our company can help you get the most out of RShiny and Posit/RStudio products.

Check our open positions here.

Appsilon: Building impactful RShiny Dashboards and providing R coding services.

[strigo]

Hello tested. works as expected I put the callback Function into my global.R file

con_sql_server <-   pool::dbPool(drv = odbc::odbc(), dsn = "my_dsn",
                      Uid = "my_uid",
                      Pwd = "my_pwd")

con_postgres <-   pool::dbPool(drv = odbc::odbc(), dsn =  "PostgreSQL")

onStop(function() {

  cat("Closing Database Connections")

  pool::poolClose(con_sql_server)
  pool::poolClose(con_postgres)

})

Thank's a lot!