odbc icon indicating copy to clipboard operation
odbc copied to clipboard

Provide a way to prevent the Connections pane from loading

Open edgararuiz-zz opened this issue 7 years ago • 3 comments

The idea is to provide an argument that will prevent odbc from activating the RStudio Connections pane, so database servers with a large number of items does not overwhelm the R session.

We talked about this during work-week with @jimhester and @krlmlr

A user recently posted the same request to the community, so I went ahead and opened this issue: https://community.rstudio.com/t/db-connection-through-dbi-is-too-slow-for-large-db/5550/1

edgararuiz-zz avatar Feb 27 '18 00:02 edgararuiz-zz

Are we sure we want this and not just better documentation on setting options("connectionObserver" = NULL)?

jimhester avatar Mar 22 '18 18:03 jimhester

Is this something we need to keep in mind for dbListObjects()? Maybe an n argument that allows restricting the number of fetched items, or a starts_with argument that allows narrowing the scope?

krlmlr avatar Mar 23 '18 09:03 krlmlr

@jimhester - Either way works for me, just let me know and I can add an example on the site as well if you decide to go with documentation.

@krlmlr - That would be great, it would have applications beyond odbc

edgararuiz-zz avatar Mar 23 '18 13:03 edgararuiz-zz