How to set isolation level using pools?

[mmccarthy404]

I'm looking to set the isolation level of all read transactions of a pool to "READ UNCOMMITTED" while talking to our production database. I've looked into odbc's odbcSetTransactionIsolationLevel, however, it seems as though that will only work with connections directly, not pools.

Please advice on the best way to get this accomplished!

[hadley]

To support this, I think we'd need some way to register a function that's called every time a new DB connection is created.

[hadley]

Maybe onCreate() and onDestroy() arguments to the pool class?

pool <- dbPool(
  RSQLite::SQLite(),
  on_create = \(con) DBI::dbExecute(con, "SET SOMETHING")
)

[hadley]

Don't even need to change the class; just add a helper to dbPool. Implementation saved in git stash.

[schafnoir]

Just discovered the 'pool' package yesterday, and I appreciate how much it has improved the performance of my Shiny app as it interacts with a PostgreSQL database. One minor suggestion for the dbPool help page: It would be great to see the example code above with respect to how to properly use the onCreate argument. Thanks for all the great development work!