I'm using DuckDB with Rstudio workbench. The problem I'm having is that while connection_open() works, and I get a tree view in the pane on the right, it's stuck with an old connection belonging to another db file.
To reproduce just create two DuckDB files, with 2 different tables. use connection_open(file1), then close it, then connection_open(file2).
I'm consolidating all my Duck DB databases into a single file, but Rstudio is still stuck on the old one.
Refreshing the view, quitting and restarting Rstudio does not work.
I should add that I've deleted a lot of data in .local/share/Rstudio and it's still somehow pulling in an old file's table list.