Comments (12)
Yeah that seems reasonable to me
from dbi3.
Handled as part of r-dbi/DBItest#159.
from dbi3.
@jimhester @edgararuiz: Maybe it's more useful to return a third column type
in dbListObjects()
, with possible values "table"
, "view"
and "temporary"
? Or maybe two new columns, "is_view"
and "is_temporary"
? Do we need to provide filtering options in dbListObjects()
?
from dbi3.
There are unfortunately many more table types ODBC data sources can use than table, view and temporary
"TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM", or a data source–specific type name.
https://docs.microsoft.com/en-us/sql/odbc/reference/syntax/sqltables-function
from dbi3.
Then it would be the backend's job to interpret its own values for the table type and fit it into the categories we provide.?
from dbi3.
That's always a challenge to design, because if we do that @krlmlr , we would need a "catch-all" category for those categories we don't explicitly catalog. I'm thinking of those database types that may have their own, very unique, table designations. This is a long way to say, that if we do, we'll need an "Other" category.
from dbi3.
So maybe "type"
(character) and "temporary"
(logical), both supporting NA
for not yet specified or unknown information?
from dbi3.
dbRemoveTable()
needs a temporary
argument to make sure the right kind of table is removed with dbWriteTable(overwrite = TRUE)
.
from dbi3.
Only MySQL/MariaDB seems to support dropping temporary tables via DROP TEMPORARY TABLE
. The other two support a temp
or pg_temp
schema.
from dbi3.
This was difficult for Redshift. Need to revisit.
from dbi3.
Perhaps connections should keep track of temporary tables? Easier to do with a rewrite.
from dbi3.
We can register the temporary tables created through "official" means; it's not perfect but can help for databases that make it hard to enumerate temporary tables.
from dbi3.
Related Issues (20)
- Test for formals(dbXxx) ineffective
- Specify and test case-sensitivity for table names
- Name collision when creating tables
- Avoid hard-coded data types in queries HOT 1
- Support passing lists as arguments for queries like `SELECT a, b WHERE a IN ($1)` HOT 5
- Support arrays natively HOT 15
- Stronger guarantees for quoting literals
- Reading and writing tables with dots in name
- Rethink `immediate` argument
- Arrow/Flight SQL
- How to run tests on a user's database?
- Feature Request: Virtual connection HOT 2
- Add default dbWriteTable() method HOT 2
- Specify limits per connection or per driver
- How to create an external table in Hive? HOT 1
- Reconnection
- `dbQuoteIdentifier` should validate SQL inputs HOT 1
- Streaming multiple statements in a single dbExecute/dbQuery/etc. call HOT 1
- Default connection
- Optionally return tibbles
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbi3.