More arguments to dbListObjects() to narrow result set

r-dbi / dbi3

DBI revisited

https://r-dbi.github.io/dbi3

37 stars 2 forks source link

More arguments to dbListObjects() to narrow result set #15

Open krlmlr opened 6 years ago

krlmlr commented 6 years ago

Default: NA.

krlmlr commented 6 years ago

I don't remember what this was about. We already have a prefix = NULL argument. Further restricting the number of returned objects may be important for an object browser, but is discussed elsewhere.

krlmlr commented 6 years ago

Definitely, this was about filtering. I think we should:

offer an option to restrict the number of objects returned
offer ways to further restrict the objects on the database: "starts with", "ends with", "contains", ...

krlmlr commented 6 years ago

Reference: https://github.com/r-dbi/odbc/issues/158#issuecomment-375663689.

krlmlr commented 2 years ago

I no longer think dbListObjects() is a good API -- dm_meta() is more promising.