search

r-dbi / odbc

Connect to ODBC databases (using the DBI interface)
https://odbc.r-dbi.org/
Other
390 stars 107 forks source link

Provide a way to prevent the Connections pane from loading #158

Open edgararuiz-zz opened 6 years ago

edgararuiz-zz commented 6 years ago

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

jimhester commented 6 years ago

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

krlmlr commented 6 years ago

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?

edgararuiz-zz commented 6 years ago

@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