Automatically Closing Stale DuckDB Connections in Shiny

[denis-or]

Hey everyone,

I've been using DuckDB in Shiny applications, and there's one thing that has been on my mind. Occasionally, a user opens the Shiny dashboard that relies on DuckDB but never closes the application—they just leave the page open. My DuckDB instance reads with read_only=TRUE, which is fine, but I'd like these lingering connections to be automatically closed after some time.
Is there any method to force all open connections to close after a certain period?

tks

[krlmlr]

Thanks. What makes you think they are not closed? Is there a way to reproduce?